Back to notes
•
1 min read

Export Dataset to Excel

utils 
import { utils, writeFile } from "xlsx";

type HandleExportDataParams<TData> = {
  dataSource: Array<TData> | undefined;
  tableMapper?: (rowData: TData) => Record<string, any>;
  filename?: string;
};
const handleExportData = async <TData extends object>({
  dataSource,
  tableMapper,
  filename,
}: HandleExportDataParams) => {
  const data = [...(dataSource ?? [])];
  const mappedData = tableMapper ? data.map(tableMapper) : data;
  const worksheet = utils.json_to_sheet(mappedData);
  const workbook = utils.book_new();
  utils.book_append_sheet(workbook, worksheet, "Export");
  writeFile(workbook, ensureXlsxExtension(filename ?? "export.xlsx"), {
    compression: true,
  });
};

function ensureXlsxExtension(input: string): string {
  if (!input) return ".xlsx";
  return input.endsWith(".xlsx") ? input : input.replace(/\.[^/.]*$/, "") + ".xlsx";
}

References: