react 前端导出excel 简单例子xlsx格式

安装

yarn add exceljs
yarn add file-saver

引入

import * as Excel from 'exceljs'
import FileSaver from 'file-saver'

简单例子

const exportFile=()=>{  
    const workbook = new Excel.Workbook()  
    workbook.creator = 'test'  
    let sheet = workbook.addWorksheet('报表')  
    sheet.columns = [    
        {header: '创建日期', key: 'create_time', width: 15},    
        {header: '单号', key: 'id', width: 15},    
        {header: '电话号码', key: 'phone', width: 15},    
        {header: '地址', key: 'address', width: 15}  ]  
    const data = [
        { 
            create_time: '2018-10-01',    
            id: '787818992109210',   
            phone: '11111111111',    
            address: '深圳市'  },  
        {   create_time: '2018-10-01',    
            id: '787818992109210',    
            phone: '1111',    
            address: '122'  }
    ]  
    sheet.addRows(data)  
    workbook.xlsx.writeBuffer().then(buffer => 
    FileSaver.saveAs(new Blob([buffer]), `${123}.xlsx`))
}