Hi,
After running the code below the following Exception is being thrown for the Cell AY51 when I try to get its Font: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Double.
Can you please check this out?
Thanks,
Zeljko
Code:
String path = “/home/emisia/Desktop/Test.xlsx”;
Workbook workbook = new Workbook(path);
Cell cell = workbook.getWorksheets().get(0).getCells().get(“AW51”);
System.out.println(cell.getStringValue());
Font cellFont = cell.getDisplayStyle().getFont();
cell = workbook.getWorksheets().get(0).getCells().get(“AX51”);
System.out.println(cell.getStringValue());
cellFont = cell.getDisplayStyle().getFont();
cell = workbook.getWorksheets().get(0).getCells().get(“AY51”);
System.out.println(cell.getStringValue());
cellFont = cell.getDisplayStyle().getFont();
workbook.save("/home/emisia/Desktop/TestX.xlsx");