80
最 新 评 论
80
专 题 分 类
80
最 新 日 志
80
最 新 留 言
80
搜 索
用 户 登 录
友 情 连 接
我 的 好 友
80
博 客 信 息
80


XML 应用在Excel 2003 中 | 2009/12/6 20:56:00
分析一下Excel Sheet XML 的文档格式:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="
http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>LiuMingTao</Author>
  <LastAuthor>LiuMingTao</LastAuthor>
  <Created>2009-11-17T07:10:53Z</Created>
  <LastSaved>2009-11-18T01:47:15Z</LastSaved>
  <Company>Motorola</Company>
  <Version>11.9999</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>8130</WindowHeight>
  <WindowWidth>17895</WindowWidth>
  <WindowTopX>840</WindowTopX>
  <WindowTopY>285</WindowTopY>
  <ActiveSheet>1</ActiveSheet>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>

  <Style ss:ID="s21">
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s22">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s23">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>

  <Style ss:ID="s24">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>

  <Style ss:ID="s25">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
   <Interior ss:Color="#CCFFCC" ss:Pattern="Solid"/>
  </Style>

  <Style ss:ID="s26">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s27">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s28">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s29">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s30">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s31">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s32">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s33">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s34">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s35">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s36">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s37">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s38">
   <NumberFormat ss:Format="Scientific"/>
  </Style>

  <Style ss:ID="s39">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
   <NumberFormat ss:Format="yyyy/m/d\ h:mm;@"/>
  </Style>

  <Style ss:ID="s40">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s41">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>

  <Style ss:ID="s42">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
   <Font x:Family="Swiss" ss:Color="#000000"/>
  </Style>
 </Styles>

 <Worksheet ss:Name="Sheet1">

 <Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="6605" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">

   <Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="75"/>
   <Column ss:Width="159.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="63" ss:Span="1"/>
   <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="63.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="84"/>
  
   <Row ss:AutoFitHeight="0" ss:Height="14.25">
    <Cell ss:StyleID="s22"><Data ss:Type="String">采集日期</Data></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String">控制器编号</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">最大负荷</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">平均负荷</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">数据处理负荷</Data></Cell>
    <Cell ss:StyleID="s25"><Data ss:Type="String">数据处理平均负荷</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s26"><Data ss:Type="DateTime">2009-08-14T10:00:00.000</Data></Cell>
    <Cell ss:StyleID="s27"><Data ss:Type="String">NBBSC004                                  </Data></Cell>
    <Cell ss:StyleID="s28"><Data ss:Type="Number">102.571428571428</Data></Cell>
    <Cell ss:StyleID="s28"><Data ss:Type="Number">28.7171428571428</Data></Cell>
    <Cell ss:StyleID="s28"><Data ss:Type="Number">130</Data></Cell>
    <Cell ss:StyleID="s29"><Data ss:Type="Number">33.750100000000003</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s30"><Data ss:Type="DateTime">2009-08-14T10:00:00.000</Data></Cell>
    <Cell ss:StyleID="s31"><Data ss:Type="String">NBBSC005                                  </Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="Number">96.2222222222222</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="Number">21.064366666666601</Data></Cell>
    <Cell ss:StyleID="s32"><Data ss:Type="Number">123</Data></Cell>
    <Cell ss:StyleID="s33"><Data ss:Type="Number">27.7974999999999</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="14.25">
    <Cell ss:StyleID="s34"><Data ss:Type="DateTime">2009-08-14T10:00:00.000</Data></Cell>
    <Cell ss:StyleID="s35"><Data ss:Type="String">NBBSC006                                  </Data></Cell>
    <Cell ss:StyleID="s36"><Data ss:Type="Number">122.333333333333</Data></Cell>
    <Cell ss:StyleID="s36"><Data ss:Type="Number">34.433466666666597</Data></Cell>
    <Cell ss:StyleID="s36"><Data ss:Type="Number">146</Data></Cell>
    <Cell ss:StyleID="s37"><Data ss:Type="Number">42.764499999999899</Data></Cell>
   </Row>

   <Row ss:AutoFitHeight="0" ss:Span="5024"/>
   <Row ss:Index="5030" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="52"/>
   <Row ss:Index="5084" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="151"/>
   <Row ss:Index="5237" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="118"/>
   <Row ss:Index="5357" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="159"/>
   <Row ss:Index="5518" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="75"/>
   <Row ss:Index="5595" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="208"/>
   <Row ss:Index="5805" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="73"/>
   <Row ss:Index="5880" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="78"/>
   <Row ss:Index="5960" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="205"/>
   <Row ss:Index="6167" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="154"/>
   <Row ss:Index="6323" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="176"/>
   <Row ss:Index="6501" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
    <Cell ss:Index="6" ss:StyleID="s38"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Span="102"/>
   <Row ss:Index="6605" ss:AutoFitHeight="0">
    <Cell ss:Index="4" ss:StyleID="s38"/>
   </Row>
  </Table>

  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.3"/>
    <Footer x:Margin="0.3"/>
    <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
   </PageSetup>
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>200</HorizontalResolution>
    <VerticalResolution>200</VerticalResolution>
   </Print>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>15</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
 </WorksheetOptions>

 </Worksheet>

 <Worksheet ss:Name="Sheet2">

  <Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="2" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">

   <Column ss:Width="75"/>
   <Column ss:Width="159.75"/>
   <Column ss:Width="63" ss:Span="1"/>
   <Column ss:Index="5" ss:Width="63.75"/>
   <Column ss:Width="84"/>

   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s22"><Data ss:Type="String">采集日期</Data></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String">控制器编号</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">最大负荷</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">平均负荷</Data></Cell>
    <Cell ss:StyleID="s24"><Data ss:Type="String">数据处理负荷</Data></Cell>
    <Cell ss:StyleID="s25"><Data ss:Type="String">数据处理平均负荷</Data></Cell>
   </Row>

   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s39"><Data ss:Type="DateTime">2009-08-14T10:00:00.000</Data></Cell>
    <Cell ss:StyleID="s40"><Data ss:Type="String">NBBSC004                                  </Data></Cell>
    <Cell ss:StyleID="s41"><Data ss:Type="Number">102.571428571428</Data></Cell>
    <Cell ss:StyleID="s41"><Data ss:Type="Number">28.7171428571428</Data></Cell>
    <Cell ss:StyleID="s41"><Data ss:Type="Number">130</Data></Cell>
    <Cell ss:StyleID="s42"><Data ss:Type="Number">33.750100000000003</Data></Cell>
   </Row>

 </Table>

 <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.3"/>
    <Footer x:Margin="0.3"/>
    <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
   </PageSetup>
   <Unsynced/>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>5</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>

 </Worksheet>

