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.