PRINT SELECTION IN GOOGLE SHEETS HOW TO
PRINT SELECTION IN GOOGLE SHEETS PDF
PRINT SELECTION IN GOOGLE SHEETS DOWNLOAD

addItem('Export current sheet', 'exportCurrentSheetAsPDF') addItem('Export all sheets as separate files', 'exportAllSheetsAsSeparatePDFs') addItem('Export all sheets', 'exportAsPDF') You must have EDIT permission to the same folder To save in the same folder as the spreadsheet, change the value to 'false' without the single quote pair By default, PDFs are saved in your Drive Root folder

PRINT SELECTION IN GOOGLE SHEETS PDF

* Support printing the selected areas as a pdf * 1.0.0 Support printing the entire spreadsheet as a pdf * 1.1.0 Support printing predefined areas as a pdf * 1.2.0 Support printing current sheet as pdf * 1.2.1 Fix a reference issue of printing current sheet * 1.2.2 Add formatting for a single selected area * 1.2.3 Add formatting for a single predefined area * 1.3.0 Support printing the entire spreadsheet as separate pdf files * 1.3.3 Add an option to save PDF files in the same folder * 1.3.4 Add retrying for printing many sheets

PRINT SELECTION IN GOOGLE SHEETS HOW TO

Print a predefined area or areas in Google Sheets as a PDF file Source codeĭo you know how to use this piece of source code? If not, check out my another tutorial learning how to Add An Apps Script To Your Google Apps.įeel free to leave comments below if you have questions, feature requests and bugs. 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.

PRINT SELECTION IN GOOGLE SHEETS DOWNLOAD

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.

Print selection in google sheets