Hello Michael,

Thank you for your response.

We are using IgrDataGrid and by using the following code, we are able to Export the grid to Excel.

We want to know if any row has grouped data then how can we Export that in Excel, So that we can get the + Icon in Excel Sheet to Expand and collapse the data in that row.

Hoping for a positive response.

Thanks.

The WorksheetRow and WorksheetColumn classes have an OutlineLevel property. Rows and columns with the same outline level will be grouped in the exported workbook.

Excel supports hierarchical grouping of rows and columns with a maximum of seven levels of hierarchy. To create a group, set adjacent rows or columns to same outline level. When rows or columns are grouped, an outline indicator will provide a visual representation of the outline level. In addition, an outline group has an expansion indicator at one end of the group, which allows the user to easily hide and unhide all rows or column in the group with a single click.

Hello Michael,

Thanks for your response.

This is working as expected.

I want small clarification, by using the outlineLevel property the grouping is Expanded by default In the Excel sheet is there any property to set the grouping Collapse by default, in the excel sheet.

Thanks.

To collapse rows 6, 7, and 8 under row 5 you just have to set this.

Hello Michael,

Please let us know if there is any update on this.

Hello Michael,

I want a small clarification on the OutlineLevel property.

I have set ws.rows(5).outlineLevel = 1; So it is creating Expand collapse option at 5th row In Excel Sheet, So here I want that this Expand and Collapse option at 5th row should work for next 3 row in Excel sheet that will be 6th,7th,8th in this case. So I can Expand and collapse 6th, 7th and 8th row by clicking on the option. 

Basically I want to know, How can I define that for next how many rows this Expand Collapse should work.

For this I want to know how can I achieve this.

Hoping for positive response.

Thanks.