Hi
I want a small clarification on one of the use case related to Excel Library.
I want to know how we can Add the GroupedRows functionality for Row, Which we can expand by clicking on + icon.
So, for this I need to know how can we achieve that.
Hoping for a positive response.
Thanks!!!
The OutlineLevel property is set via:
I don't have a complete working groupby column sample as it's too complicated. You will have to reorder your datasource based on what is grouped before you export. It's best if you wait for our Angular grid to be ported to React.
Our current React DataGrid's export is primitive and manual as we never made a fully integrated Excel exporter.
By using this sample:
https://github.com/IgniteUI/igniteui-react-examples/tree/vnext/samples/excel/excel-library/operations-on-workbooks
From there you can get the group by columns via the grid's GroupDescriptions collection. This will populate whether a user or a column is grouped programmatically.
You'll need to create a new Worksheet row for each group. Each group can be found like this when you perform the Save.
Hello Michael,
Thank you for your response.
Can you please provide a sample code for this that will really helpful for us.
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.
FYI
We are using the Excel Library.
https://es.infragistics.com/products/ignite-ui-react/react/components/excel-library
We wanted to know how we can Export the Grouped row in Excel, with Expand and Collapse functionality.
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.