...
代码块 | ||
---|---|---|
| ||
//电子表格服务端宏,电子表格服务端宏-导出PDF-调整页面左边距
//类型:ServerSide 对象:spreadsheetReport 事件:onBeforeOutput
function main(spreadsheetReport) {
var sheet = spreadsheetReport.workbook.worksheets.get(0);
if (sheet === "" || sheet === null) {
return;
}
var type = spreadsheetReport.outputType; //导出类型
// 打印和导出PDF的时候设置页面左边距
if (type == "PRINT" || type == "PDF") {
var pageSetup = sheet.getPageSetup();
pageSetup.setLeftMargin(1);
}
} |
...