We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Date detected as Number


Date values in E5 to E7 detected as Numeric in the attached xlsx file.

Hi Bee,

Please try the scenario against the latest version of Aspose.Cells for Java as it outputs the correct CellValueType. Please note, 1 means that the cell value of DateTime format.


Workbook book = new Workbook(dir + “date.xlsx”);
Worksheet sheet = book.getWorksheets().get(0);
Cells cells = sheet.getCells();
for (int i = 4; i < 7 ; i++)
Cell cell = cells.get(i, CellsHelper.columnNameToIndex(“E”));
System.out.println(cell.getName() + " " + cell.getType());