In excel i gave the date as 22/03/2019 in conversion to json i am getting as below.

"receivedDate": 43546

how do i get the original format?

var workbook = XLSX.read(bstr, { type: "binary" });
var first_sheet_name = workbook.SheetNames[0];
var worksheet = workbook.Sheets[first_sheet_name];

resultJson = XLSX.utils.sheet_to_json(worksheet, { raw: true });

resultJson contains the output data. I need output as 22/03/2019

0 Answers