create_excel.js

import * as XLSX from 'xlsx';

function generateExcelTemplate() {
  // Create a new workbook
  const workbook = XLSX.utils.book_new();

  // Define your data
  const data = [
    ['Name', 'Email', 'Age'],
    ['John Doe', 'john@example.com', 30],
    ['Jane Smith', 'jane@example.com', 25],
  ];

  // Create a new worksheet and add data
  const worksheet = XLSX.utils.aoa_to_sheet(data);

  // Add the worksheet to the workbook
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet 1');

  // Generate a Blob object containing the Excel file
  const blob = XLSX.write(workbook, { bookType: 'xlsx', type: 'blob' });

  // Create a download link
  const url = window.URL.createObjectURL(blob);
  const a = document.createElement('a');
  a.href = url;
  a.download = 'template.xlsx';
  a.textContent = 'Download Excel Template';

  // Append the link to the DOM and trigger a click event to download the file
  document.body.appendChild(a);
  a.click();

  // Clean up
  window.URL.revokeObjectURL(url);
  document.body.removeChild(a);
}

document.getElementById('generateExcel').addEventListener('click', generateExcelTemplate);