How to Group and Ungroup Rows & Columns

// Importing the IronXL library to work with Excel files
using IronXL;

// Load an existing spreadsheet from a file
// Ensure the file path "sample.xlsx" is correct and accessible
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Access the default worksheet in the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Group rows 1-9 in the worksheet. It's important to note that IronXL uses zero-based indexing.
// Therefore, row 1 is index 0 and row 9 is index 8 in zero-based indexing.
// GroupRows method will group the rows from index 0 to index 8 (which corresponds to rows 1-9).
workSheet.GroupRows(0, 8);

// Save the modified workbook to a new file
workBook.SaveAs("groupRow.xlsx");

// After running this code, the row grouping is saved in "groupRow.xlsx" file.

using IronXL;

// This code demonstrates how to ungroup rows in a spreadsheet using the IronXL library.
// IronXL is an Excel Library to work with Excel files in .NET (C#).

// Load an existing spreadsheet from a file named "sample.xlsx".
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet from the loaded workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Ungroup rows 3 to 5.
// Note that row indices are zero-based in IronXL, so rows 3-5 correspond to indices 2-4.
workSheet.UngroupRows(2, 4);

// Save the modified workbook to a new file named "ungroupRow.xlsx".
workBook.SaveAs("ungroupRow.xlsx");

using IronXL; // Reference the IronXL library for Excel file manipulation

// Load an existing spreadsheet from file named "sample.xlsx"
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Access the default worksheet within the loaded workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Apply grouping to columns A (index 0) through F (index 5)
// This action visually groups the columns in the Excel sheet
workSheet.GroupColumns(0, 5);

// Save the modified workbook as a new file named "groupColumn.xlsx"
workBook.SaveAs("groupColumn.xlsx");

using IronXL;

// This code demonstrates how to load, modify, and save an Excel workbook using IronXL.

// Load an existing spreadsheet from a file called "sample.xlsx".
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Access the default worksheet in the workbook.
// IronXL uses the notion of a DefaultWorkSheet, which is typically the first sheet in the workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Ungroup columns C through D.
// This removes any grouping that may have been applied to these columns.
workSheet.UngroupColumn("C", "D");

// Save the modified workbook to a new file named "ungroupColumn.xlsx".
// This ensures the original file remains unchanged and the modifications are saved in a new file.
workBook.SaveAs("ungroupColumn.xlsx");