Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Programatically Import Excel data to Sharepoint List

  Asked By: Beth Chavez         Date: Sep 28, 2006      Category: Sharepoint      Views: 2028
 

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?

Tagged:              

 

1 Answer Found

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

Yes. This can be done.

Check out these two links:
www.c-sharpcorner.com/winforms/ExcelReadMG.asp

www.codeproject.com/.../FasterExcelAccessTOC.asp

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].