Breaking News: Grepper is joining You.com. Read the official announcement!

export current page grid data along with additional data igx grid

Nanu answered on December 21, 2023 Popularity 1/10 Helpfulness 8/10

answer export current page grid data along with additional data igx grid

export current page grid data along with additional data igx grid

Comment

<igx-grid-toolbar-actions>
                    <button (click)="exportToolbar()"
                        style="background-color: lightblue;border-radius: 7%;font-weight: 500;">
                        <mat-icon svgIcon="mat_outline:import_export"></mat-icon>Export</button>
                </igx-grid-toolbar-actions>
                exportToolbar() {
    const additionalData = [
      { MemberId: this.memberCode, MemberName: this.memberName, TotalInvoiceAmount: this.totalInvoiceAmount, TotalPaidAmount: this.totalPaidAmount, TotalNetDueAmount: this.totalNetDueAmount }
    ];

    const gridData = this.premiumAccountGrid.data;
    const filteredGridData = gridData.map(item => {
      const { memberId, memberCode, ...rest } = item;
      return rest;
    });

    // Rearrange data to match the desired structure
    const rearrangedData = [
      ...additionalData,
      {}, // Blank row
      {}, // Blank row
    ];

    filteredGridData.forEach(row => {
      rearrangedData.push({ MemberId: '', MemberName: '', TotalNetDueAmount: '', TotalInvoiceAmount: '', TotalPaidAmount: '', ...row });
    });

    const exportOptions = new IgxExcelExporterOptions('ExportedData');
    exportOptions.ignorePinning = false;
    exportOptions.exportAsTable = false;
    // Set other options as needed

    const sheet = this.excelExporter.exportData(rearrangedData, exportOptions);

  }

Popularity 1/10 Helpfulness 8/10 Language whatever

Source: Grepper

Tags: current-page export grid igx-grid whatever

Link to this answer
Share Copy Link

Contributed on Dec 21 2023

Nanu

0 Answers Avg Quality 2/10

export current page grid data along with additional data igx grid

Contents

More Related Answers

export current page grid data along with additional data igx grid

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.