ExcelBanter - Saving as Web Page in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Saving as Web Page in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/74963-saving-web-page-excel.html)

Saving as Web Page in Excel

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

Saving as Web Page in Excel

Hello,
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
http://www.geocities.com/excelmarksway

It doesn't use XML, only basic html.

There are several versions to play with:

WebCreator_Simple.xls
WebPageDataTableMaker.xls

- -Mark

"Renato" wrote:

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

Saving as Web Page in Excel

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!

Renato

Saving as Web Page in Excel

File Save As Web Page

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

"Renato" wrote:

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!

Renato

Saving as Web Page in Excel

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.