Export Table as Excel File / PDF  #168

Activity

1. himanshu0911 commented on Feb 11, 2024

   

   himanshu0911

   on Feb 11, 2024

   More actions

   I am also looking for the same as well. But not found how to do that
2. ahmedhamza47 commented on Feb 11, 2024

   

   ahmedhamza47

   on Feb 11, 2024

   Author

   More actions

   There is no inbuilt method to export data as excel file

   const exportReport = () => {
   const pvtTable = document.getElementsByClassName('pvtTable');
   const worksheet: XLSX.WorkSheet = XLSX.utils.table_to_sheet(pvtTable[0]);
   const workbook: XLSX.WorkBook = {
   Sheets: { data: worksheet },
   SheetNames: ['data'],
   };
   const excelBuffer = XLSX.write(workbook, {
   bookType: 'xlsx',
   type: 'array',
   });

   const data: Blob = new Blob([excelBuffer], {
       type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8',
   });
   FileSaver.saveAs(data, 'ExcelReport.xlsx');
   

   }

   create a button and onClick call this function .
   Make sure to install necessary package.

   👍React with 👍2Reacted by RicardoSolorzano0 and p-kral