ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code to Save HTML table as xls file on click (https://www.excelbanter.com/excel-programming/318557-code-save-html-table-xls-file-click.html)

Joe Black[_3_]

Code to Save HTML table as xls file on click
 
Hi,

I am trying to save a HTML table to an excel file. However I want this to
happen through code.

If I click a button I should have the table open in an excel instance.

TIA



Tim Williams

Code to Save HTML table as xls file on click
 
Click a button where? In excel? Where is the HTML table?

Tim


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

I am trying to save a HTML table to an excel file. However I want this to
happen through code.

If I click a button I should have the table open in an excel instance.

TIA





Joe Black[_3_]

Code to Save HTML table as xls file on click
 
Hi Tim,

I am trying to create a click button on the HTML page to perform this.
This is what I want it to do:

On click of the button, it should open another window with the HTML table in
excel file format for which I can then do File -- Save -- *.xls

TIA

"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
Click a button where? In excel? Where is the HTML table?

Tim


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

I am trying to save a HTML table to an excel file. However I want this

to
happen through code.

If I click a button I should have the table open in an excel instance.

TIA







Tim Williams

Code to Save HTML table as xls file on click
 
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.


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

I am trying to create a click button on the HTML page to perform
this.
This is what I want it to do:

On click of the button, it should open another window with the HTML
table in
excel file format for which I can then do File -- Save -- *.xls

TIA

"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
Click a button where? In excel? Where is the HTML table?

Tim


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

I am trying to save a HTML table to an excel file. However I
want this

to
happen through code.

If I click a button I should have the table open in an excel
instance.

TIA









Joe Black[_3_]

Code to Save HTML table as xls file on click
 
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.


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

I am trying to create a click button on the HTML page to perform
this.
This is what I want it to do:

On click of the button, it should open another window with the HTML
table in
excel file format for which I can then do File -- Save -- *.xls

TIA

"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
Click a button where? In excel? Where is the HTML table?

Tim


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

I am trying to save a HTML table to an excel file. However I
want this

to
happen through code.

If I click a button I should have the table open in an excel
instance.

TIA











Tim Williams

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.






All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com