Margins parameters for Google spreadsheet export as PDF

by

Actually, it’s possible to set the margins and create a PDF. You just need to know the names of the parameters and their possible values. I’ve have got it to work with these

Parameters:

&format=pdf                   //export format
&size=a4                      //A3/A4/A5/B4/B5/letter/tabloid/legal/statement/executive/folio
&portrait=false               //true= Potrait / false= Landscape
&scale=1                      //1= Normal 100% / 2= Fit to width / 3= Fit to height / 4= Fit to Page
&top_margin=0.00              //All four margins must be set!
&bottom_margin=0.00           //All four margins must be set!
&left_margin=0.00             //All four margins must be set!
&right_margin=0.00            //All four margins must be set!
&gridlines=false              //true/false
&printnotes=false             //true/false
&pageorder=2                  //1= Down, then over / 2= Over, then down
&horizontal_alignment=CENTER  //LEFT/CENTER/RIGHT
&vertical_alignment=TOP       //TOP/MIDDLE/BOTTOM
&printtitle=false             //true/false
&sheetnames=false             //true/false
&fzr=false                    //true/false
&fzc=false                    //true/false
&attachment=false             //true/false

As you can see there are more parameters for PDF formatting than currently known circulating around the Internet. Yes, it seems like they are not documented by Google.

If PDF export fails, it’s probably an incorrect value. Some parameters do not have an effect on the Export. For example: your are using source=labnol, this is not a “real” parameter but it doesn’t cause any trouble.

Make sure you have all four margin parameters inside your url like this:

&top_margin=0.00&bottom_margin=0.00&left_margin=0.00&right_margin=0.00

Otherwise it won’t create the PDF.

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How do you create a “reverse pivot” in Google Sheets?
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. Automatic timestamp when a cell is filled out
  6. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  7. Apps Script: how to get hyperlink from a cell where there is no formula
  8. Retrieving Google Sheets cell border style programmatically
  9. Determining the last row in a single column
  10. Cannot find method getRange(number,number)?
  11. How do I add formulas to Google Sheets using Google Apps Script?
  12. Deleting rows in google sheets using Google Apps Script
  13. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  14. Adding Buttons To Google Sheets and Set value to Cells on clicking
  15. How to replace text in Google Spreadsheet using App Scripts?
  16. Custom function throws a “You do not have the permission required to setValue” error
  17. Google Apps Script: Dynamically creating spreadsheet menu items
  18. Script to convert .XLSX to Google Sheet and move converted file
  19. email notification if cell is changed
  20. Dynamic selection options in Google Apps Script for forms
  21. Hidden field in a Google Form
  22. Apply multiple font colors to the text in a single Google Sheets cell
  23. How to evaluate a spreadsheet formula within a custom function?
  24. Google Sheet use Importxml error could not fetch url [duplicate]
  25. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  26. Determine current user in Apps Script
  27. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  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