React - read dates from excel file

Question

I am having a weird issue when I was reading dates from excel files in a react application. When I read it, it comes out as some form of float but what's weird is that it only does this for 1th to 12th date of the month from 13th till 31th is fine.

What I mean is that a date like 01-01-81 gets converted to 29587.00013888889 but 13-01-81 remains in its original.

I found this one solution from here How to read date from an excel file in JavaScript. But it does not give back the original value.

Really appreciate any kind of help. Cheers.

ahsan mukhtar · Accepted Answer · 2021-06-24 10:41:28Z

6

The problem was that excel has its own way for dates and we need to convert it, into the format we need. This is the method I used

const ExcelDateToJSDate = (date) => {
        let converted_date = new Date(Math.round((date - 25569) * 864e5));
        converted_date = String(converted_date).slice(4, 15)
        date = converted_date.split(" ")
        let day = date[1];
        let month = date[0];
        month = "JanFebMarAprMayJunJulAugSepOctNovDec".indexOf(month) / 3 + 1
        if (month.toString().length <= 1)
            month = '0' + month
        let year = date[2];
        return String(day + '-' + month + '-' + year.slice(2, 4))
    }

You can simply pass the excel date and change the function according to the date format you need.

answered Jun 24, 2021 at 10:41

ahsan mukhtar

4428 silver badges23 bronze badges

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

Comments

Shakti · Accepted Answer · 2023-12-23 00:01:25Z

0

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

React - read dates from excel file

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related