I have .xlsx file which we read from c# code where we have values like 12.1456 but when we read value from c# code we are getting round value as 12 / 13. Is we have any best way to read file value as it is.
Asked
Active
Viewed 79 times
0
-
which api are you using? – Arsen Mkrtchyan Apr 18 '17 at 09:35
-
Hi Aesen. i am trying to use with oledb – Sachin Apr 18 '17 at 09:36
-
Please show us the code you use - provide us with a [mcve]. You can [edit] it into your question. With that information, maybe we can help. – S.L. Barth is on codidact.com Apr 18 '17 at 09:37
-
1Excel store in floating-point please check below code https://stackoverflow.com/questions/24454026/reading-decimal-value-from-an-excel-cell-in-c – Sachin Patil Sep 21 '19 at 13:31
1 Answers
1
Excel stores values as a double precision floating point numbers, so many times what you type in to Excel isn't precisely storable as a floating point.
Sachin Patil
- 157
- 6