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

Free Support Forum - aspose.com

Date detected as Number

Hi,

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 8.8.0.2 as it outputs the correct CellValueType. Please note, 1 means that the cell value of DateTime format.

Java

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());
}