mes-dacheng-admin-backend-ui/src/utils/excel.js

import { utils, writeFile } from 'xlsx'

/**
 * 导出 excel 文件
 * @param array JSON 数组
 * @param sheetName 第一张表名
 * @param fileName 文件名
 */
export function exportExcelFile(
  array = [],
  sheetName = 'sheet1',
  fileName = 'example.xlsx'
) {
  const jsonWorkSheet = utils.json_to_sheet(array)
  const workBook = {
    SheetNames: [sheetName],
    Sheets: {
      [sheetName]: jsonWorkSheet,
    },
  }
  return writeFile(workBook, fileName)
}