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.
Syncfusion Feedback

How to create group outline level

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 [Syncfusion]
Replied On 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. 
 
Regards, 
Sridhar S  


Sharad Kumar
Replied On September 2, 2016 03:01 AM UTC

Thank you Sridhar.


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

Hi Sharad, 

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

Regards, 
Kesavan 


CONFIRMATION

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.

Warning Icon 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.Close Icon

;