Saving Excel to CSV changes date formatting

[Paul Meems]

I have a Dutch Excelsheet which I save as a CSV-file.

On my local (Dutch) dev environment a cell value of `27-8-1990` is converted to CSV as `27-8-1990` which is expected.

My code needs to run on Azure and then the same value is converted to `8/27/1990` which is unexpected.

How can I tell the export not to alter my formatting?

Thanks,

Paul

[Abirami Varadharajan]

Hi Paul, 

Greetings from Syncfusion. 

We suspect that the azure machine is running in US culture which may cause change in date format to US culture as ‘8/27/1990’. As per Microsoft Excel behaviour, the default date format is updated according to the machine culture. So, we request you to change the culture as Dutch using below code snippet before initializing ExcelEngine to resolve the issue. 

Code Example: 

            System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("nl-NL"); 

            System.Threading.Thread.CurrentThread.CurrentUICulture = new CultureInfo("nl-NL"); 

                  

                         ExcelEngine excelEngine = new ExcelEngine(); 

            IApplication application = excelEngine.Excel; 

Kindly try this and let us know if this resolves issue at your end. 

Regards, 

Abirami 

[Paul Meems]

I've fixed it now by expanding my parse date method.

I don't feel comfortable changing the culture on the thread, for now it is OK.

This issue can be closed.

[Abirami Varadharajan]

Hi Paul, 

Thank you for updating us. 

We are glad that your issue is resolved. Please let us know if you need further assistance. 

Regards, 

Abirami

[Amey]

Can you please post your solution?

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Amey, 

Greetings from Syncfusion. 

We have already posted solution for this forum query. If you facing different scenario, we request you to post your query and version details of Syncfusion XlsIO for investigation. 

Regards, 

Keerthi.