0.1.0 • Published 4 years ago

bsy-batch-export-excel v0.1.0

Weekly downloads
-
License
MIT
Repository
-
Last release
4 years ago

安装方法

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],
      });