Function exportExcel

frontend/packages/common/src/hooks/excel.ts:15–40

(
    fileTitle: string,
    date: [number, number],
    sheetTitle: string,
    tableId: string,
    tableColumnConfig: (ProColumnType<T> & { eoTitle: string })[],
    tableData: T[]
  )

  }

  const exportExcel = async (
    fileTitle: string,
    date: [number, number],
    sheetTitle: string,
    tableId: string,
    tableColumnConfig: (ProColumnType<T> & { eoTitle: string })[],
    tableData: T[]
  ) => {
    const workBook = createExcel(
      sheetTitle,
      getColumns(tableId, tableColumnConfig) as ExcelJS.Column[],
      tableData || []
    )
    const fileName = getFileName(fileTitle, date)
    try {
      const buffer = await workBook.xlsx.writeBuffer()
      saveAs(
        new Blob([buffer], {
          type: 'application/octet-stream'
        }),
        `${fileName}.xlsx`
      )
    } catch (error) {
      console.error('Error exporting Excel file:', error)
    }
  }

  const getColumns = (tableId: string, tableColumnConfig: (ProColumnType<T> & { eoTitle: string })[]) => {
    let tableConfig: Record<string, { show: boolean }> | null