我正在使用一个脚本来创建一个PDF文件并保存它。除了我不知道如何使它“适合整个页面”之外,一切都很好。下面的代码是用于“适应宽度”(fitw=true),这在许多地方都有描述,但我找不到如何适应整个页面的方法。
function savePdf(spreadsheetId, sheetName, pdfName, pdfFolderId) {
var sheetId = spreadsheetId.getSheetByName(sheetName).getSheetId();
var url_base = spreadsheetId.getUrl().replace(/edit$/,'');
var url_ext = 'export?exportFormat=pdf&format=pdf'
+ '&gid=' + sheetId
// following parameters are optional...
+ '&range=D4:AX74'
+ '&size=A4' // paper size: legal / letter / A4
+ '&portrait=false' // orientation, false for landscape
+ '&fitw=true' // fit to width, false for actual size
+ '&top_margin=0.50'
+ '&bottom_margin=0.50'
+ '&left_margin=0.50'
+ '&right_margin=0.50'
+ '&sheetnames=false' //
+ '&printtitle=false'
+ '&pagenumbers=false' //hide optional headers and footers
+ '&gridlines=false' // hide gridlines
+ '&fzr=true'; // false = do not repeat row headers (frozen rows) on each page
var url_options = {headers: {'Authorization': 'Bearer ' + ScriptApp.getOAuthToken(),}};
var response = UrlFetchApp.fetch(url_base + url_ext, url_options);
var blob = response.getBlob().getAs('application/pdf').setName(pdfName + '.pdf');
var folder = DriveApp.getFolderById(pdfFolderId);
folder.createFile(blob);
}