I am using aspose cells 19.1 version to parse Excel in my Java code. I am using below to get values from Excel
Excel contains below formatted data: (Saturday, 10 October 2020)
Screen Shot 2021-01-13 at 5.53.07 PM.jpg (321.8 KB)
When I use xls I get 10 October 2020 as cell.getStringValue();
When I use xlsx I get proper and correct formatted data Saturday, October 10, 2020 as cell.getStringValue();
So Why does xls file gives incorrect data whereas xlsx gives proper formatted date data?
DateCustomXLS and XLSX.zip (12.6 KB)