View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Code to Save HTML table as xls file on click

Joe,

My only server-side experience is with ASP or Perl, so I can't really
comment on Domino.
However, the basic concepts are the same: get whatever code creates the
original HTML table to instead create it in Excel format and send it to the
browser. If you search Google for "ASP Excel" you will find many examples
of how to do this. One method is to set the "content-type" to excel and
then just write the content as an HTML table: Excel will interpret this as a
regular worksheet.

http://www.codeave.com/asp/code.asp?u_log=40

http://archive.baarns.com/DevOnly/No...d/Intr9712.asp
http://archive.baarns.com/DevOnly/No...d/Intr9713.asp

Tim.


"Joe Black" wrote in message
...
Hi Tim,

This is a site on the Intranet and its being developed using Lotus Domino
6.5 so access to server is available.

Hope this is useful.

"Tim Williams" <saxifrax@pacbell*dot*net wrote in message
...
Is this a HTML page on the internet(or intranet) ? If you have access
to server-side coding it's pretty easy: if not it's going to be pretty
difficult. Code in the browser has no access to the user's file
system and - unless they have dangerous security settings - no
ability to create an Excel file using automation (for example).

I'm not sure this is possible using purely client-side scripting...

Tim.