Facing issue in GroupedRows functionality while Exporting grid to excel | Infragistics Forums

State See Verified Answer
Replies 11 replies
Subscribers 7 subscribers
Views 5338613 views
Users 0 members are here

590

Facing issue in GroupedRows functionality while Exporting grid to excel

Shubham Patil posted over 1 year ago

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!!!

Top Replies

29085

Offline Michael DiFilippo posted over 1 year ago in reply to Shubham Patil +1 verified
To collapse rows 6, 7, and 8 under row 5 you just have to set this. ws . rows ( 5 ). outlineLevel = 1 ; ws . rows ( 6 ). outlineLevel = 1 ; ...view reply »

Parents

No Data

Reply

29085

Offline Michael DiFilippo posted over 1 year ago

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.
Cancel
Reply

Verify Answer

Cancel

Children

590

Offline Shubham Patil posted over 1 year ago in reply to Michael DiFilippo

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.

for (let i = 0; i < gridData.actualCount; i++) {

  var item = gridData.getItemAtIndex(i);

  let row: WorksheetRow = sheet.rows(i + 1);

  Object.entries(item).map(([key, value]) => {

  const columnIndex = columns.indexOf(key);

  if (columnIndex !== -1) {

  row.cells(columnIndex).value = value;

} else return;

});

}

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.
Cancel
Reply

Verify Answer

Cancel