问题描述
你好朋友,
我正在开发用于导出具有与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.
推荐答案
Rows("10:14").Select
Selection.Rows.Group
Here is a CP Archive Link[^]
这篇关于通过XSLT进行Excel分组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!