使用angular-ui-grid@4.2.4导出到excel

import { Component } from '@angular/core';
import { GridOptions } from 'ag-grid-community';
import * as XLSX from 'xlsx';

@Component({
  selector: 'app-grid',
  templateUrl: './grid.component.html',
  styleUrls: ['./grid.component.css']
})
export class GridComponent {
  gridOptions: GridOptions;
  rowData: any[];

  constructor() {
    this.gridOptions = {
      columnDefs: [
        { headerName: 'Name', field: 'name' },
        { headerName: 'Age', field: 'age' },
        { headerName: 'Email', field: 'email' }
      ],
      rowData: this.rowData
    };
  }

  exportToExcel() {
    const params = {
      fileName: 'data.xlsx'
    };

    const excelParams = {
      sheetName: 'Sheet1',
      columnKeys: ['name', 'age', 'email']
    };

    this.gridOptions.api.exportDataAsExcel(excelParams, params);
  }
}