Problem using language/region properties

Aspose.Cells Product Family
1

Hello,

I have a problem importing a csv file through the appropriate open method "workbook.Open(fileStream, FileFormatType.CSV)". Indeed, being on a french Windows XP Pro with my regional settings set to french, apparently Aspose.Cells wait after a "4,2" value in 9th column instead of "4.2".

Tried to play with windows regional settings in control panel at first and later to use with the language and region properties of workbook but it keep throwing me the same exception (french message: "Le format de la chaîne d'entrée est incorrect.").

This is what i tried so far:
workbook.Language = CountryCode.UnitedKingdom;
workbook.Region = CountryCode.UnitedKingdom;
workbook.Open(fileStream, FileFormatType.CSV);

Would you have any idea of what would be a solution?

Regards, Renaud

PS: If it helps, i just updated Aspose.Cells to v 4.4.0.5

2

Hi,

Thanks for the details,

We will check and get back to you soon.

Thank you.

3

Hi,

Thanks for considering Aspose.

I think you are using Aspose.Cells in Asp.NET project. Please change your current thread's language Culture settings to InvariantCulture.

Thank you.

4

Yeah sorry i forgot to mention the C#/ASP.NET application.
I’ll try that and get back to you.

Sincerely, Renaud

5

Thanks.