I created xlsx file in LibreOffice Calc but I cannot make dates work.
I'm setting rows formatting as Date -> YYYY-MM-DD
When I parse file I'm still getting raw numeric value.

When I generate file by exceljs and then load it everything works ok. I can even edit rows in file in LibreOffice but I cannot add new rows. New rows are parsed as numbers.

Is it possible to hardcode or define types of columns in code?

Edit:
Sometimes text columns are parsed as dates. result: Invalid Date.