software

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:

lt;html xmlns=quot;urn:schemas-microsoft-comfficefficequot;
xmlns:x=quot;urn:schemas-microsoft-comffice:excelquot;
xmlns=quot;www.w3.org/TR/REC-html40quot;gt;

lt;headgt;
lt;meta http-equiv=Content-Type content=quot;text/html;
charset=windows-1252quot;gt;
lt;meta name=ProgId content=Excel.Sheetgt;
lt;meta name=Generator content=quot;Microsoft Excel 9quot;gt;
lt;link rel=File-List
href=quot;./TagEquipmnt~CentrifugalPump_files/filelist.xmlquot;gt;
lt;link rel=Edit-Time-Data
href=quot;./TagEquipmnt~CentrifugalPump_files/editdata.msoquot;gt;
lt;link rel=OLE-Object-Data
href=quot;./TagEquipmnt~CentrifugalPump_files/oledata.msoquot;gt;
lt;!--[if gte mso 9]gt;lt;xmlgt;
lt;oocumentPropertiesgt;
lt;o:LastAuthorgt;Process amp;amp; Building Solutionslt;/o:LastAuthorgt;
lt;o:LastPrintedgt;2003-04-24T10:29:20Zlt;/o:LastPrintedgt;
lt;o:Createdgt;2003-04-24T10:29:54Zlt;/o:Createdgt;
lt;o:LastSavedgt;2004-03-15T16:51:32Zlt;/o:LastSavedgt;
lt;o:Versiongt;9.2720lt;/o:Versiongt;
lt;/oocumentPropertiesgt;
lt;o:OfficeDocumentSettingsgt;
lt;oownloadComponents/gt;
lt;o:LocationOfComponents HRef=quot;file:J:\Office\2000\Std\msowc.cabquot;/gt;
lt;/o:OfficeDocumentSettingsgt;
lt;/xmlgt;lt;![endif]--gt;
lt;stylegt;
lt;!--table
{mso-displayed-decimal-separator:quot;\.quot;;
mso-displayed-thousand-separator:quot;\,quot;;}
@page
{mso-header-data:amp;A;
mso-footer-data:quot;Page amp;Pquot;;
margin:.98in .75in .98in .75in;
mso-header-margin:.51in;
mso-footer-margin:.51in;}
tr
{mso-height-source:auto;}
col
================================================== =====================Version 2:

lt;html xmlns=quot;urn:schemas-microsoft-comfficefficequot;
xmlns:x=quot;urn:schemas-microsoft-comffice:excelquot;
xmlns=quot;www.w3.org/TR/REC-html40quot;gt;

lt;headgt;
lt;meta http-equiv=Content-Type content=quot;text/html;
charset=windows-1252quot;gt;
lt;meta name=ProgId content=FrontPage.Editor.Documentgt;
lt;meta name=Generator content=quot;Microsoft Excel 11quot;gt;
lt;link rel=File-List
href=quot;TagEquipmnt~CentrifugalPump_files/filelist.xmlquot;gt;
lt;/headgt;

lt;bodygt;
lt;!--[if !excel]gt;amp;nbsp;amp;nbsp;lt;![endif]--gt;
lt;!--The following information was generated by Microsoft Office Excel's
Publish
as Web Page wizard.--gt;
lt;!--If the same item is republished from Excel, all information between
the DIV
tags will be replaced.--gt;
lt;!-----------------------------gt;
lt;!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --gt;
lt;!-----------------------------gt;

lt;div id=quot;TagEquipmnt~CentrifugalPump_32668quot; align=center
xublishsource=quot;Excelquot;gt;lt;object
id=quot;TagEquipmnt~CentrifugalPump_32668_Spreadsheet quot;
classid=quot;CLSID:0002E559-0000-0000-C000-000000000046quot;gt;
lt;param name=DisplayTitleBar value=falsegt;
lt;param name=Autofit value=truegt;
lt;param name=DataType value=XMLDatagt;
lt;param name=XMLData
value=quot;amp;lt;?xml
version=amp;quot;1.0amp;quot;?amp;gt;#13;#10;amp;lt;?mso-applicationHello,
If you click Publish instead of save as web page ....
This is not an answer to your question but may give you another option.

See my WebPageTableMaker at
www.geocities.com/excelmarksway

It doesn't use XML, only basic html.

There are several versions to play with:

WebCreator_Simple.xls
WebPageDataTableMaker.xls

- -Markquot;Renatoquot; wrote:

