Jul 29 2019 12:50 AM
Dear Supporter
My Sharepoint On-premises program have the import function.
When we click import button, we will select a excel file.
My program will read excel file and fill value to Sharepoint list.
We have an issue when reading data from excel:
1) Prepare a excel file. A cell has 0.345 value
2) Use DocumentFormat.OpenXml library to read value
3) Fill this value to Sharepoint list.
4) Confirm value in SharePoint List
Actual:
In SharePoint list will show value 0.34499999999999997
Expect:
In SharePoint list will show value 0.345
So, I want to confirm: how I can get original value 0.345 in this case?
We investigated:
DocumentFormat.OpenXml library read excel file and return 0.34499999999999997 value.
So, it will fill 0.34499999999999997 value to Sharepoint list.
Please help me !!!!
Thanks and best regards