neo-export-excel

一个用于 excel 导出的强大函数（支持自定义样式、自定义单元格属性、多sheet，表格合并等）

Installation

You can use this package on the server side as well as the client side.

Node.js:

npm install neo-export-excel

Usage

import neoExportExcel from "neo-export-excel";

API

neoExportExcel({ name: "导出表格的名称", sheets: ObjectArray });

eg1:多sheet

var list1 = [{
                ypsj: "2020-10-10",
                tbbm: "技术科",
                score: "99.12"
            },
            {
                ypsj: "2020-10-11",
                tbbm: "办公室",
                score: "56.4"
            },
        ];
        var list2 = [{
                ypsj: "2020-10-10",
                tbbm: "技术科",
                score: "73.567"
            },
            {
                ypsj: "2020-10-11",
                tbbm: "办公室",
                score: "89"
            },
        ];
        const tHeader = [{
                key: "ypsj",
                name: "研判时间",
            },
            {
                key: "tbbm",
                name: "填报部门"
            },
            {
                key: "score",
                name: "代码",
                format: "0.00",  //单元格格式 例："0.00"代表数字保留2位小数，"@"代表文本，"Percent"代表百分比
                style:{"text-align":"right"}  //单元格样式
            },
        ];
        var excelInfo = {
            name: "这是表格的名称",
            sheets: [{
                    name: "这是sheet1",
                    content: list1,
                    tHeader: tHeader,
                },
                {
                    name: "这是sheet2",
                    content: list2,
                    tHeader: tHeader,
                },
            ],
        };
 
neoExportExcel(excelInfo);

eg2:表格合并

var content =
            `<thead>
                <tr>
                    <th>研判时间</th>
                    <th>填报部门</th>
                    <th>代码</th>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td>2020-10-22</td>
                    <td>技术科</td>
                    <td>123</td>
                </tr>
                <tr>
                    <td>2020-10-22</td>
                    <td rowspan="2">办公室</td>
                    <td>123</td>
                </tr>
                <tr>
                    <td>2020-10-22</td>
                    <td>123</td>
                </tr>
            </tbody>`
        var excelInfo = {
            name: "这是表格的名称",
            sheets: [{
                name: "这是sheet1",
                content: content,
            }],
        };
 
neoExportExcel(excelInfo);