The file name will come with a '-predefined' suffix. Like the result above, you will be prompted a link to the generated PDF file. Now click the menu Add-ons > PDF Assistant > Export predefined area.In the side panel, add all named ranges you want to print in a name pattern of print_area_ is a number.In version 1.1.0, the script supports exporting predefined areas to a PDF file.
We also want to automate as much as possible. Print selected area in Google Sheets as a PDF file Print predefined areas to a PDF file The file name comes with a '-selected' suffix.
You will be given the link of PDF, which is saved in the root folder of your Drive. 
Click the menu Add-ons > PDF Assistant > Export selected area. 
Select multiple ranges with the CTRL button pressed. It gives you some flexibility to print only the area of interest for your client. This feature is complementary to Google Sheets' default export feature. The PDF file will be generated in your Drive root folder, in the name of the sheet.Įxport current sheet as a PDF file Print selected area (part of sheets) to a PDF file. Click Add-ons > PDF Assistant > Export current sheet. Print all sheets as separate PDF files Print current sheet as a PDF file The menu Add-ons > PDF Assistant > Export all sheets as separate files iterate your spreadsheet and save each sheet as a PDF file in your Drive root folder. Print all sheets to a PDF file Print all sheets as a PDF file using apps script Print all sheets as separate PDF files The script / add-on will save a PDF copy or multiple PDF copies in the root of your Google Drive depending on your printing choices. This apps script may be helpful for your automation.īefore diving into the source code, let's take a look at demos ( Demo Sheet). Well, it's an alternative to automate things, for example, you recorded a macro on an inventory spreadsheet to refresh stocks and make a snapshot everyday as a pdf file. You may ask "why not use the default feature File > Download as > PDF document". This article shares with you a snippet of Apps script that could print the entire google sheets or selected area to a pdf file.
0 kommentar(er)
