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.
Unfortunately, activation email could not send to your email. Please try again.

How to create group outline level

Thread ID:





125653 Aug 31,2016 07:09 AM Sep 2,2016 03:30 AM UWP 3
Tags: XlsIO
Sharad Kumar
Asked On August 31, 2016 07:09 AM

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

Sridhar Sukumar [Syncfusion]
Replied On September 1, 2016 08:44 AM

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  

Sharad Kumar
Replied On September 1, 2016 11:01 PM

Thank you Sridhar.

Kesavan D [Syncfusion]
Replied On September 2, 2016 03:30 AM

Hi Sharad, 

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



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.