I am trying to read an excel file in European date format and I noticed that when Aspose reads the date the formatting is lost.
My spreadsheet has this date: 02.10.2014
getting the value using the code worksheet.Cells(row, col).StringValue returns 02/10/2014.
So trying to format that date value in european format fails. Is there a way to get the exact date value displayed in my spreadsheet which is using period(.) as the date separator?
I am using Aspose.Cells version 4.7
I hope you could assist me on this.