Transformers, FormatDataAsArray and string to DATE

💬 App Building
,
6

I see, it looks like the XLSX library can recognize date columns as long as they are Date() objects. You might try something like data.yourColumn = data.yourColumn.map(dateString => new Date(dateString));

The following seems to work using the user table from onboarding_db:

const workbook = XLSX.utils.book_new();
const data = await sql_query.trigger();

//replace created_at column with corresponding date objects
data.created_at = data.created_at.map((dateString) => new Date(dateString));

const sheet = XLSX.utils.json_to_sheet(formatDataAsArray(data), {
  cellDates: true,
});
XLSX.utils.book_append_sheet(workbook, sheet, "Dates");

const base64Download = XLSX.write(workbook, { type: "base64" });
utils.downloadFile({ base64Binary: base64Download }, "test", "xlsx");

1484×610 309 KB

Does that work?