Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey all,
I'm trying to save an Excel file to a HTML file, with interactivity. I had done this in an older version of Excel, with another machine configuration, and the output was given something like Version 1, at the bottom. As I could see, it used the progID Excel.Sheet, which generated the html code in a way that a program I use could read it perfectly and edit it. In the new version, I get something like Version 2. All the xml code now comes in a parameter called XMLData, and it's not working anymore with my program. It now uses the progID FrontPage.Editor.Document. In the older version, the XML data came distributed along the code in another manner. Is there a way to force Excel to use the Excel.Sheet prodID, or another way to make it work like it used to ? Thanks Version 1: <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40" <head <meta http-equiv=Content-Type content="text/html; charset=windows-1252" <meta name=ProgId content=Excel.Sheet <meta name=Generator content="Microsoft Excel 9" <link rel=File-List href="./TagEquipmnt~CentrifugalPump_files/filelist.xml" <link rel=Edit-Time-Data href="./TagEquipmnt~CentrifugalPump_files/editdata.mso" <link rel=OLE-Object-Data href="./TagEquipmnt~CentrifugalPump_files/oledata.mso" <!--[if gte mso 9]<xml <o:DocumentProperties <o:LastAuthorProcess & Building Solutions</o:LastAuthor <o:LastPrinted2003-04-24T10:29:20Z</o:LastPrinted <o:Created2003-04-24T10:29:54Z</o:Created <o:LastSaved2004-03-15T16:51:32Z</o:LastSaved <o:Version9.2720</o:Version </o:DocumentProperties <o:OfficeDocumentSettings <o:DownloadComponents/ <o:LocationOfComponents HRef="file:J:\Office\2000\Std\msowc.cab"/ </o:OfficeDocumentSettings </xml<![endif]-- <style <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {mso-header-data:&A; mso-footer-data:"Page &P"; margin:.98in .75in .98in .75in; mso-header-margin:.51in; mso-footer-margin:.51in;} tr {mso-height-source:auto;} col ================================================== ===================== Version 2: <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40" <head <meta http-equiv=Content-Type content="text/html; charset=windows-1252" <meta name=ProgId content=FrontPage.Editor.Document <meta name=Generator content="Microsoft Excel 11" <link rel=File-List href="TagEquipmnt~CentrifugalPump_files/filelist.xml" </head <body <!--[if !excel] <![endif]-- <!--The following information was generated by Microsoft Office Excel's Publish as Web Page wizard.-- <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.-- <!----------------------------- <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -- <!----------------------------- <div id="TagEquipmnt~CentrifugalPump_32668" align=center x:publishsource="Excel"<object id="TagEquipmnt~CentrifugalPump_32668_Spreadsheet " classid="CLSID:0002E559-0000-0000-C000-000000000046" <param name=DisplayTitleBar value=false <param name=Autofit value=true <param name=DataType value=XMLData <param name=XMLData value="<?xml version="1.0"?> <?mso-application |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically Saving an Excel Document as a Web Page | Excel Discussion (Misc queries) | |||
Excel: Automatically Saving as Web Page | Excel Discussion (Misc queries) | |||
Automatically Saving an Excel Document as a Web Page | Excel Discussion (Misc queries) | |||
Excel: Automatically Saving as Web Page | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) |