Ant Design Pro实现导出Excel

npm install js-export-excel

import ExportJsonExcel from "js-export-excel"

<Button onClick={this.exportExcel}>导出</Button>

   handleExport = () => {
        const { ReqDetailList } = this.props;    // 网络请求命名空间
        const{columns} = this.state;      // 需要放在state里边,Table，Columns
        const option = {};

        option.fileName = 'excel';
        option.datas = [
            {
                sheetData: ReqDetailList.data.map(item => {
                    const result = {};
                    columns.forEach(c => {
                        result[c.dataIndex] = item[c.dataIndex];
                    });
                    return result;
                }),
                sheetName: 'ExcelName',     // Excel文件名称
                sheetFilter: columns.map(item => item.dataIndex),
                sheetHeader: columns.map(item => item.title),
                columnWidths: columns.map(() => 10),
            },
        ];
        const toExcel = new ExportJsonExcel(option);
        toExcel.saveExcel();
    };