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!!!
Hello and thank you for contacting Infragistics. Are you using the IgrDataGrid? We currently do not have an Excel exporter for this grid. We are in the plans to adding our Angular grid to React which has full built-in support for Excel.
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.
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.
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.
To collapse rows 6, 7, and 8 under row 5 you just have to set this.
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.
Hi, I am glad this worked for you. Try setting the Hidden property on the WorksheetRow object as explained in this thread:
www.infragistics.com/.../how-do-i-expand-collapse-a-row-or-column-s-outlinelevel