vue 导出excel

exportAll() {
  // 获取当前时间yyyyMMddHHmmss
const now = new Date();
  const year = now.getFullYear();
  const month = String(now.getMonth() + 1).padStart(2, '0');
  const day = String(now.getDate()).padStart(2, '0');
  const hours = String(now.getHours()).padStart(2, '0');
  const minutes = String(now.getMinutes()).padStart(2, '0');
  const seconds = String(now.getSeconds()).padStart(2, '0');

  const formattedDate = `${year}${month}${day}${hours}${minutes}${seconds}`;
  console.log(formattedDate);

  const workbook = XLSX.utils.book_new();

  // Create sheets
const worksheetWorkplace = XLSX.utils.json_to_sheet(this.workplaceData);
  const worksheetGroup = XLSX.utils.json_to_sheet(this.groupData);
  const worksheetAgent = XLSX.utils.json_to_sheet(this.agentData);

  // Append sheets to workbook
XLSX.utils.book_append_sheet(workbook, worksheetWorkplace, '职场');
  XLSX.utils.book_append_sheet(workbook, worksheetGroup, '小组');
  XLSX.utils.book_append_sheet(workbook, worksheetAgent, '坐席');

  // Write workbook and trigger download
const workbookBinary = XLSX.write(workbook, { bookType: 'xlsx', type: 'binary' });
  const buffer = new ArrayBuffer(workbookBinary.length);
  const view = new Uint8Array(buffer);
  for (let i = 0; i < workbookBinary.length; i++) {
    // eslint-disable-next-line no-bitwise
view[i] = workbookBinary.charCodeAt(i) & 0xFF;
  }
  const workbookBlob = new Blob([buffer], { type: 'application/octet-stream' });
  const downloadElement = document.createElement('a');
  const href = URL.createObjectURL(workbookBlob);
  downloadElement.href = href;
  downloadElement.download = '导出数据_'.concat(formattedDate).concat('.xlsx');
  document.body.appendChild(downloadElement);
  downloadElement.click();
  document.body.removeChild(downloadElement);
  URL.revokeObjectURL(href);

  console.log('Export all data');
},