<a-upload
  name="file"
  :customRequest="importExcelData"
  accept=".xls,.xlsx"
  class="uploadBtn"
  :showUploadList="false"
>
  <a-button
    type="primary"
    style="margin-right: 8px"
    :loading="uploading"
    >導(dǎo)入excel</a-button
  >
</a-upload>

import * as xlsx from "xlsx";

//導(dǎo)入excel
const uploading = ref(false);
// 文件上傳自定義
const importExcelData = async (op) => {
  uploading.value = true;

  // 獲取上傳的excel  并解析數(shù)據(jù)
  let file = op.file;
  let dataBinary = await readFile(file);
  let workBook = xlsx.read(dataBinary, { type: "binary", cellDates: true });

  let workSheet = workBook.Sheets[workBook.SheetNames[0]];
  const excelData = xlsx.utils.sheet_to_json(workSheet);

  let result = [];
  for (let i = 0; i < excelData.length; i++) {
    //循環(huán)excel數(shù)據(jù)，將字段名置為英文字符，值為當(dāng)前項(xiàng)相應(yīng)表頭字段的值，拼成接口需要的數(shù)據(jù)格式
    // 定義要導(dǎo)出的
    let sheetData = {
      branch: excelData[i]["分公司"], //第i項(xiàng)，對應(yīng)表頭為樓宇名稱的列值
      grid: excelData[i]["網(wǎng)格"],
      buildingId: excelData[i]["樓宇id"],
      buildingName: excelData[i]["樓宇名稱"],
    };
    result.push(sheetData);
  }
  return new Promise((resolve, reject) => {
    GzBuildingsApi.importExcelData(result)
      .then((response) => {
        const data = response.data;
        if (data.code === 200) {
          message.success("導(dǎo)入成功");
          uploading.value = false;
          query();
        } else {
          message.error(data.message);
        }
      })
      .catch((error) => {});
  });
};

const readFile = (file) => {
  return new Promise((resolve) => {
    let reader = new FileReader();
    reader.readAsBinaryString(file);
    reader.onload = (ev) => {
      resolve(ev.target?.result);
    };
  });
};