How to read date from an excel file in JavaScript

Question

How to read date from an excel file in JavaScript ?

When I fetched a date field from excel file, it comes like some integer/floating point number, how to display the original date present in the excel file.

How are you running this JavaScript? Are you writing an Excel plugin using JS? Are you reading the file from a JS program external to Excel (e.g. a Node.js program)? What code are you using to fetch the date field? Provide a minimal reproducible example — Quentin
– Quentin, Commented Sep 28, 2020 at 16:26
Fetched external excel file using ReactJs with the help of a get api (NodeJs) — Rahul Sarma
– Rahul Sarma, Commented Sep 28, 2020 at 16:36

Rahul Sarma · Accepted Answer · 2020-09-28 16:24:11Z

-1

In JavaScript, when we fetch a date field from an excel file, it shows some integer/floating point number. To convert the number back to date, we can use the following:

install excel-date-to-js package (npm i excel-date-to-js)
Run this snippet:

   const { getJsDateFromExcel } = require("excel-date-to-js") 
   getJsDateFromExcel(dateFieldFromExcelFile)   e.g. getJsDateFromExcel(data[1][0])

answered Sep 28, 2020 at 16:24

Rahul Sarma

9642 gold badges10 silver badges20 bronze badges

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

2 Comments

Quentin Over a year ago

That module converts the date format from Excels internal format into a JS date object. It won't preserve the original date format in the spreadsheet.

Rahul Sarma Over a year ago

We'll have to convert it to the format we want, it returns in the timestamp format.

Collectives™ on Stack Overflow

How to read date from an excel file in JavaScript

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related