免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 940 | 回复: 0
打印 上一主题 下一主题

大家帮帮忙啊 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 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>;
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP