We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO read culture from excel document

Thread ID:





117197 Sep 2,2014 11:38 AM UTC Sep 3,2014 12:59 PM UTC WPF 1
Tags: XlsIO
Pawel Klimczyk
Asked On September 2, 2014 11:38 AM UTC

Is it possible to read the culture from imported excel document?

In my scenario it can happen that excel documents can have values in different formats, like: "1,000.12" "1000,24" etc.

I;m having troubles parsing those values as decimals. The best would be to figure out what is the culture in Excel document and pass it to Decimal.TryParse method.

Maybe there are other workarounds ?

Sudha Ramachandran [Syncfusion]
Replied On September 3, 2014 12:59 PM UTC

Hi  Pawel,

MS-Excel does not preserve values in any specific culture and the numbers are formatted according to the machine culture. We have tried in different scenarios and are unable to reproduce the issue. It will be helpful to us to analyze further on this, if you provide some input templates.

Please let us know if you need any clarification.


Sudha Ramachandran


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon