JAVASCRIPT

javascript read xlsx file

const xlsx = require('xlsx');

const xlsxToJson = (filePath, sheetName) => {
  const workbook = xlsx.readFile(filePath);
  const sheet = workbook.Sheets[sheetName];
  return xlsx.utils.sheet_to_json(sheet);
};

const jsonSheet = xlsxToJson('./test.xlsx', 'Sheet1');

javascript download xlsx file

const url = window.URL.createObjectURL(
        new Blob([response.data], {
          type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
        })
      );
const link = document.createElement("a");
link.href = url;
link.setAttribute("download", filename);
 document.body.appendChild(link);
 link.click();
 link.remove();

download xlsx file javascript

 const url = window.URL.createObjectURL(
        new Blob([response.data], {
          type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
        })
      );
      
 const link = document.createElement("a");
       link.href = url;
       link.setAttribute("download", filename);
       document.body.appendChild(link);
       link.click();
       link.remove();