2021年1月14日星期四

How Convert Date Excel From Float Nodejs

I have read Excel file by Node js using npm: read-excel-file. But the date format is a float data type. I have tried many ways but some days it works and some do not. Incorrect date example below variable _num

Please help me !!!

var _num = 44211.425405092596; // Here Excel Date data  is true : 15/01/2021  10:12:16 SA but code return is : 2021-1-18 6:5:49     convertDateExcel(_num);    function convertDateExcel (__Date) {            var splitDate =String(__Date).split('.');      var _Date = new Date(1900, 0, splitDate[0]-1, 0, 0, Math.round(splitDate[1]/1157410)).getTime()/1000      const milliseconds = _Date * 1000       const dateObject = new Date(milliseconds)      var month = dateObject.getUTCMonth() + 1;      var day = dateObject.getUTCDate();      var year = dateObject.getUTCFullYear();       var time = dateObject.getHours() + ":" + dateObject.getMinutes() + ":" + dateObject.getSeconds();      console.log( year + "-" + month + "-" + day + " time :   " + time)      //return year + "-" + month + "-" + day + "   " + time;  }
https://stackoverflow.com/questions/65730350/how-convert-date-excel-from-float-nodejs January 15, 2021 at 12:02PM

没有评论:

发表评论