# gm-excel-parser

**Repository Path**: goodman3git/gm-excel-parser

## Basic Information

- **Project Name**: gm-excel-parser
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2018-01-26
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 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);
});
```

//按模板导出
```$xslt
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');
});
```