If it is a plain user control (no embedded activex objects) the best you can
do is read the data and push it out to the page formated with content type
excel. That will get your entire page, not your user control, as a
spreadsheet. To solve that problem, you can wrap the control in a frame and
stream the excel file to the frame instead.
On the other hand, if your user control is an activex object, OWC for
instance, you can simply read the file in from the share.
hope this helps
--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]
[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog:
http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"Peter S." <Pe****@discussions.microsoft.com> wrote in message
news:1F**********************************@microsof t.com...
I have an ASP.NET page that invokes a web control written in C#. What I
want
to do is (based on the session ID) display a certain spreadsheet that
exists
on a
network drive. I want the webcontrol to open the spreadsheet using my
log on credentials since they won't have priviliges to access their
particular
file from the network drive. BTW, I am guessing I will have to use HTTP as
this file exists in a Sharepoint document library.
I can use OLEDB but don't really want to rebuild the spreadsheet. I would
like
to open the existing one for them so they could do what they wished with
it.
It also contains many graphs and charts so I definitely would like to open
the
existing one for them. I guess I could FTP the file locally and then open
it
for them. Are there any other easier methods I can use to accomplish this?