# more-sheet-excel

**Repository Path**: yck-web/more-sheet-excel

## Basic Information

- **Project Name**: more-sheet-excel
- **Description**: 多sheet导出excel表格
- **Primary Language**: JavaScript
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2021-01-11
- **Last Updated**: 2023-06-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### js导出多个sheet的excel插件

# 使用
```
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],
      });
```