Error reading date from file xlsx

Questions
, ,
1

Hello everyone? Are you all doing well?

I have a small problem with N8N. Can someone help me?

Here’s the issue: I have stored my Excel file in a database. Then, I make an API Request to retrieve the row containing the file. After that, I use another API Request to fetch the file, and I use the Spreadsheet module to read the data from the file.

My problem is that I can’t get the date formats from the file. I have enabled “Read as String,” but it gives me an error. My date formats are in numbers that only Excel can translate into dates.

Capture d’écran du 2023-05-26 08-39-13
Capture d’écran du 2023-05-26 08-39-131920×1080 110 KB

Capture d’écran du 2023-05-26 08-39-01
Capture d’écran du 2023-05-26 08-39-011891×809 71.2 KB

Capture d’écran du 2023-05-26 08-40-52
Capture d’écran du 2023-05-26 08-40-521267×500 27.8 KB

Capture d’écran du 2023-05-26 08-44-05

Information on your n8n setup

  • n8n 0.225.2
  • Database using:Baserow
  • Running n8n with the execution process [own(default), main]:own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:Docker
3

Hi @Micka_Rakotomalala, I am very sorry to hear you’re having trouble :frowning:

The date format you are seeing (values such as 44562 or 44047) are no actual errors, but instead are how Excel stores dates. n8n does not have built-in functionality to automatically convert these, but you can use a Set node with a bit of Excel specific logic to process these. Check out Date serial number to normal date - #4 by MutedJam for details and please do let me know if you are still running into any trouble with this :slight_smile: