引入插件
npm install js-export-excel
or
yarn add js-export-excel
// 直接导出文件
const ExportJsonExcel = require("js-export-excel");
import {Tooltip } from 'antd';
const onExportClick = ()=>{
let option = {};
option.fileName = "excel"; //导出的文件名
option.datas = [
{
sheetData: [//数据源
{ one: "一行一列", two: "一行二列" },
{ one: "二行一列", two: "二行二列" },
],
sheetName: "sheet",
sheetFilter: ["two", "one"],
sheetHeader: ["第一列", "第二列"], //设置表头文本,顺序与sheetFilter数组内字段按顺序对应
columnWidths: [20, 20], //行宽,可不设置
},
{
sheetData: [
{ one: "一行一列", two: "一行二列" },
{ one: "二行一列", two: "二行二列" },
],
},
];
var toExcel = new ExportJsonExcel(option); //new
toExcel.saveExcel(); //保存
}
return (
<Tooltip title="导出" mouseEnterDelay={1}>
<div
style={{ marginRight: '10px' }}
onClick={() => onExportClick(record)}
>
<i className="iconfont icon-xiajiang"></i>
</div>
</Tooltip>
)
还可以支持导出Blob,支持压缩等其他操作,暂不支持导入
参考源码git 地址链接: https://github.com/kinddde/js-export-excel