Issue in Date formatting when the excel sheet is in language other than English

[deekshi_23]

Hi Team,

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”);
cell.setStyle(style);
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.

[amjad.sahi]

Hi,

Thanks for sharing the code segment and details.

Could you provide us your template CSV file, we will check it soon.

Thank you.

[amjad.sahi]

Hi,

By the way, could you try to set the formatting pattern as:

"[$-409]dd MMM yyyy HH:mm:ss"

Alternatively you may just set the region of the workbook as USA, then the output date in CSV will be in English.

Thank you.