WCF Services :Transfering Data from Database to Excel

Hi,

you dont' want to invoke a sp. you just want to execute it.
by means of a data layer or linq.

when you have the data in the app. you'll need to research "writing data to excel using c#" - there's 2 ways - 1 with a dependency that office needs to be installed where your app will be running - the other is a dll that gets distributed.

Anyways - your DataTable - you'll have to loop through each cell / row / column to build the content you want into the excel worksheet.

It is possible to "append" a worksheet to a existing document.

Otherwise - read the specific "worksheet" onto your app.
append your data where possible in the DataTable - add the new worksheet to the excel document - remove the previous worksheet - rename your new worksheet to the previous.
- Might be risky as other worksheets might have references to this old worksheet. But doable.

Make sure that you close the excel document in your error handler - Otherwise you need to use the task manager to kill it.

Also, avoid excel 2003 or less API's - you have a 65K limit per worksheet.

Regards,
Chris