Exporting SharePoint list records to excel sheet in moss 2007
How to export SharePoint list records to excel sheet on schedule time using Workflow or Coding.
Please anyone tell me the solution or suggest any link for this.
Thanks in Advance,
Karthiga
January 31st, 2011 5:51am
Hi,
You have to create custom timer job which will run at schedule time. You can get all the records from list using
SPListItemCollection and can save into any location in excel format.
Create custom timer job
http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx
Export to excel
http://www.etechplanet.com/blog/export-sharepoint-list-to-excel-spreadsheet-programmatically-using-c.aspx
http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/8aa3fa6d-2078-4bf7-ad9d-1ff5e689ecce
Hope it could helpCheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 6:15am
Hi Hemendra,
Thank you very much for your response.
February 1st, 2011 3:17am