使用



import Derive from "@yck-web/more-sheet-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],

      });

npm install @yck-web/more-sheet-excel

$3

使用



import Derive from "@yck-web/more-sheet-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],

      });