Here is a basic example:
// Load the required library (e.g., xlsx)
const XLSX = require('xlsx');
// Create a new workbook and worksheet
const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.json_to_sheet([
{ Name: 'John Doe', Age: 30 },
{ Name: 'Jane Smith', Age: 25 }
]);
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
// Convert the workbook to binary
const wbout = XLSX.write(workbook, { bookType: 'xlsx', type: 'binary' });
// Convert binary string to an ArrayBuffer
function s2ab(s) {
const buf = new ArrayBuffer(s.length);
const view = new Uint8Array(buf);
for (let i = 0; i < s.length; i++) view[i] = s.charCodeAt(i) & 0xFF;
return buf;
}
// Create a blob from the ArrayBuffer
const blob = new Blob([s2ab(wbout)], { type: 'application/octet-stream' });
// Create a link element
const link = document.createElement('a');
link.href = URL.createObjectURL(blob);
link.download = 'example.xlsx'; // Name of the file to be downloaded
// Append the link to the document
document.body.appendChild(link);
// Programmatically click the link to trigger the download
link.click();
// Remove the link from the document
document.body.removeChild(link);