</Workbook>

上述文件为一个格式良好的XML文档;
该文件用浏览器打开后表现形式如下:

XML文件直接可以由TOMCAT6.0 WEB服务器发送后如下:

将该文件保存为HTM文件后在TOMCAT6.0服务器发送后由浏览器读取后如下:


该文件用文本编辑器打开后:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="
http://www.w3.org/TR/REC-html40"
xmlns="
http://www.w3.org/TR/REC-html40">
<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="/blog/CPU_LOAD_files/filelist.xml">
<link rel=Edit-Time-Data href="/blog/CPU_LOAD_files/editdata.mso">
<link rel=OLE-Object-Data href="/blog/CPU_LOAD_files/oledata.mso">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>ptj687</o:Author>
  <o:LastAuthor>qch1706</o:LastAuthor>
  <o:Created>2009-11-17T07:10:53Z</o:Created>
  <o:LastSaved>2009-12-06T13:43:15Z</o:LastSaved>
  <o:Company>Motorola</o:Company>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]--><![if !supportTabStrip]>
<link id="shLink" href="/blog/CPU_LOAD_files/sheet001.htm">
<link id="shLink" href="/blog/CPU_LOAD_files/sheet002.htm">
<link id="shLink">
<script language="JavaScript">
<!--
 var c_lTabs=2;
 var c_rgszSh=new Array(c_lTabs);
 c_rgszSh[0] = "Sheet1";
 c_rgszSh[1] = "Sheet2";
 
 var c_rgszClr=new Array(8);
 c_rgszClr[0]="window";
 c_rgszClr[1]="buttonface";
 c_rgszClr[2]="windowframe";
 c_rgszClr[3]="windowtext";
 c_rgszClr[4]="threedlightshadow";
 c_rgszClr[5]="threedhighlight";
 c_rgszClr[6]="threeddarkshadow";
 c_rgszClr[7]="threedshadow";
 var g_iShCur;
 var g_rglTabX=new Array(c_lTabs);
