通过XSLT进行Excel分组

本文介绍了通过XSLT进行Excel分组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好朋友， 我正在开发用于导出具有与Excel相关的多个表的数据集的代码. 现在，我通过将数据集转换为XML并将其转换为具有XSLT格式的Excel来导出数据集. 现在工作正常. 问题是我想对新Excel文件中的行进行分组.我必须在不使用COM对象的情况下实现它. 因此，在通过XSLT代码进行操作时，我需要帮助. 我已经在Google上搜索了，却找不到任何好主意/代码. 有人可以帮我吗?这真的很紧急.

Hello Friends, I am in middle of developing a code for exporting Dataset having multiple tables with relation to Excel. Now i am exporting the dataset by converting it to XML and transforming it to Excel with XSLT formatting. It is working fine now. The issue is i want to group the rows in the new Excel file. I have to implement it without using the COM object. So i need help in doing it via XSLT code. I have googled it and coudnt find any good idea/code. Could anyone please help me in this? Its really urgent.

推荐答案

在excel代码中，您会这样称呼... Within the excel code you would call something like this... Rows("10:14").Select Selection.Rows.Group

此处是CP存档链接 [ ^ ]

Here is a CP Archive Link[^]