0

I'm trying to print a sheet from a Sheet in PDF on landscape to the bottom row that has data in it (essentially printing an area that's dynamic). The code I have is below, but it's not cropping the data and it's only doing it in portrait mode.

It's renaming appropriately based on the cell data.

function PDF() {
  var folderID = "**FOLDERID**"; // Folder id to save in a Drive folder.
  var sheet = SpreadsheetApp.openByUrl(
     'https://docs.google.com/spreadsheets/d/**SHEETID**/export?format=pdf&portrait=false'); 
  var pdfName = sheet.getRange("A1").getValue(); //Need to set the values to another sheet
  var sourceSpreadsheet = SpreadsheetApp.getActive();
  var folder = DriveApp.getFolderById(folderID);

  // A sample script was added here.
  var url = "https://www.googleapis.com/drive/v3/files/" + sourceSpreadsheet.getId() + "/export?mimeType=application/pdf&portrait=false";
  var options = {
      method: "GET",
      headers: {Authorization: "Bearer " + ScriptApp.getOAuthToken()},
      muteHttpExceptions: true
  };
  var response = UrlFetchApp.fetch(url, options).getBlob();
  DriveApp.getFolderById(folderID).createFile(response).setName(pdfName);
}
Rubén
  • 34,714
  • 9
  • 70
  • 166
J M
  • 21
  • 3

0 Answers0