Forum Discussion

Vu_Gia_Tuan's avatar
Vu_Gia_Tuan
Copper Contributor
Jul 29, 2019

Import Excel to SharePoint List

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

 

 

No RepliesBe the first to reply

Resources