将带公式的列表标签表导出到Excel

const excel = require('exceljs');
const COS = require('cos-nodejs-sdk-v5');

exports.main_handler = async (event, context, callback) => {
  // 获取列表标签表格数据
  const tableData = getTableData();

  // 创建Excel工作簿
  const workbook = new excel.Workbook();
  const worksheet = workbook.addWorksheet('Sheet1');

  // 将数据写入Excel工作表
  for (let i = 0; i < tableData.length; i++) {
    const rowData = tableData[i];
    for (let j = 0; j < rowData.length; j++) {
      worksheet.getCell(`${String.fromCharCode(65 + j)}${i + 1}`).value = rowData[j];
    }
  }

  // 保存Excel文件到本地
  const filePath = '/tmp/exported_data.xlsx';
  await workbook.xlsx.writeFile(filePath);

  // 上传Excel文件到腾讯云对象存储（COS）
  const cos = new COS({
    SecretId: 'your_secret_id',
    SecretKey: 'your_secret_key',
  });
  const cosParams = {
    Bucket: 'your_bucket_name',
    Region: 'your_bucket_region',
    Key: 'exported_data.xlsx',
    FilePath: filePath,
  };
  await cos.putObject(cosParams).promise();

  // 返回Excel文件的下载链接
  const downloadUrl = `https://${cosParams.Bucket}.cos.${cosParams.Region}.myqcloud.com/${cosParams.Key}`;
  callback(null, downloadUrl);
};