Node js如何连接读取文件excel cloud (在线)？

npm install exceljs

const ExcelJS = require('exceljs');

async function readOnlineExcel() {
  const workbook = new ExcelJS.Workbook();
  
  try {
    // 从URL加载Excel文件
    await workbook.xlsx.readFile('https://example.com/path/to/your/excel.xlsx');
    
    // 获取第一个工作表
    const worksheet = workbook.getWorksheet(1);
    
    // 遍历每一行
    worksheet.eachRow((row, rowNumber) => {
      // 遍历每一列
      row.eachCell((cell, colNumber) => {
        console.log(`Cell ${colNumber} of row ${rowNumber} contains: ${cell.value}`);
      });
    });
  } catch (error) {
    console.error('Error reading online Excel file:', error);
  }
}

readOnlineExcel();