We have a daily requirement to import a spreadsheet on an already imported spreadsheet within sharepoint. This is to assist with daily and consistent updates, it would take too much time to add them one by one
Your help is appreciated
2
-
You want to append data to an existing spreadsheet?– James LoveMay 24, 2012 at 11:55
-
"already imported spreadsheet within sharepoint" do you mean an Excel file that's sitting in SharePoint? Or you imported an Excel file into a list and you want to update the list?– David LozziMay 24, 2012 at 12:31
Add a comment
|
1 Answer
Use ClosedXML for that. Here is a Blog Post how to get it to Work with Sharepoint
http://devmoss.wordpress.com/2011/02/23/sp-excel-docs-the-easy-way/
-
We require relevant answers and disclosure of any affiliation with products or websites (i.e. your blog). Please see May I promote products or websites I am affiliated with here? for guidelines.– SPDoctorJun 23, 2012 at 8:18