gt; Hey all,
gt;
gt; I'm trying to save an Excel file to a HTML file, with interactivity. I
gt; had done this in an older version of Excel, with another machine
gt; configuration, and the output was given something like Version 1, at
gt; the bottom.
gt;
gt; As I could see, it used the progID Excel.Sheet, which generated the
gt; html code in a way that a program I use could read it perfectly and
gt; edit it.
gt;
gt; In the new version, I get something like Version 2. All the xml code
gt; now comes in a parameter called XMLData, and it's not working anymore
gt; with my program. It now uses the progID FrontPage.Editor.Document. In
gt; the older version, the XML data came distributed along the code in
gt; another manner.
gt;
gt; Is there a way to force Excel to use the Excel.Sheet prodID, or another
gt; way to make it work like it used to ?
gt;
gt; Thanks
gt;
gt;
gt;
gt;
gt; Version 1:
gt;
gt; lt;html xmlns=quot;urn:schemas-microsoft-comfficefficequot;
gt; xmlns:x=quot;urn:schemas-microsoft-comffice:excelquot;
gt; xmlns=quot;www.w3.org/TR/REC-html40quot;gt;
gt;
gt; lt;headgt;
gt; lt;meta http-equiv=Content-Type content=quot;text/html;
gt; charset=windows-1252quot;gt;
gt; lt;meta name=ProgId content=Excel.Sheetgt;
gt; lt;meta name=Generator content=quot;Microsoft Excel 9quot;gt;
gt; lt;link rel=File-List
gt; href=quot;./TagEquipmnt~CentrifugalPump_files/filelist.xmlquot;gt;
gt; lt;link rel=Edit-Time-Data
gt; href=quot;./TagEquipmnt~CentrifugalPump_files/editdata.msoquot;gt;
gt; lt;link rel=OLE-Object-Data
gt; href=quot;./TagEquipmnt~CentrifugalPump_files/oledata.msoquot;gt;
gt; lt;!--[if gte mso 9]gt;lt;xmlgt;
gt; lt;oocumentPropertiesgt;
gt; lt;o:LastAuthorgt;Process amp; Building Solutionslt;/o:LastAuthorgt;
gt; lt;o:LastPrintedgt;2003-04-24T10:29:20Zlt;/o:LastPrintedgt;
gt; lt;o:Createdgt;2003-04-24T10:29:54Zlt;/o:Createdgt;
gt; lt;o:LastSavedgt;2004-03-15T16:51:32Zlt;/o:LastSavedgt;
gt; lt;o:Versiongt;9.2720lt;/o:Versiongt;
gt; lt;/oocumentPropertiesgt;
gt; lt;o:OfficeDocumentSettingsgt;
gt; lt;oownloadComponents/gt;
gt; lt;o:LocationOfComponents HRef=quot;file:J:\Office\2000\Std\msowc.cabquot;/gt;
gt; lt;/o:OfficeDocumentSettingsgt;
gt; lt;/xmlgt;lt;![endif]--gt;
gt; lt;stylegt;
gt; lt;!--table
gt; {mso-displayed-decimal-separator:quot;\.quot;;
gt; mso-displayed-thousand-separator:quot;\,quot;;}
gt; @page
gt; {mso-header-data:amp;A;
gt; mso-footer-data:quot;Page amp;Pquot;;
gt; margin:.98in .75in .98in .75in;
gt; mso-header-margin:.51in;
gt; mso-footer-margin:.51in;}
gt; tr
gt; {mso-height-source:auto;}
gt; col
gt;
gt;
gt;
gt; ================================================== =====================
gt;
gt;
gt; Version 2:
gt;
gt; lt;html xmlns=quot;urn:schemas-microsoft-comfficefficequot;
gt; xmlns:x=quot;urn:schemas-microsoft-comffice:excelquot;
gt; xmlns=quot;www.w3.org/TR/REC-html40quot;gt;
gt;
gt; lt;headgt;
gt; lt;meta http-equiv=Content-Type content=quot;text/html;
gt; charset=windows-1252quot;gt;
gt; lt;meta name=ProgId content=FrontPage.Editor.Documentgt;
gt; lt;meta name=Generator content=quot;Microsoft Excel 11quot;gt;
gt; lt;link rel=File-List
gt; href=quot;TagEquipmnt~CentrifugalPump_files/filelist.xmlquot;gt;
gt; lt;/headgt;
gt;
gt; lt;bodygt;
gt; lt;!--[if !excel]gt; lt;![endif]--gt;
gt; lt;!--The following information was generated by Microsoft Office Excel's
gt; Publish
gt; as Web Page wizard.--gt;
gt; lt;!--If the same item is republished from Excel, all information between
gt; the DIV
gt; tags will be replaced.--gt;
gt; lt;!-----------------------------gt;
gt; lt;!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --gt;
gt; lt;!-----------------------------gt;
gt;
gt; lt;div id=quot;TagEquipmnt~CentrifugalPump_32668quot; align=center
gt; xublishsource=quot;Excelquot;gt;lt;object
gt; id=quot;TagEquipmnt~CentrifugalPump_32668_Spreadsheet quot;
gt; classid=quot;CLSID:0002E559-0000-0000-C000-000000000046quot;gt;
gt; lt;param name=DisplayTitleBar value=falsegt;
gt; lt;param name=Autofit value=truegt;
gt; lt;param name=DataType value=XMLDatagt;
gt; lt;param name=XMLData
gt; value=quot;lt;?xml
gt; version=quot;1.0quot;?gt;
lt;?mso-application
gt;
gt;

Hey man,

I see your point, but I really needed the XML output, cause the other
program uses it to edit the information on the worksheet.

I tried using Publish instead of Save as Web Page, but the output was
exactly the same.

Any other ideas ?

Thanks!

RenatoFile gt; Save As Web Page gt;

there are options here to add Interactivity.

You will have to play around with the options

In the SaveAs Web Page Dialog, at the top are Tools for Web options

Other than this, I do not know
quot;Renatoquot; wrote:

gt; Hey man,
gt;
gt; I see your point, but I really needed the XML output, cause the other
gt; program uses it to edit the information on the worksheet.
gt;
gt; I tried using Publish instead of Save as Web Page, but the output was
gt; exactly the same.
gt;
gt; Any other ideas ?
gt;
gt; Thanks!
gt;
gt; Renato
gt;
gt;

Hey all,

The solution to what I wanted was to Save as Web Page, and UNCHECK add
interactivity.

I don't know exactly what is this interactivity for, but I could get
data editing without it, and I got the output file I was needing.

Just FYI.

Thanks.