Click here to Skip to main content
15,889,345 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Let's say I have an excel file consisting of the following columns, name, and data:

Filename: Data.xlsx

ID Name Last Name Age
1 Joe Doe 100
2 Ken Bone 45
3 Alicia Silverstone 38


I upload this file via a file upload interface I've created. Now, my goal is to
transfer/map the excel's file data to a Sharepoint 2010 List (People List) that has the same column names (ID, Name, Last Name, Age)

Could someone please guide me in the right direction for a simple C# code on how to obtain every cell in every row and place it where it should go on the Sharepoint 2010 People List?

Thank you.

What I have tried:

I am currently researching this particular situation.
Posted
Comments
Karthik_Mahalingam 19-Oct-16 23:56pm    
see this
http://www.mssharepointtips.com/tip.asp?id=1061

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900