Is there a way to programmatically load a list of data from sharepoint to excel

Question

we have some data (list) stored in sharepoint. I can manually click "Actions" → "Export to Spreadsheet", and then run a bunch of code in Excel output.

Now I want to do this daily from a C # application . Is there anyway the software-automated boot process that I am doing now. (site requires authentication)

"Export to spreadsheet" runs some javascript (so it doesn't directly point directly to the url, so I can read the url directly (I don't think)

Answer 1

I would recommend getting data using SharePoint web services and then using NPOI to convert the data to an Excel spreadsheet; Use web services so that you are not limited to running the application on the server and read / write NPOI to succeed.

Answer 2

if you are not limited by advantage and can use other office products, MS-Access 2007 has very good integration with sharepoint. you can write macro and vb scripts to execute with minor adjustments.

you can also use it as a transfer application if you create a simple EXPORT TO EXCEL macro and then set it to run periodically.

Answer 3

Basic approach: You created a table with “Export to Spreadsheet” in SharePoint, the excel file contains a list associated with a list of common matches.

This is a list object in Excel that allows you to update it from the same SharePoint list later, make changes to excel, and update the SharePoint list from them. So updating your download is really updating the list that you create in Excel