I'm not sure if that's a question or a google search typed in the wrong place. Try this link:
Here is a CodePlex Project which imports excel data to SharePoint list, it also works for excel file stores in document library. You can get the code in following link.
And we can also import excel data to list without coding:
Or use Excel Add-in to sync SharePoint liste with Excel file.
TechNet Community Support
- Edited by Emir LiuMicrosoft contingent staff Wednesday, February 15, 2012 6:39 AM
Let me elaborate;
There is an excel file in the document library, comprising the same structure as of a custom list in share point. Task is to update the custom list from the excel file present in the document library with the help of a timer job; which is suppose to be triggerred once in 24 hours.
I hope this clarify the query.
There is an Office Excel 2007 Add-in for this . Please check the following Link - http://msdn.microsoft.com/en-us/library/bb462636(v=office.11).aspx
Hope this helps.
Thanks & Regards Posting is provided "AS IS" with no warranties, and confers no rights.
- Edited by Zoeb S Monday, February 20, 2012 1:22 AM