xslt导入excel
来源:互联网 发布:通话声音分析软件 编辑:程序博客网 时间:2024/06/14 15:58
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 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">
<xsl:template match="/">
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Worksheet ss:Name="driver">
<Table ss:DefaultColumnWidth="60" ss:DefaultRowHeight="15">
<Row>
<Cell><Data ss:Type="String">编号</Data></Cell>
<Cell><Data ss:Type="String">姓名</Data></Cell>
<Cell><Data ss:Type="String">性别</Data></Cell>
<Cell><Data ss:Type="String">单位</Data></Cell>
<Cell><Data ss:Type="String">固定电话</Data></Cell>
<Cell><Data ss:Type="String">手机</Data></Cell>
</Row>
<xsl:apply-templates />
</Table>
</Worksheet>
</Workbook>
</xsl:template>
<xsl:template match="Row">
<Row xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:for-each select="./*">
<Cell><Data ss:Type="String"><xsl:value-of select="."/></Data></Cell>
</xsl:for-each>
</Row>
</xsl:template>
</xsl:stylesheet>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 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">
<xsl:template match="/">
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Worksheet ss:Name="driver">
<Table ss:DefaultColumnWidth="60" ss:DefaultRowHeight="15">
<Row>
<Cell><Data ss:Type="String">编号</Data></Cell>
<Cell><Data ss:Type="String">姓名</Data></Cell>
<Cell><Data ss:Type="String">性别</Data></Cell>
<Cell><Data ss:Type="String">单位</Data></Cell>
<Cell><Data ss:Type="String">固定电话</Data></Cell>
<Cell><Data ss:Type="String">手机</Data></Cell>
</Row>
<xsl:apply-templates />
</Table>
</Worksheet>
</Workbook>
</xsl:template>
<xsl:template match="Row">
<Row xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:for-each select="./*">
<Cell><Data ss:Type="String"><xsl:value-of select="."/></Data></Cell>
</xsl:for-each>
</Row>
</xsl:template>
</xsl:stylesheet>
阅读全文
0 0
- xslt导入excel
- EXCEL导入
- 导入EXCEL
- Excel 导入
- Excel导入
- 导入Excel
- 导入Excel
- 导入Excel
- excel导入
- 导入EXCEL
- 导入excel
- 导入excel
- 导入Excel
- 导入excel
- Excel 导入
- 导入excel
- excel 导入
- Excel导入
- C语言之旅(4)const
- Word打印目录或另存为PDF时出现“错误!未定义书签!”的解决办法
- Netflix 微服务架构设计的经验总结!
- python3.5爬虫实例:根据城市名称来获取该城市最近七天的天气预报
- python的异常
- xslt导入excel
- Linux安装Tomcat
- 对拍bat代码及实现
- Bootstrap学习手册
- leetcode 563. Binary Tree Tilt
- javap的认识
- frame操作
- Gaby Ivanushka
- linux常用命令大全