Link rel for converting an excel template to a webpage

swatisonee · November 25, 2010

Hi:

I have an excel template with some data. I used the save as webpage feature and then opened it in my php program to add the php code to process the stuff. I tried using a link like this

<link type="text/css" rel="stylesheet" href="NEWDBS/cssfiles/hr.css">

in which to save all the style formats but i find that while this works when converting a word doc to webpage, in excel, none of the style formats get saved. the output is only the data that the php script has processed.

Here's an example of what the original webpage looked like .I inserted the <link type> code above in the line above </head> and then deleted all the code between the <style> </style> links.

Is there an error in what i 've done and what should i replace thew link type with ? Thanks !

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
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 11">
<link rel=File-List href="salesx_files/filelist.xml">
<link rel=Edit-Time-Data href="salesx_files/editdata.mso">
<link rel=OLE-Object-Data href="salesx_files/oledata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:DocumentProperties>
  <o:LastAuthor></o:LastAuthor>
  <o:LastPrinted></o:LastPrinted>
  <o:Created></o:Created>
  <o:LastSaved>2010-11-25T04:27:53Z</o:LastSaved>
  <o:Company>Microsoft Corporation</o:Company>
  <o:Version>11.9999</o:Version>
</o:DocumentProperties>
<o:CustomDocumentProperties>
  <o:_TemplateID dt:dt="string">033</o:_TemplateID>
</o:CustomDocumentProperties>
<o:OfficeDocumentSettings>
  <o:Colors>
   <o:Color>
    <o:Index>8</o:Index>
    <o:RGB>#720000</o:RGB>
   </o:Color>
   <o:Color>
    <o:Index>32</o:Index>
    <o:RGB>#F3D9AB</o:RGB>
   </o:Color>
   <o:Color>
    <o:Index>35</o:Index>
    <o:RGB>#ECF2F8</o:RGB>
   </o:Color>
   <o:Color>
    <o:Index>39</o:Index>
    <o:RGB>#FDFAEB</o:RGB>
   </o:Color>
   <o:Color>
    <o:Index>46</o:Index>
    <o:RGB>#D0D7E2</o:RGB>
   </o:Color>
   <o:Color>
    <o:Index>53</o:Index>
    <o:RGB>#E3E3E3</o:RGB>
   </o:Color>
  </o:Colors>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:.75in .51in .75in .51in;
mso-header-margin:.51in;
mso-footer-margin:.51in;
mso-page-orientation:landscape;
mso-horizontal-page-align:center;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding:0px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
font-family:"Century Gothic", sans-serif;
mso-font-charset:0;
background:white;
mso-pattern:auto none;}
.xl25
{mso-style-parent:style0;
font-size:18.0pt;
font-family:"Century Gothic", sans-serif;
mso-font-charset:0;
background:white;
mso-pattern:auto none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Emergency Contacts</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>270</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:Scale>91</x:Scale>
      <x:HorizontalResolution>-3</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:TabColorIndex>54</x:TabColorIndex>
     <x:PageBreakZoom>60</x:PageBreakZoom>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>4</x:ActiveRow>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>6660</x:WindowHeight>
  <x:WindowWidth>12105</x:WindowWidth>
  <x:WindowTopX>1995</x:WindowTopX>
  <x:WindowTopY>135</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
<x:ExcelName>
  <x:Name>Print_Area</x:Name>
  <x:SheetIndex>1</x:SheetIndex>
  <x:Formula>='Emergency Contacts'!$A$1:$J$19</x:Formula>
</x:ExcelName>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2049"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>

Sign In

Link rel for converting an excel template to a webpage

Recommended Posts

swatisonee

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information