I am using aspose cells version 17.1.0.jar and have come across this issue.
I have a excel sheet which is in Dutch Language. I have a date column in my excel sheet. I parse the sheet and write it to a csv file. The date columns in excel are of format dd/MM/yy and in csv I need the format as “dd MMM yyyy HH:mm:ss”. I have used the below code to achieve this.
com.aspose.cells.Style style= cell.getStyle();
style.setCustom(“dd MMM yyyy HH:mm:ss”);
String val = cell.getStringValue().trim();
Using the above code with the jar version 17.1.0 returns “02 mrt 2017 00:00:00” whereas the same excel file when used with version 7.7.0 jar returs the value as “02 Mar 2017 00:00:00”.
Due to this change, the date format is not properly recognized and it throws error on parsing. Please check this and let me know the solution to get the date in English.