Skip to content

Instantly share code, notes, and snippets.

@arun12209
Created July 23, 2023 15:36
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save arun12209/657663ce5c81de0369e883a0ce4ff86e to your computer and use it in GitHub Desktop.
exportToExcel.js
// exportToExcel.js
import { LightningElement } from 'lwc';
import SheetJS from '@salesforce/resourceUrl/SheetJS'; // The static resource for SheetJS
import { loadScript, loadStyle } from 'lightning/platformResourceLoader';
export default class ExportToExcel extends LightningElement {
async connectedCallback() {
await loadScript(this, SheetJS); // load the library
// At this point, the library is accessible with the `XLSX` variable
this.version = XLSX.version;
console.log('version: '+this.version);
}
exportToExcel() {
// Sample table data for demonstration purposes
const tableData = [
['John Doe', 30, 'john.doe@example.com'],
['Jane Smith', 28, 'jane.smith@example.com'],
['Michael Johnson', 35, 'michael.johnson@example.com'],
// Add more data as needed
];
const filename = 'ExportToExcel.xlsx';
const workbook = XLSX.utils.book_new();
const headers = [];
const worksheetData = [];
for (const record of tableData) {
worksheetData.push({
"Name": record[0],
"Age": record[1],
"Email":record[2]
});
}
const worksheet = XLSX.utils.json_to_sheet(worksheetData, { header: headers });
XLSX.utils.book_append_sheet(workbook, worksheet, 'ExportToExcel');
const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
// Create a download link and click it programmatically to initiate the download
const a = document.createElement('a');
a.href = URL.createObjectURL(blob);
a.download = filename;
a.click();
// Release the object URL to free up memory
URL.revokeObjectURL(a.href);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment