基于XLSX封装的excel导出组件(备忘)
import * as React from 'react';
import * as XLSX from 'xlsx';
import {
Button, Icon } from 'antd';
export interface ExportExcelProps {
notice: string;
fileName: string;
headers: string[] | Function; //表头
getExportData: Function;
}
export class ExportExcel extends React.Component<ExportExcelProps, any> {
handleExport = async () => {
const {
headers, fileName } = this.props
//这里是获取导出数据的函数
const exportData = await this.props.getExportData()
this.exportExcel(headers, exportData, fileName)
}
exportExcel(headers, data, fileName) {
const _headers = headers
.map((item, i) => Object.