//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A:N"].Group(); worksheet.Range["A:F"].Group(); worksheet.Range["A:C"].Group(); worksheet.Range["Q:Z"].Group(); worksheet.Range["Q:T"].Group(); //level 3 and level 4 will be collapsed. level 2 and level 1 expand. worksheet.Outline.ShowLevels(columnLevels: 2); // Save to an excel file workbook.Save("ShowSpecificLevel.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range("A:N").Group() worksheet.Range("A:F").Group() worksheet.Range("A:C").Group() worksheet.Range("Q:Z").Group() worksheet.Range("Q:T").Group() 'level 3 and level 4 will be collapsed. level 2 and level 1 expand. worksheet.Outline.ShowLevels(columnLevels:=2) ' save to an excel file workbook.Save("ShowSpecificLevel.xlsx")