We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

How to create group outline level

Dear Experts,

How to create outline level(1 to 7 level) on Columns and Rows in Excel file.

I am using following code.

ExcelEngine oengine = new ExcelEngine();
IApplication oApp = oengine.Excel;
oApp.DefaultVersion = ExcelVersion.Excel2007;
IWorkbook oWorkbook  =  oApp.Workbooks.Create(1);
IWorksheets osheets = oWorkbook.Worksheets;
IWorksheet  osheet = osheets .Worksheets[0];

IRange oRange = osheet .Range["..."];
oRange.Value2 = "....";

I am sending excel file which have 2 column group level.
Excel file is attach with mail.


Attachment: Group_9f84f491.rar

3 Replies

SS Sridhar Sukumar Syncfusion Team September 1, 2016 12:44 PM UTC

Hi Sharad, 
Thank you for contacting Syncfusion support. 
MS Excel creates new outline level only when if the columns or rows are child element of previous level.  
If you want to group columns or rows in different outline level, you should group the previous level child column or rows. We have shared a sample for creating 7 outline groups for rows and columns and it can be downloaded from the following link. 
kindly use this sample and let us know whether your requirements are fulfilled. 
Sridhar S  

SK Sharad Kumar September 2, 2016 03:01 AM UTC

Thank you Sridhar.

KD Kesavan D Syncfusion Team September 2, 2016 07:30 AM UTC

Hi Sharad, 

Hope your requirement is resolved. Kindly let us know if you need further assistance. 


Live Chat Icon For mobile
Up arrow icon