Can I avoid exceljs date formatting

Question

I'm having an issue where if I try to read a row that was originally a date, it gets converted to a number like : Last_Contact_Date: 45618 from the original 31/05/2024 in the file. Can this somehow be prevented and if not can you recommend a library to convert it to a proper date.

My worksheet is configured as follows:

const workbookReader = new ExcelJS.stream.xlsx.WorkbookReader(
    tempFilePath,
    {
        sharedStrings: "cache",
        worksheets: "emit",
    }
);

And here I'm reading the values:

        worksheet.on("row", async row => {
            //Date values are numbers
            const values = row.values.slice(1);
        });

voted for reopening, as this question is about ExcelJS, not SheetJS/xlsx — traynor
– traynor, Commented May 17 at 11:43
Yeah, en entire different library @traynor. Thanks for your answer though, It helped — kevin seda
– kevin seda, Commented May 17 at 13:01

traynor · Accepted Answer · 2025-05-16 21:28:57Z

3

Try adding styles: "cache" to the options:

const workbookReader = new ExcelJS.stream.xlsx.WorkbookReader(
    tempFilePath,
    {
        sharedStrings: "cache",
        worksheets: "emit",
        styles: "cache",
    }
);

it seems there's some problem with styles, see: [BUG] date parsing doesn't work in streaming mode #1430

edited May 16 at 21:28

answered May 16 at 21:23

traynor

10.6k3 gold badges16 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I avoid exceljs date formatting

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related