function fnGetIEVer()
{
 var ua=window.navigator.userAgent
 var msie=ua.indexOf("MSIE")
 if (msie>0 && window.navigator.platform=="Win32")
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
 else
  return 0;
}
function fnBuildFrameset()
{
 var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
  "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
  "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
  "</frameset></frameset><plaintext>";
 with (document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }
 fnBuildTabStrip();
}
function fnBuildTabStrip()
{
 var szHTML=
  "<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[6]+";cursor:default;line-height:10pt;}"+
  ".clScroll2 {font:10pt Arial;color:"+c_rgszClr[6]+";cursor:default;line-height:11pt;}</style></head>"+
  "<body onclick=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" onselectstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
  "<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
  "<tr><td style=\"font:1pt\">&nbsp;<td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>&#171;</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(0);\" ondblclick=\"parent.fnScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(1);\" onmouseout=\"parent.fnMouseOutScroll(1);\"><a>&lt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(1);\" ondblclick=\"parent.fnScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(2);\" onmouseout=\"parent.fnMouseOutScroll(2);\"><a>&gt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>&#187;</a></td>"+
  "<td style=\"font:1pt\">&nbsp;<td></tr></table></body></html>";
 with (frames['frScroll'].document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }
 szHTML =
  "<html><head>"+
  "<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
  ".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:9pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
  ".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
  "</style></head><body onload=\"parent.fnInit();\" onselectstart=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+
  " topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";
 var iCellCount=(c_lTabs+1)*2;
 var i;
 for (i=0;i<iCellCount;i+=2)
  szHTML+="<col width=1><col>";
 var iRow;
 for (iRow=0;iRow<6;iRow++) {
  szHTML+="<tr>";
  if (iRow==5)
   szHTML+="<td colspan="+iCellCount+"></td>";
  else {
   if (iRow==0) {
    for(i=0;i<iCellCount;i++)
     szHTML+="<td height=1 class=\"clBorder\"></td>";
   } else if (iRow==1) {
    for(i=0;i<c_lTabs;i++) {
     szHTML+="<td height=1 nowrap class=\"clBorder\">&nbsp;</td>";
     szHTML+=
      "<td id=tdTab height=1 nowrap class=\"clTab\" onmouseover=\"parent.fnMouseOverTab("+i+");\" onmouseout=\"parent.fnMouseOutTab("+i+");\">"+
      "<a href=\""+document.all.item("shLink")[i].href+"\" target=\"frSheet\" id=aTab>&nbsp;"+c_rgszSh[i]+"&nbsp;</a></td>";
    }
    szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab>&nbsp;</a></td><td width=100%></td>";
   } else if (iRow==2) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1></td><td height=1 class=\"clBorder\"></td>";
    szHTML+="<td height=1></td><td height=1></td>";
   } else if (iRow==3) {
    for (i=0;i<iCellCount;i++)
     szHTML+="<td height=1></td>";
   } else if (iRow==4) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1 width=1></td><td height=1></td>";
    szHTML+="<td height=1 width=1></td><td></td>";
   }
  }
  szHTML+="</tr>";
 }
 szHTML+="</table></body></html>";
 with (frames['frTabs'].document) {
  open("text/html","replace");
  charset=document.charset;
  write(szHTML);
  close();
 }
}
function fnInit()
{
 g_rglTabX[0]=0;
 var i;
 for (i=1;i<=c_lTabs;i++)
  with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
   g_rglTabX[i]=offsetLeft+offsetWidth-6;
}
function fnTabToCol(iTab)
{
 return 2*iTab+1;
}
function fnNextTab(fDir)
{
 var iNextTab=-1;
 var i;
 with (frames['frTabs'].document.body) {
  if (fDir==0) {
   if (scrollLeft>0) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i-1;
   }
  } else {
   if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<=scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i;
   }
  }
 }
 return iNextTab;
}
function fnScrollTabs(fDir)
{
 var iNextTab=fnNextTab(fDir);
 if (iNextTab>=0) {
  frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
  return true;
 } else
  return false;
}
function fnFastScrollTabs(fDir)
{
 if (c_lTabs>16)
  frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
 else
  if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
}
function fnSetTabProps(iTab,fActive)
{
 var iCol=fnTabToCol(iTab);
 var i;
 if (iTab>=0) {
  with (frames['frTabs'].document.all) {
   with (tbTabs) {
    for (i=0;i<=4;i++) {
     with (rows[i]) {
      if (i==0)
       cells[iCol].style.background="/blog/c_rgszClr[fActive?0:2]";
      else if (i>0 && i<4) {
       if (fActive) {
        cells[iCol-1].style.background="/blog/c_rgszClr[2]";
        cells[iCol].style.background="/blog/c_rgszClr[0]";
        cells[iCol+1].style.background="/blog/c_rgszClr[2]";
       } else {
        if (i==1) {
         cells[iCol-1].style.background="/blog/c_rgszClr[2]";
         cells[iCol].style.background="/blog/c_rgszClr[1]";
         cells[iCol+1].style.background="/blog/c_rgszClr[2]";
        } else {
         cells[iCol-1].style.background="/blog/c_rgszClr[4]";
         cells[iCol].style.background="/blog/c_rgszClr["(i==2)?2:4];
         cells[iCol+1].style.background="/blog/c_rgszClr[4]";
        }
       }
      } else
       cells[iCol].style.background="/blog/c_rgszClr[fActive?2:4]";
     }
    }
   }
   with (aTab[iTab].style) {
    cursor=(fActive?"default":"hand");
    color=c_rgszClr[3];
   }
  }
 }
}
function fnMouseOverScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[7];
}
function fnMouseOutScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[6];
}
function fnMouseOverTab(iTab)
{
 if (iTab!=g_iShCur) {
  var iCol=fnTabToCol(iTab);
  with (frames['frTabs'].document.all) {
   tdTab[iTab].style.background="/blog/c_rgszClr[5]";
  }
 }
}
function fnMouseOutTab(iTab)
{
 if (iTab>=0) {
  var elFrom=frames['frTabs'].event.srcElement;
  var elTo=frames['frTabs'].event.toElement;
  if ((!elTo) ||
   (elFrom.tagName==elTo.tagName) ||
   (elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
   (elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {
   if (iTab!=g_iShCur) {
    with (frames['frTabs'].document.all) {
     tdTab[iTab].style.background="/blog/c_rgszClr[1]";
    }
   }
  }
 }
}
function fnSetActiveSheet(iSh)
{
 if (iSh!=g_iShCur) {
  fnSetTabProps(g_iShCur,false);
  fnSetTabProps(iSh,true);
  g_iShCur=iSh;
 }
}
 window.g_iIEVer=fnGetIEVer();
 if (window.g_iIEVer>=4)
  fnBuildFrameset();
//-->
</script>
<![endif]><!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetSource href="/blog/CPU_LOAD_files/sheet001.htm"/>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetSource href="/blog/CPU_LOAD_files/sheet002.htm"/>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:Stylesheet href="/blog/CPU_LOAD_files/stylesheet.css"/>
  <x:WindowHeight>8130</x:WindowHeight>
  <x:WindowWidth>17895</x:WindowWidth>
  <x:WindowTopX>840</x:WindowTopX>
  <x:WindowTopY>285</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>
<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
 <frame src="/blog/CPU_LOAD_files/sheet001.htm" name="frSheet">
 <frame src="/blog/CPU_LOAD_files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
 <noframes>
  <body>
   <p>This page uses frames, but your browser doesn't support them.</p>
  </body>
 </noframes>
</frameset>
</html>

另外需要三个附属文件支撑文件内容如下:
CPU_LOAD_files/filelist.xml;
<xml xmlns:o="urn:schemas-microsoft-com:office:office">
 <o:MainFile HRef="../CPU_LOAD.htm"/>
 <o:File href="/blog/stylesheet.css"/>
 <o:File HRef="tabstrip.htm"/>
 <o:File href="/blog/sheet001.htm"/>
 <o:File href="/blog/sheet002.htm"/>
 <o:File HRef="filelist.xml"/>
</xml>
CPU_LOAD_files/stylesheet.css;
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:middle;
 white-space:nowrap;
 mso-rotate:0;
 mso-background-source:auto;
 mso-pattern:auto;
 color:black;
 font-size:11.0pt;
 font-weight:400;
 font-style:normal;
 text-decoration:none;
 font-family:宋体;
 mso-generic-font-family:auto;
 mso-font-charset:134;
 border:none;
 mso-protection:locked visible;
 mso-style-name:Normal;
 mso-style-id:0;}
td
 {mso-style-parent:style0;
 padding-top:1px;
 padding-right:1px;
 padding-left:1px;
 mso-ignore:padding;
 color:black;
 font-size:11.0pt;
 font-weight:400;
 font-style:normal;
 text-decoration:none;
 font-family:宋体;
 mso-generic-font-family:auto;
 mso-font-charset:134;
 mso-number-format:General;
 text-align:general;
 vertical-align:middle;
 border:none;
 mso-background-source:auto;
 mso-pattern:auto;
 mso-protection:locked visible;
 white-space:nowrap;
 mso-rotate:0;}
.xl24
 {mso-style-parent:style0;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";}
.xl25
 {mso-style-parent:style0;
 font-size:10.0pt;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";
 text-align:center;
 border:1.0pt solid windowtext;
 background:#CCFFCC;
 mso-pattern:auto none;}
.xl26
 {mso-style-parent:style0;
 font-size:10.0pt;
 text-align:center;
 border-top:1.0pt solid windowtext;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:none;
 background:#CCFFCC;
 mso-pattern:auto none;}
.xl27
 {mso-style-parent:style0;
 font-size:10.0pt;
 text-align:center;
 border-top:1.0pt solid windowtext;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;
 background:#CCFFCC;
 mso-pattern:auto none;}
.xl28
 {mso-style-parent:style0;
 font-size:10.0pt;
 text-align:center;
 border-top:1.0pt solid windowtext;
 border-right:1.0pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;
 background:#CCFFCC;
 mso-pattern:auto none;}
.xl29
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";
 text-align:left;
 border-top:none;
 border-right:1.0pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:1.0pt solid windowtext;}
.xl30
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:.5pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:none;}
.xl31
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:.5pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl32
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:1.0pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl33
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:1.0pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:1.0pt solid windowtext;}
.xl34
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:.5pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:none;}
.xl35
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border:.5pt solid windowtext;}
.xl36
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:1.0pt solid windowtext;
 border-bottom:.5pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl37
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:1.0pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:1.0pt solid windowtext;}
.xl38
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:none;}
.xl39
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl40
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:.5pt solid windowtext;
 border-right:1.0pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl41
 {mso-style-parent:style0;
 mso-number-format:Scientific;}
.xl42
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 mso-number-format:"yyyy\/m\/d\\ h\:mm\;\@";
 text-align:left;
 border-top:none;
 border-right:1.0pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:1.0pt solid windowtext;}
.xl43
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:none;}
.xl44
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:.5pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;}
.xl45
 {mso-style-parent:style0;
 font-size:10.0pt;
 font-family:Arial, sans-serif;
 mso-font-charset:0;
 text-align:left;
 border-top:none;
 border-right:1.0pt solid windowtext;
 border-bottom:1.0pt solid windowtext;
 border-left:.5pt solid windowtext;}
阅读全文 | 回复(0) | 引用通告 | 编辑 | By: 皮皮爸爸
  • 标签:XML 
  • 发表评论:

      大名:
      密码: (游客无须输入密码)
      主页:
      标题:
      80
    Powered by Oblog.