分組和取消分組行和列 使用IronXL庫，無需 Office Interop 即可透過直覺的 API 對行和列進行分組和取消分組。 行分組與取消分組 GroupRows 方法依索引位置將資料行分組。 你可以使用此方法套用多個分組。 若要取消行分組，請使用 UngroupRows 方法。 這種方法就像使用切割工具一樣。 當應用於一行組的中間時，它會將該組分成兩部分。 然而，這些新分組仍然作為一個邏輯組相互關聯。例如，將包含 0-9 行的分組中的第 2-4 行取消分組，將得到分組 0-1 和 5-9。 列分組與取消分組 列可以像行一樣進行分組。 使用 GroupColumns 方法以索引或將列名指定為字串對列進行分組。 如有需要，可建立多個列組。 使用 UngroupColumns 方法取消列分組，此方法也可用作剪切工具。 將其應用於列組的中心，即可分成兩列。 例如，將群組 AF 中的列 CD 取消分組，會得到群組 AB 和 EF。 請注意，以上提到的所有指數位置均採用從零開始的索引方式。 分組功能只能套用於包含值的儲存格。 使用IronXL學習如何對 Excel 行和列進行分組和取消分組 相關文檔連結 在 Github 上查看 相關教程 相關操作指南 類文檔 下載 IronXL DLL 回報此頁面的問題 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 剛剛發布 開始免費試用 免費 NuGet 下載 總下載量：1,890,100 查看許可證 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 還在捲動嗎？ 想要快速證明？ PM > Install-Package IronXl.Excel 執行範例 觀看您的資料變成試算表。 免費 NuGet 下載 總下載量：1,890,100 查看許可證
