Saving as Web Page in Excel

R

Renato

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:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
xmlns:x="urn:schemas-microsoft-com:blush:ffice: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:LastAuthor>Process &amp; Building Solutions</o:LastAuthor>
<o:LastPrinted>2003-04-24T10:29:20Z</o:LastPrinted>
<o:Created>2003-04-24T10:29:54Z</o:Created>
<o:LastSaved>2004-03-15T16:51:32Z</o:LastSaved>
<o:Version>9.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:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
xmlns:x="urn:schemas-microsoft-com:blush:ffice: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]>&nbsp;&nbsp;<![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="&lt;?xml
version=&quot;1.0&quot;?&gt;
&lt;?mso-application
 
G

Guest

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 said:
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:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
xmlns:x="urn:schemas-microsoft-com:blush:ffice: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:LastAuthor>Process & Building Solutions</o:LastAuthor>
<o:LastPrinted>2003-04-24T10:29:20Z</o:LastPrinted>
<o:Created>2003-04-24T10:29:54Z</o:Created>
<o:LastSaved>2004-03-15T16:51:32Z</o:LastSaved>
<o:Version>9.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:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
xmlns:x="urn:schemas-microsoft-com:blush:ffice: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
Click to expand...
 
R

Renato

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
 
G

Guest

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
 
R

Renato

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ActiveX warning message when adding signature 5
ss:Formula in excel saved in xml format 4
gridlines toggled off when importing html table 0
What is all this xml? 2
File in a string...Don't openfile... 2
If I have corrupt files... 1
Excel Workbook in IE 1
Changing to Landscape mode automatically 0

Top