Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Saving as Web Page in Excel
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renato
 
Posts: n/a
Default 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 &amp; 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]&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

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
exceluserforeman
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
Renato
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
exceluserforeman
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
Renato
 
Posts: n/a
Default 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.

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Saving an Excel Document as a Web Page Danimagus Excel Discussion (Misc queries) 0 June 1st 05 06:34 PM
Excel: Automatically Saving as Web Page Danimagus Excel Discussion (Misc queries) 0 May 31st 05 08:26 PM
Automatically Saving an Excel Document as a Web Page Danimagus Excel Discussion (Misc queries) 0 May 31st 05 07:32 PM
Excel: Automatically Saving as Web Page Danimagus Excel Discussion (Misc queries) 0 May 31st 05 07:32 PM
export excel to Front Page judithbear Excel Discussion (Misc queries) 0 March 26th 05 11:17 PM


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement