安装插件js-export-excel
yarn安装-记得以管理员身份执行
yarn add js-export-excel
npm安装
npm install js-export-excel
页面导入
页面导入
import CreateExcel from 'js-export-excel';
按钮
<Button style={{margin:'0 0 0 25px'}} onClick={this.download}>导出Excel表格</Button>
调用
download = () => {
let data=this.state.data;
let option={};
let dataTable=[];
option.fileName = '报销人员'; //excel文件名称
data.map(v=>{
dataTable.push({
'姓名': v.name,
'密码': v.password,
'部门': v.department,
'身份证': v.idcard,
'社保卡': v.sscard,
'银行卡': v.bankcard,
})
});
option.datas=[
{
sheetData:dataTable,
sheetName:'sheet',
sheetFilter: ["姓名", "密码", "部门", "身份证", "社保卡", "银行卡"],
sheetHeader: ["姓名", "密码", "部门", "身份证", "社保卡", "银行卡"],
}
];
let toExcel = new CreateExcel(option);
toExcel.saveExcel()
};
结果