使用xslt将XML转换为excel(带有ss:MergeDown的问题) [英] convert xml to excel using xslt (issue with ss:MergeDown)
本文介绍了使用xslt将XML转换为excel(带有ss:MergeDown的问题)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我是xml和xslt的新手.我正在使用xslt将xml转换为excel，在合并具有来自colom的通用数据的单元格时，我面临一个问题.我知道我可以使用ss:MergeDown属性来合并两个或多个单元格，但是我不知道如何识别具有相同数据的单元格.请检查以下示例XML和预期结果.
I am new to xml and xslt. I am converting xml to excel using xslt, I am facing one issue while merging cells with having common data from a colom. I come to know that I can use ss:MergeDown attribute to cell to merge two or more cells but I dont know how to identify cells those are having same data. Please check below sample XML and expected result.
<?xml version="1.0"?>
<?xml-stylesheet type=''text/xsl'' href=''\Transform.xslt''?>
<NewDataSet>
<ReportSummary>
<Division>US</Division>
<Region>West</Region>
<SalesTeam>abc abc</SalesTeam>
</ReportSummary>
<ReportSummary>
<Division>US</Division>
<Region>West</Region>
<SalesTeam>abc saq</SalesTeam>
</ReportSummary>
<ReportSummary>
<Division>US</Division>
<Region>East</Region>
<SalesTeam>abc xyz</SalesTeam>
</ReportSummary>
<ReportSummary>
<Division>US</Division>
<Region>East</Region>
<SalesTeam>abc rte</SalesTeam>
</ReportSummary>
<ReportSummary>
<Division>India</Division>
<Region>West</Region>
<SalesTeam>abc lmn</SalesTeam>
</ReportSummary>
<ReportSummary>
<Division>India</Division>
<Region>West</Region>
<SalesTeam>abc str</SalesTeam>
</ReportSummary>
</NewDataSet>
预期XLS与Division and Region coloms中常见细胞的合并:
| 部门 | 地区 | 销售团队 | |||||||||||||
| 美国 | 西 | ABC | |||||||||||||
| xyz | |||||||||||||||
| 东部 | asd | ||||||||||||||
| lmn | |||||||||||||||
|
Please any help will be really appreciable.. Thanks in advance... 推荐答案
谢谢，但没有用. thanx but not useful.. 这篇关于使用xslt将XML转换为excel(带有ss:MergeDown的问题)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取
|
15天全站免登陆
|