Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options

by

Here is my spreadsheet-to-pdf script. It works with the new Google Spreadsheet API.

// Convert spreadsheet to PDF file.
function spreadsheetToPDF(id,index,url,name)
{
  SpreadsheetApp.flush();

  //define usefull vars
  var oauthConfig = UrlFetchApp.addOAuthService("google");
  var scope = "https://docs.google.com/feeds/";

  //make OAuth connection
  oauthConfig.setAccessTokenUrl("https://www.google.com/accounts/OAuthGetAccessToken");
  oauthConfig.setRequestTokenUrl("https://www.google.com/accounts/OAuthGetRequestToken?scope="+scope);
  oauthConfig.setAuthorizationUrl("https://www.google.com/accounts/OAuthAuthorizeToken");
  oauthConfig.setConsumerKey("anonymous");
  oauthConfig.setConsumerSecret("anonymous");

  //get request
  var request = {
    "method": "GET",
    "oAuthServiceName": "google",
    "oAuthUseToken": "always",
    "muteHttpExceptions": true
  };

  //define the params URL to fetch
  var params="?gid="+index+'&fitw=true&exportFormat=pdf&format=pdf&size=A4&portrait=true&sheetnames=false&printtitle=false&gridlines=false';

  //fetching file url
  var blob = UrlFetchApp.fetch("https://docs.google.com/a/"+url+"/spreadsheets/d/"+id+"/export"+params, request);
  blob = blob.getBlob().setName(name);

  //return file
  return blob;
}

I’ve had to use the “muteHttpExceptions” parameter to know exactly the new URL. With this parameter, I downloaded my file with the HTML extension to get a “Moved permanently” page with my final url (“https://docs.google.com/a/“+url+”/spreadsheets/d/”+id+”/export”+params”).

And note that I am in an organization. So I’ve had to specify its domain name (“url” parameter, ie “mydomain.com”).

More Related Contents:

  1. Determining the last row in a single column
  2. Moving google apps script to v8 file upload stopped working from sidebar
  3. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  4. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  5. Google Sheets OnEdit() – You do not have permission to call a service
  6. Detect user inserting row or column in a google spreadsheet and reacting in a script
  7. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  8. Format a Google Sheets cell in plaintext via Apps Script
  9. UiApp has been deprecated. Please use HtmlService instead
  10. Google app scripts: email a spreadsheet as excel
  11. Is there a way to keep two sheets synchronized?
  12. Selecting the last value of a column
  13. Moving Files In Google Drive Using Google Script
  14. onEdit simple trigger never seems to be triggered
  15. How to get filtered values from Filter after using setColumnFilterCriteria?
  16. Protect ranges with google apps script
  17. GAS “On edit” trigger not running when edited from API
  18. How to access new ‘in-cell-image’ from google apps script?
  19. How to convert a Google Sheets-File to an Excel-File (XLSX)
  20. Difference between getValue() and getDisplayValue() on google app script
  21. How to allow onEdit function to affect protected cell in a Google Sheet?
  22. Creating and Sending sheets in the same function
  23. How do I know if spreadsheet cells are merged using google apps script
  24. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. Google apps script error: “You do not have permission to call protect” [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment