0.1.0 • Published 4 years ago
bsy-batch-export-excel v0.1.0
安装方法
npm install bsy-batch-export-excel --save
三个参数:
bookType: 'xlsx',excel格式
filename: '123',excel名字
tHeader: [[], []],每个sheet的表头,可以为空
list: [this.list1, this.list2],每个sheet的表格数据
autoWidth: [true, true],是否excel展开
sheetName: ['sh1', 'sh2'],每个sheet名字
filterVal: [每个sheet表格数据对应的字段
['orderItemId', 'componentTypeId', 'image_uri'],
['orderItemId', 'componentTypeId', 'image_uri'],
],
#### 使用例子:
import Derive from 'bsy-batch-export-excel'
//第一个sheet
let data1 = [{ name: "张三" }, { name: "里斯" }];
let tHeader1 = [];
let filterVal1 = [];
tHeader1 = ["名字"];
filterVal1 = ["name"];
//第二个sheet
let data2 = [{ name: "张三2" }, { name: "里斯2" }, { name: "王五" }];
let tHeader2 = [];
let filterVal2 = [];
tHeader2 = ["名字2"];
filterVal2 = ["name"];
const excel = new Derive({
bookType: "xlsx",
filename: "项目信息",
tHeader: [tHeader1, tHeader2],
list: [data1, data2],
autoWidth: [true],
sheetName: ["sheet1", "sheet2"],
filterVal: [filterVal1, filterVal2],
});
0.1.0
4 years ago