-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathconvertToPdf.gs
More file actions
32 lines (27 loc) · 1.05 KB
/
convertToPdf.gs
File metadata and controls
32 lines (27 loc) · 1.05 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
function convertToPdf_(spreadsheetId) {
var spreadsheet = spreadsheetId ? SpreadsheetApp.openById(spreadsheetId) : SpreadsheetApp.getActiveSpreadsheet();
spreadsheetId = spreadsheetId ? spreadsheetId : spreadsheet.getId()
var url_base = "docs.google.com/spreadsheets/d/" + spreadsheet.getId() + "/";
var parents = DriveApp.getFileById(spreadsheetId).getParents();
var folder = parents.hasNext() ? parents.next() : DriveApp.getRootFolder();
var url_export = 'export?exportFormat=pdf&format=pdf&id=' + spreadsheetId
+ '&portrait=true'
+ '&fitw=true'
+ '&size=letter'
+ '&gridlines=false';
+ '&fzr=false';
var options = {
headers: {
'Authorization': 'Bearer ' + ScriptApp.getOAuthToken(),
}
}
var response = UrlFetchApp.fetch(url_base + url_export, options);
var blob = response.getBlob().setName(pdfName);
var files = DriveApp.getFilesByName(pdfName);
while(files.hasNext()) {
var file = files.next();
Drive.Files.remove(file.getId())
}
folder.createFile(blob);
return blob;
};