I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server.

We need to append the data from the new excel sheets to the existing lists items of the SharePoint list.

How should I go about creating a solution for this?

Let's say I have 100 records in one excel file. I have imported that file to spredsheet app. It works fine for first time. Now I have 100 records in that list. Now user has added 10 more records in that excel sheet. That 10 records I have to appends to the list which is created very first time.

  • This is a duplicate of sharepoint.stackexchange.com/q/34433/8642 – MdMazzotti Jun 2 '14 at 10:19
  • @MdMazzotti, if you feel this is a duplicate you should use the "close" button to start a vote about marking this as a duplicate – Robert Lindgren Jun 2 '14 at 10:54
  • @RobertLindgren I tried it, but apparently you cannot cast a close vote on a bounty question – MdMazzotti Jun 2 '14 at 11:01
  • @MdMazzotti, ah sorry, though your question was before the bounty! – Robert Lindgren Jun 2 '14 at 11:08
  • Removed bounty (which refunded your points) and closed as duplicate. – Eric Alexander Jun 3 '14 at 16:49

I've used OpenXml in a similar solution. This can help you: http://social.msdn.microsoft.com/Forums/vstudio/en-US/1fda82c4-a1ab-420a-86ad-682a1d6d33cb/openxml-read-excel-file After you read the data, the adding is easy.

If you need further assistance please let me know.

Not the answer you're looking for? Browse other questions tagged or ask your own question.