Read from Multiple excel sheet & insert in to list

Question

Hi,

     I have multiple excel sheets which is located in document library, all those excel sheets are formatted identically. need excel values pulled from all excel sheets & inserted in to sharepoint list. 

Currently im using Nintex, is thr any other way to achieve

Thanks

Answer 1

The considerable way I would suggest is to use code to read the excel file row by row, and insert them into list.

you can use event receiver ItemAdded/ItemUpdated method to trigger the file added/updated event, then read the content of the file, do the insert action.

http://www.codeproject.com/Tips/813187/Csharp-Read-and-Write-Excel-xls-and-xlsx-Files-Con

---

Qiao Wei &lt;br/&gt; My blog:<a href="http://blog.goobol.com">http://blog.goobol.com</a>

Answer 2

Hi,

According to your description, you might want to extract values from Excel files and insert into SharePoint List.

As there is no such OOTB feature can meet your requirement, I would suggest you use custom code with Excel Web Service.

Excel Web Service will enable us access data of the Excel files which store in SharePoint Libraries:

http://msdn.microsoft.com/en-us/library/office/ff640648(v=office.14).aspx

http://msdn.microsoft.com/en-us/library/office/ms572330(v=office.14).aspx

To insert the retrieved data from Excel files into SharePoint List, SharePoint Object Model would be a good choice:

Add, Update and Delete List Items Programmatically in SharePoint

http://www.mindfiresolutions.com/Add-Update-and-Delete-List-Items-Programmatically-in-Sharepoint-372.php 

More information about SharePoint Object Model:

http://msdn.microsoft.com/en-us/library/ms473633.ASPX

Best regards,

Patrick

---

Patrick Liang
TechNet Community Support