服务端返回数据前端生成文件并下载

安装xlsx

    pnpm install XLSX

引入XLSX

    import * as XLSX from 'xlsx'

具体实现

let data = dataSource.map((obj: any) => ({
  "日期": obj.date,
  "名称": obj.name
}))
let title = `财务报告.xlsx`

downLoadData（data， title）

const downLoadData = (data: any, title: string) => {
  const worksheet = XLSX.utils.json_to_sheet(data)
  const workbook = XLSX.utils.book_new()
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1')
  XLSX.writeFile(workbook, title)
}