Flexgrid export the data in zip file

Flexgrid export the data in zip file

Posted by: sandeep.a.kurup on 21 November 2024, 1:20 pm EST

• 

  sandeep.a.kurup

  • Post Options:
  • Link
    Copy

  Posted 21 November 2024, 1:20 pm EST

  I have a flexgrid with large number of data in it. Is there any option in flexgrid to download this data as a zip file. So that user can unzip and get the excel. I am currently using the below code to export to excel.

  import { FlexGridXlsxConverter } from ‘@grapecity/wijmo.grid.xlsx’;

  private saveAsync(grid: FlexGrid, fileName: string, onSaved?: (base64?: string) => any) {
  
  FlexGridXlsxConverter.saveAsync(grid, {includeCellStyles: false, includeColumnHeaders: true}, fileName, onSaved);
  
  }

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2024, 8:57 am EST

  Hi Sandeep,

  Yes, you can export the flexgrid in a zip file which will contain an Excel file with grid data. First of all, you’ll have to export the flexgrid to a base64 string. Then you can use this base64 string to convert it into an Excel file and download it wrapped inside a zip file manually.

  Please refer to the following sample demonstrating the same - https://stackblitz.com/edit/js-aczphp?file=index.js

  In case, you face any issues, please let us know.

  Regards