Conversion error in c# throwing exception input string was in invalid format

Question

I am facing problem while converting string to decimal. My C# code is reading the following data from an exel file and throwing me the following error

Input string was not in the correct format "-1.7999999999999999E-2".

I can't see this value in my excel value.

Example data

-1.70152
9.335628333
-150.0145233
39.159625

The c# code

TestModel.lat = Convert.ToDecimal(c.CellValue.Text);

Is my conversion correct. I am loosing out any values during the conversion. Whats the best datataype to convert to inorder to retain the original value as it is?

Note that when you're including example data, it helps to include an example which will fail.... — Jon Skeet, Dec 12 '16 at 09:21

mybirthname · Accepted Answer · 2016-12-12T09:36:55.667

2

Your approach must be:

TestModel.lat = Decimal.Parse(c.CellValue.Text, NumberStyles.Float);

Even better you should use Decimal.TryParse and you should specify InvariantCulture

decimal d = 0;
Decimal.TryParse("1.2345E-02", System.Globalization.NumberStyles.Float, CultureInfo.InvariantCulture, out d);

TestModel.lat = d;

edited Dec 12 '16 at 09:36

answered Dec 12 '16 at 09:21

mybirthname

17,949
3
31
55

@Jamiec it does in this case. – Panagiotis Kanavos Dec 12 '16 at 09:32
I *run* the code in Linqpad. AllowExponent throws. Float works – Panagiotis Kanavos Dec 12 '16 at 09:34
@Jamec your comment doesn't expect the culture to be invariant, try TryParse variant. – mybirthname Dec 12 '16 at 09:34

score -3 · Answer 2 · answered Dec 12 '16 at 09:28

-3

1) open ur excel 2) click on any cell which have this value 3)right click on cell->format cell-> select general and click ok.it will show you your original value.do changes to all cells. 4) now try to read with this file with ur code

answered Dec 12 '16 at 09:28

Trupti Bhosale

5
1

Conversion error in c# throwing exception input string was in invalid format

2 Answers2