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.
Unfortunately, activation email could not send to your email. Please try again.

XlsIO read culture from excel document

Thread ID:

Created:

Updated:

Platform:

Replies:

117197 Sep 2,2014 07:38 AM Sep 3,2014 08:59 AM WPF 1
loading
Tags: XlsIO
Pawel Klimczyk
Asked On September 2, 2014 07:38 AM

Hello,
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 08:59 AM

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.

Regards,

Sudha Ramachandran


CONFIRMATION

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.

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.

;