//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //1:20 rows' outline level will be 2. worksheet.Range["1:20"].Group(); //1:10 rows' outline level will be 3. worksheet.Range["1:10"].Group(); //1:10 rows' outline level will be 2. worksheet.Range["1:10"].Ungroup(); //1:20 rows' outline level will be 1. worksheet.Range["1:20"].Ungroup(); // Save to an excel file workbook.Save("UngroupRange.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) '1:20 rows' outline level will be 2. worksheet.Range("1:20").Group() '1:10 rows' outline level will be 3. worksheet.Range("1:10").Group() '1:10 rows' outline level will be 2. worksheet.Range("1:10").Ungroup() '1:20 rows' outline level will be 1. worksheet.Range("1:20").Ungroup() ' save to an excel file workbook.Save("UngroupRange.xlsx")