React 数据导出EXCEL表格

插件安装

yarn add js-export-excel

插件引入

import ExportJsonExcel from 'js-export-excel';

代码示例

按钮引用

<Button onClick={() => ExportToExcel()}>Export to Excel</Button>

定义函数

const ExportToExcel = () => {
      const data = this.state.ordersUpdated // 准备的数据
      var option = {}
      let dataTable = []
      if (data) {
        for (let i in data) {
          if (data) {
            let obj = {
              'VESSEL': data[i].vslName,  // '列名': 数据
              'ASN NUMBER': data[i].docId,
              'RECEIVE DATE': moment(data[i].stockDate).format('DD/MM/YYYY')
            }
            dataTable.push(obj);
          }
        }
      }

      option.fileName = 'order infomation'  //导出的Excel文件名
      option.datas = [
        {
          sheetData: dataTable,
          sheetName: 'sheet',
          sheetFilter: ['VESSEL', 'ASN NUMBER', 'RECEIVE DATE'],
          sheetHeader: ['VESSEL', 'ASN NUMBER', 'RECEIVE DATE'],
        }
      ]

      var toExcel = new ExportJsonExcel(option);
      toExcel.saveExcel();
    }

导出EXCEL