After import Xlsx, how do I get the value from a date field?

After import Xlsx, how do I get the value from a date field?

Posted by: gerry.haustein on 6 October 2020, 3:43 am EST

• 

  gerry.haustein

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 October 2020, 3:43 am EST

  After the user imports a Xlsx file (see https://www.grapecity.com/blogs/how-to-importexport-excel-files-using-javascript-and-spread-sheets#so-we-can-import-an-excel-) I need to programmatically validate the data.

  Using the debugger I was able to determine the data is in ```
  
  json.sheets.MySheet.data.dataTable

  
  Accessing ```
  .value
  ``` I can find numbers and strings, but Date fields are inaccessible, they return some weird value like /OADate(44562)/ 
  
  How can I get the javascript date object that should be there somewhere?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 7 October 2020, 1:33 am EST

  Hi,

  You may use the getValue method for getting the value from the Cell. Please refer to the following code snippet and let us know if you face any issues.

  sheet.setValue(row, col, new Date(1, 1, 1));
  console.log(sheet.getValue(row, col));
  

  API References:

  getValue : https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~getValue.html

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 7 October 2020, 1:33 am EST

  Hi,

  You may use the getValue method for getting the value from the Cell. Please refer to the following code snippet and let us know if you face any issues.

  sheet.setValue(row, col, new Date(1, 1, 1));
  console.log(sheet.getValue(row, col));
  

  API References:

  getValue : https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~getValue.html

  Regards
  
  Avinash

• 

  gerry.haustein

  • Post Options:
  • Link
    Copy

  Posted 15 October 2020, 9:02 am EST

  thanks