用XLSX将html表格的特定列导出到excel文件中

// 引入SheetJS库
import XLSX from 'xlsx';

// 获取表格中的特定列数据
function getColumnData(columnIndex) {
  const columnData = [];
  const cells = document.querySelectorAll(`td:nth-child(${columnIndex})`);
  
  cells.forEach(cell => {
    columnData.push(cell.innerText);
  });
  
  return columnData;
}

// 创建一个新的工作簿
const workbook = XLSX.utils.book_new();

// 创建一个新的工作表
const worksheet = XLSX.utils.aoa_to_sheet([getColumnData(1)]);

// 将工作表添加到工作簿中
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

// 将工作簿转换为Excel文件的二进制数据
const excelData = XLSX.write(workbook, { type: 'binary', bookType: 'xlsx' });

// 将二进制数据转换为Blob对象
const blob = new Blob([s2ab(excelData)], { type: 'application/octet-stream' });

// 创建下载链接
const downloadLink = document.createElement('a');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'exported_data.xlsx';

// 模拟点击下载链接
downloadLink.click();

// 将字符串转换为ArrayBuffer对象
function s2ab(s) {
  const buf = new ArrayBuffer(s.length);
  const view = new Uint8Array(buf);
  
  for (let i = 0; i < s.length; i++) {
    view[i] = s.charCodeAt(i) & 0xFF;
  }
  
  return buf;
}