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.
--------------------
From: "Bernard O'Flynn" <be*****@nospam.sitesmith.co.za>
Subject: Saving dataset into excel
Date: Mon, 10 Nov 2003 15:51:44 -0000
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ez**************@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 213.199.128.157
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:189767
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
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.
