Chinaunix

标题: 大家帮帮忙啊 [打印本页]

---

作者: hyl_fr    时间: 2005-01-18 16:59
标题: 大家帮帮忙啊
大家帮忙看看，这样的一个xml文件怎么用xsl解析输出Table内的数据,这个xml是从Excle生成的，谢

<?xml version="1.0" encoding="GB2312" ?>;
<?xml:stylesheet type="text/xsl" href="DevMessage.xsl"?>;
<!--?mso-application progid="Excel.Sheet"?-->;
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">;
<DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice">;
  <LastAuthor>;MC SYSTEM</LastAuthor>;
  <Created>;2005-01-18T02:08:49Z</Created>;
  <Version>;11.5606</Version>;
</DocumentProperties>;
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">;
  <WindowHeight>;9150</WindowHeight>;
  <WindowWidth>;14940</WindowWidth>;
  <WindowTopX>;360</WindowTopX>;
  <WindowTopY>;270</WindowTopY>;
  <AcceptLabelsInFormulas/>;
  <rotectStructure>;False</ProtectStructure>;
  <rotectWindows>;False</ProtectWindows>;
</ExcelWorkbook>;
<Styles>;
  <Style ID="Default" Name="Normal">;
   <Alignment Vertical="Center"/>;
   <Borders/>;
   <Font FontName="&Euml;&Icirc;&Igrave;&amp;" x:CharSet="134" Size="12"/>;
   <Interior/>;
   <NumberFormat/>;
   <rotection/>;
  </Style>;
</Styles>;
<Worksheet Name="Sheet1">;
  <Table ExpandedColumnCount="9" ExpandedRowCount="287"
    DefaultColumnWidth="54" DefaultRowHeight="14.25">;
   <Column AutoFitWidth="0" Width="90"/>;
   <Column AutoFitWidth="0" Width="60"/>;
   <Column AutoFitWidth="0" Width="180"/>;
   <Column AutoFitWidth="0" Width="90" Span="2"/>;
   <Column Index="7" AutoFitWidth="0" Width="60"/>;
   <Column AutoFitWidth="0" Width="90"/>;
   <Column AutoFitWidth="0" Width="180"/>;
   <Row>;
    <Cell>;<Data Type="String">;351982086556</Data>;</Cell>;
    <Cell>;<Data Type="String">;&ETH;ò&amp;&Aring;</Data>;</Cell>;
    <Cell>;<Data Type="String">;42.0.45.220</Data>;</Cell>;
    <Cell>;<Data Type="String">;2004-01-01</Data>;</Cell>;
    <Cell>;<Data Type="String">;6091145</Data>;</Cell>;
    <Cell>;<Data Type="String">;test</Data>;</Cell>;
   </Row>;
   <Row>;
    <Cell>;<Data Type="String">;351982086154</Data>;</Cell>;
    <Cell>;<Data Type="String">;&ETH;ò&amp;&Aring;</Data>;</Cell>;
    <Cell>;<Data Type="String">;42.0.54.154</Data>;</Cell>;
    <Cell>;<Data Type="String">;2004-01-01</Data>;</Cell>;
    <Cell>;<Data Type="String">;2288681</Data>;</Cell>;
    <Cell>;<Data Type="String">;test</Data>;</Cell>;
   </Row>;
   <Row>;
    <Cell>;<Data Type="String">;351982086754</Data>;</Cell>;
    <Cell>;<Data Type="String">;&ETH;ò&amp;&Aring;</Data>;</Cell>;
    <Cell>;<Data Type="String">;42.0.44.60</Data>;</Cell>;
    <Cell>;<Data Type="String">;2004-01-01</Data>;</Cell>;
    <Cell>;<Data Type="String">;6892618</Data>;</Cell>;
    <Cell>;<Data Type="String">;test</Data>;</Cell>;
   </Row>;
  </table>;
  <WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel">;
   <ageSetup>;
    <Layout x:Orientation="Landscape"/>;
   </PageSetup>;
   <rint>;
    <ValidPrinterInfo/>;
    <aperSizeIndex>;0</PaperSizeIndex>;
    <Scale>;285</Scale>;
    <VerticalResolution>;0</VerticalResolution>;
   </Print>;
   <Selected/>;
   <rotectObjects>;False</ProtectObjects>;
   <rotectScenarios>;False</ProtectScenarios>;
  </WorksheetOptions>;
</Worksheet>;
<Worksheet Name="Sheet2">;
  <Table ExpandedColumnCount="0" ExpandedRowCount="0" x:FullColumns="1"
   x:FullRows="1" DefaultColumnWidth="54" DefaultRowHeight="14.25"/>;
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">;
   <ageSetup>;
    <Layout x:Orientation="Landscape"/>;
   </PageSetup>;
   <rint>;
    <ValidPrinterInfo/>;
    <PaperSizeIndex>;0</PaperSizeIndex>;
    <Scale>;285</Scale>;
    <VerticalResolution>;0</VerticalResolution>;
   </Print>;
   <ProtectObjects>;False</ProtectObjects>;
   <ProtectScenarios>;False</ProtectScenarios>;
  </WorksheetOptions>;
</Worksheet>;
<Worksheet Name="Sheet3">;
  <Table ExpandedColumnCount="0" ExpandedRowCount="0" x:FullColumns="1"
   x:FullRows="1" DefaultColumnWidth="54" DefaultRowHeight="14.25"/>;
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">;
   <PageSetup>;
    <Layout x:Orientation="Landscape"/>;
   </PageSetup>;
   <Print>;
    <ValidPrinterInfo/>;
    <PaperSizeIndex>;0</PaperSizeIndex>;
    <Scale>;285</Scale>;
    <VerticalResolution>;0</VerticalResolution>;
   </Print>;
   <ProtectObjects>;False</ProtectObjects>;
   <ProtectScenarios>;False</ProtectScenarios>;
  </WorksheetOptions>;
</Worksheet>;
</Workbook>;

---

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)

Powered by Discuz! X3.2