const fileType =
    "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8";
  const fileExtension = ".xlsx";

  const exportToCSV = (csvData, fileName) => {
    /* generate worksheet */
    var ws = XLSX.utils.table_to_sheet(document.getElementById("table"), {
      raw: true,
    });

    for (let key in ws) {
      if (
        key === "!ref" ||
        key === "!fullref" ||
        key === "!merges" ||
        key === "!cols" ||
        key === "!rows"
      )
        continue;

      if (key === "A1") {
        ws[key].s = {
          ...ws[key]?.s,
          font: {
            bold: true,
            underline: true,
            color: "#FF0000",
            sz: 15,
          },
        };
      }
    }

    /* add merges */
    // if (!ws["!merges"]) ws["!merges"] = [];
    // ws["!merges"] = [...merge];
    // let columns = ["A", "B", "C", "D"];
    // let rows = [1, 2, 3];

    console.log(ws);

    const wb = { Sheets: { data: ws }, SheetNames: ["data"] };

    const excelBuffer = XLSX.write(wb, {
      bookType: "xlsx",
      type: "array",
      cellStyles: true,
    });
    const data = new Blob([excelBuffer], { type: fileType });
    FileSaver.saveAs(data, fileName + fileExtension);
  };