Saving dataset into excel

  • Thread starter Thread starter Bernard O'Flynn
  • Start date Start date
B

Bernard O'Flynn

Hi
I have a pivot table that gets it data from another worksheet in the
workbook.
I need to update the data worksheet from data in a database (I'm using MS
Data Application Block) and get a dataset with the data in it.
I need to know how to open the workbook, delete all the data in the data
worksheet, update the data worksheet from the data in the dataset and then
allow the user to download the new excel workbook.

Anyone have any ideas on how to do this?

Thanks
Bernard
P.S. I've tried the standard 'set response headers to excel and render
datagird', but that doesn't allow me to have another worksheet with my pivot
table.
 
Hi Bernard,

I wish I had a solution for you. Instead, I have information that I think
you should know about, even though it does not help with your problem. In
short, Excel is not designed for use on a server. It's designed for
interactive use on each end user's machine.

For more information, please see:
257757 INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/?id=257757

Thank you, Mike
Microsoft, ASP.NET Support Professional

Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security.

This posting is provided "AS IS", with no warranties, and confers no rights.


--------------------
 
Back
Top