Publishing a static table using jscript (Excel 2007)
Hi all,
I have a single table in my xlsx file. I would like to create a [static] html (.htm) file containing this table. Keep in mind that I don't want to save the workbook or worksheet as htm (SaveAs( ..., 44 )) since it generates not a single but multiple files with [dynamic] html containing an ActiveX and allowing user to browse through sheets which I don't have more than... one. The way to see the table in the .htm form through a menu system is by doing: Save As/Other Formats selecting .mht .htm, selecting Single Web Page, and saving. The new file is the only file being saved. I believe it's called publishing. I need an jscript method. Something like that: ea = new ActiveXObject( "Excel.Application" ) ; ea.DisplayAlerts = 0 ; wb = ea.Workbooks.Open( "myfile.xlsx" ) ; ws = wb.Worksheets( "Sheet1" ) ; ws.Activate() ; ws.PivotTables( 1 ).RefreshTable ; --- here comes the function that would look like that: --- ws.SaveAs( "myfile.htm", magicnumber-but-not-44 ) ; --- I believe there could be something like this: --- ws.Publish( "myfile.htm", static ) ; wb.Close ; Thank you for any help in adance, Greg. |
Publishing a static table as html using jscript (Excel 2007)
bump
|
Publishing a static table as html using jscript (Excel 2007)
An other impatient bump. Sorry for so many so far bumps and all the
new bumps to follow. |
Publishing a static table as html using jscript (Excel 2007)
bump, eh, bump.
I noticed that there is almost nothing on the Internet on this subject, so I would not be surprized for not receiving any answer from you guys. I will keep fingers crossed, though. |
Publishing a static table as html using jscript (Excel 2007)
bumpy bump
|
Publishing a static table as html using jscript (Excel 2007)
Okay, I see the question is for an other peer of ppl.
Anyone knows where I could post this question to receive an answer for it, please? is there excel.activex group? TIA, Greg. |
Publishing a static table as html using jscript (Excel 2007)
still nothing... anyone knows what I'm talking about?
|
For Excel ActiveXObject gurus - publishing a sheet as static htmlusing jscript
I have changed the subject hoping to bring more interest...
Any help with finding a list of methods/attributes from the Excel.Application ActiveXObject would also be a big help for me. TIA, Greg. |
For Excel ActiveXObject gurus - publishing a sheet as static html using jscript
Is this a reply to something ?
Tim wrote in message ... I have changed the subject hoping to bring more interest... Any help with finding a list of methods/attributes from the Excel.Application ActiveXObject would also be a big help for me. TIA, Greg. |
For Excel ActiveXObject gurus - publishing a sheet as static htmlusing jscript
The only person replying here to something is me to myself.
Nobody is into jscript/Excel field, I guess. |
All times are GMT +1. The time now is 03:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com