Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publishing a static table as html using jscript (Excel 2007)
bump
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publishing a static table as html using jscript (Excel 2007)
bumpy bump
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Publishing a static table as html using jscript (Excel 2007)
still nothing... anyone knows what I'm talking about?
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
publishing Excel 2007 charts | Charts and Charting in Excel | |||
Publishing a static table as html using jscript (Excel 2007) | Excel Discussion (Misc queries) | |||
Pivot table turning static in Excel 2007 | Excel Discussion (Misc queries) | |||
Publishing a Pivot List in Excel 2007 | Excel Worksheet Functions | |||
Publishing a Table in Excel 2007 (Beta 2) to a SharePoint List | Excel Discussion (Misc queries) |