plotly/react-pivottable

Export Table as Excel File / PDF

ahmedhamza47 opened this issue · 2 comments

ahmedhamza47 commented

Hello I would like to export the table as excel file or as pdf. But I am not being able to do it. Can anyone help me with this issue. It would be really helpful!

himanshu0911 commented

I am also looking for the same as well. But not found how to do that

ahmedhamza47 commented

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.

  • 👍1