如何在用suitelet创建的excel文件中传递动态值

/**
 * Suitelet脚本示例：生成包含动态值的Excel文件
 */
function suitelet(request, response) {
  // 创建Excel文件
  var workbook = new ExcelJS.Workbook();
  var worksheet = workbook.addWorksheet('Sheet 1');

  // 设置动态值
  var dynamicValue = 'Hello, World!';
  worksheet.getCell('A1').value = dynamicValue;

  // 将Excel文件作为响应返回
  response.setContentType('EXCEL');
  response.setHeader('Content-Disposition', 'attachment; filename="dynamic_excel.xlsx"');
  response.write(workbook.xlsx.writeBuffer());
}

// 注册Suitelet脚本
var suiteletUrl = url.resolveScript({
  scriptId: 'customscript_suitelet',
  deploymentId: 'customdeploy_suitelet',
});
var suiteletForm = serverWidget.createForm({
  title: 'Generate Dynamic Excel',
});
suiteletForm.addButton({
  id: 'generate_excel',
  label: 'Generate Excel',
  functionName: 'generateExcel',
});
suiteletForm.clientScriptModulePath = './client_script.js';
suiteletForm.addSubmitButton({
  label: 'Submit',
});
suiteletForm.addField({
  id: 'dynamic_value',
  type: serverWidget.FieldType.TEXT,
  label: 'Dynamic Value',
});
suiteletForm.addPageInitMessage({
  type: serverWidget.MessageType.INFORMATION,
  title: 'Information',
  message: 'Please enter a dynamic value.',
});
suiteletForm.addPageInitMessage({
  type: serverWidget.MessageType.WARNING,
  title: 'Warning',
  message: 'The dynamic value will be inserted into cell A1 of the Excel file.',
});
suiteletForm.addPageInitMessage({
  type: serverWidget.MessageType.INFORMATION,
  title: 'Information',
  message: 'Click the "Generate Excel" button to generate the Excel file.',
});
suiteletForm.addField({
  id: 'excel_url',
  type: serverWidget.FieldType.URL,
  label: 'Excel URL',
}).updateDisplayType({
  displayType: serverWidget.FieldDisplayType.DISABLED,
});
suiteletForm.addField({
  id: 'excel_link',
  type: serverWidget.FieldType.INLINEHTML,
  label: 'Excel Link',
}).defaultValue = '<a href="#" id="excel_link">Download Excel</a>';
suiteletForm.addField({
  id: 'excel_script',
  type: serverWidget.FieldType.INLINEHTML,
  label: 'Excel Script',
}).defaultValue = '<script src="' + suiteletUrl + '"></script>';
suiteletForm.addSubmitButton({
  label: 'Submit',
});

/**
 * 客户端脚本示例：生成Excel文件链接
 */
function generateExcel() {
  var dynamicValue = document.getElementById('dynamic_value').value;
  var excelLink = document.getElementById('excel_link');
  excelLink.href = suiteletUrl + '&dynamic_value=' + encodeURIComponent(dynamicValue);
  excelLink.click();
}

// 注册Suitelet脚本
var suitelet = serverScript.create({
  scriptType: serverScript.ScriptType.SUITELET,
  title: 'Generate Dynamic Excel',
  scriptFile: './suitelet.js',
});
suitelet.deploy({
  deploymentId: 'customdeploy_suitelet',
  queue: serverScript.QueueType.BACKGROUND,
  isDeployed: true,
});