Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with save xls file to html and than back to xls | Excel Discussion (Misc queries) | |||
Save Excel file to HTML. | New Users to Excel | |||
Save single sheet from XLS file as HTML | Excel Discussion (Misc queries) | |||
Click on X in upper right corner should save FIRST the file you se | Excel Discussion (Misc queries) | |||
Displaying HTML code in .CSV file Excel 2002 | Excel Programming |