none
How to read a excel sheet data? RRS feed

  • Question

  • Hi all,

     

    I want read excel sheet data from excel sheet and write into a sharepoint custom list programmatically.

    The custom list has the same no. of columns(also data type) that of excel sheet column.

     

    Please help me how to do that.

    Friday, August 24, 2007 6:24 AM

Answers

  • Hi Katu Dhara,

     

    You can programatically talk to SharePoint via the managed object model.  You can find details on it here:

     

    http://msdn2.microsoft.com/en-us/library/ms441339.aspx

     

    You will want to look at the SPSite, SPWeb & SPList objects to insert data into a List.

     

    I am not sure about programatically reading in the Excel data ... possibly it would be easiest to Save the spreadsheet as a CSV and then read that in line by line.

     

    Hope this helps.

     

    -Chris.

    Saturday, August 25, 2007 12:25 AM