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