通过node lambda函数读取上传到s3的excel文件

const AWS = require('aws-sdk');
const XLSX = require('xlsx');

exports.handler = async (event) => {
  const s3 = new AWS.S3();
  
  // 获取上传的Excel文件信息
  const bucket = event.Records[0].s3.bucket.name;
  const key = decodeURIComponent(event.Records[0].s3.object.key.replace(/\+/g, ' '));
  
  try {
    // 下载Excel文件
    const params = {
      Bucket: bucket,
      Key: key
    };
    const data = await s3.getObject(params).promise();
    
    // 解析Excel文件
    const workbook = XLSX.read(data.Body, { type: 'buffer' });
    const sheetName = workbook.SheetNames[0];
    const worksheet = workbook.Sheets[sheetName];
    const jsonData = XLSX.utils.sheet_to_json(worksheet, { header: 1 });
    
    // 处理Excel数据
    // TODO: 在这里编写你的业务逻辑
    
    return {
      statusCode: 200,
      body: 'Excel文件读取成功'
    };
  } catch (error) {
    console.error(error);
    return {
      statusCode: 500,
      body: 'Excel文件读取失败'
    };
  }
};