Re: start client excel application from web

From: Lucas Tam (REMOVEnntp_at_rogers.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 06:56:10 GMT

"Grey" <erickwyum@i-cable.com> wrote in news:ez1NsnroEHA.536
@TK2MSFTNGP11.phx.gbl:

> Is it possible to do that??

Yes - take a look at the Microsoft Office Primary Interops. You'll need to
dynamically create the Excel file, load it with data, then stream it to the
client.

The streaming part is trival, there are plenty examples on how to do
that... the tough part is generating an Excel file dynamically.

BTW, can you use a server side component instead? It maybe better to
generate the pivot table on the server side, let the user preview the
graph, then allow them to download the excel dataset if they like what they
see. 

-- 
Lucas Tam (REMOVEnntp@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Relevant Pages

  • RE: Impersonate
    ... There is a common function that extract a value ... from a sql table, and stream it as Excel file to the user. ... what's y our current code that stream out the excel file? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: start client excel application from web
    ... What server side componenet I can use?? ... > dynamically create the Excel file, load it with data, then stream it to ... the tough part is generating an Excel file dynamically. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Import Excel Spreadsheet into ASP.NET without Office on server
    ... Upload the excel file to the server ... Load the excel file into a dataset: ... on the server, and I don't know where to start. ...
    (microsoft.public.dotnet.general)
  • Re: How to decide if an excel file has got VBA code in it ?
    ... I am looking for a way to decide whether an excel file has got some VBA code ... How can i achieve this without opening the excel file and macros. ... Every XLS file is in fact OLE2 Compound File/Document, ... stream names for macro stream name. ...
    (microsoft.public.excel.misc)
  • Event service attachments
    ... The bottomline of my goal is to read in an excel file send to a certain ... My first problem is how to read in the excel file without having to ... save it to disk. ... stream and read into that stream. ...
    (microsoft.public.exchange.admin)