通过XSLT进行Excel分组 [英] Excel Grouping through XSLT

问题描述

你好朋友，

我正在开发用于导出具有与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[^]

这篇关于通过XSLT进行Excel分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！