Is it possible in a Google Apps Script to Export to PDF several specific Sheets?

0
votes

So far based on what I know about Google Apps Script it's possible to export all sheets of a spreadsheet via script:

GOOGLE_URL_FEED + SSID + "&portrait=true&portrait=true&fitw=true&fzr=true&gridlines=0&exportFormat=pdf";

Or only single sheet via script

GOOGLE_URL_FEED + SSID + "&gid=74&portrait=true&portrait=true&fitw=true&fzr=true&gridlines=0&exportFormat=pdf";

Is it possible if a I have a Spreadsheet with say 5 sheets to export to PDF via script just 3 of them or pick exactly which ones I want to export?

1
pdfgoogle-apps-scriptspreadsheet
Possible duplicate of this, this. - Mogsdad

1 Answers

0
votes

Im pretty sure there isnt a way by building an export url. However you could make a copy of fhe spreadsheet, delete unwanted sheets, export, and delete that temp spreadsheet. Will add a few seconds extra but will work.