分组和取消分组行和列

使用IronXL库，无需 Office Interop 即可通过直观的 API 对行和列进行分组和取消分组。

行分组与取消分组

GroupRows 方法按索引位置对行进行分组。 你可以使用此方法应用多个分组。

要取消行分组，请使用 UngroupRows 方法。 此方法就像一个切割工具。 当应用于一行组的中间时，它会将该组分成两部分。 然而，这些新分组仍然作为一个逻辑组相互关联。例如，将包含 0-9 行的分组中的第 2-4 行取消分组，将得到分组 0-1 和 5-9。

列分组与取消分组

列可以像行一样进行分组。 使用 GroupColumns 方法按索引或将列名指定为字符串对列进行分组。 如有需要，可创建多个列组。

使用 UngroupColumns 方法取消列分组，该方法也可用作剪切工具。 将其应用于列组的中心，即可将其分成两列。 例如，取消分组 C-D 列在 A-F 组内将导致组 A-B 和 E-F。

请注意，以上提到的所有指数位置均采用从零开始的索引方式。 分组功能只能应用于包含值的单元格。

使用 IronXL 学习如何对 Excel 行和列进行分组和取消分组

相关文档链接

报告此页面的问题

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 12
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 19
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

准备开始了吗？
Nuget 下载 1,890,100 | 版本: 2026.3 刚刚发布

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 17
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/examples/index.php
Line: 270
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 24
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/examples/index.php
Line: 270
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Examples.php
Line: 44
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

Still Scrolling Icon

还在滚动吗？

想快速获得证据？ PM > Install-Package IronXl.Excel
运行示例 观看您的数据变成电子表格。