Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Programatically Import Excel data to Sharepoint List

  Asked By: Beth    Date: Sep 28    Category: Sharepoint    Views: 11529

I have a folder into which a new Excel Sheet is periodically copied.

Once every day I want to import the sheet data into a Sharepoint list. I know how to do this by hand, convert the data into list form and publish or merge to a sharepoint list. But what I need to do is do all this programatically.

I have a sharepoint list and want to merge new data from a normal Excel List into it. I want to be able to schedule this task to run as
soon as a new sheet is available in the target folder.

Can this be done using the Exel Object model through .Net/C#?

How would I do this?



1 Answer Found

Answer #1    Answered By: Gopal Jamakhandi     Answered On: Sep 28

Yes. This can be done.

Check out these two links:


You can specify an Excel file and book to import  data
for your SPList.

Didn't find what you were looking for? Find more on Programatically Import Excel data to Sharepoint List Or get search suggestion and latest updates.