Nondeterministic Programming Methodology

    gm-excel-parser

    0.1.4 • Public • Published

    gm-excel-parser

    Private excel parser tool, use at your own risk.

    // get example:

    let p = new excelParser([
        {name: '序号', type: 'integer', required: true, example: '1'},
        {name: '姓名', dataName: 'name', type: 'string', min: 1, max: 32, example: '张三'},
        {name: '电话', dataName: 'phone', type: 'string', example: '18977700000'},
        {name: '年龄', dataName: 'age', type: 'integer', example: '20'},
        {name: '性别', dataName: 'gender', type: 'enum', value: ['男', '女'], example: '男', required: true},
    ]);
    p.getExampleFile().then((result)=>{
        fs.writeFileSync('example.xlsx',result);
    });
    

    //load xlsx:

    let data = fs.readFileSync('./test.xlsx');
    p.loadFile(data).then(() => {
        return p.read()
    }).then((result) => {
        console.log(result);
    }).catch((err) => {
        console.error(err);
    });
    

    //按模板导出

    let values = {extractDate: new Date(),
        people: [
            {name: "John Smith", age: 20},
            {name: "Bob Johnson", age: 22}
        ],
        text: 'afs'
    };
    let file = fs.readFileSync(path.join(__dirname, 'formatted.xlsx'));
    p.manualExport(file,values).then((b)=>{
        fs.writeFileSync('output.xlsx', b, 'binary');
    });

    Keywords

    none

    Install

    npm i gm-excel-parser

    DownloadsWeekly Downloads

    4

    Version

    0.1.4

    License

    ISC

    Unpacked Size

    112 kB

    Total Files

    15

    Last publish

    Collaborators

    • goodman3
    • myq1991