How to create group outline level

[Sharad Kumar]

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 = "....";
oRange.Group(ExcelGroupBy.ByColumns,true);

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

Thanks

Attachment: Group_9f84f491.rar

[Sridhar Sukumar]

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. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/GroupLevel-875134571.zip 

 

kindly use this sample and let us know whether your requirements are fulfilled. 

 

Regards, 

Sridhar S  

[Sharad Kumar]

Thank you Sridhar.

[Kesavan D]

Hi Sharad, 

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

Regards, 

Kesavan