How would you tweak it to include some of the sheets — but not all? Hi Diane, Glad you found it useful. If someone is also looking for a solution how to get multiple sheets into one pdf file then anwer is hiding the sheets. You just hide the sheets not needed in pdf and run the script without specifing sheetName variable.
Is there a way of saving a multi-sheet workbook as individual PDFs with a consistent name format which includes the sheet name? This is great — thanks! Great script — thanks. Hi Andrew great script just wondering using your answer to Diane to send multiple pages to the PDF using this code.
Would you be able please to give me some pointers. Another issue with Gilbert's updated code was that the HTML request included a reference to the sheet ID, but not the spreadsheet itself. This caused the response to fail if you provided a specific sheet ID, though it works fine if no sheet ID was provided. I got it to work again by reverting the URL base to the way Mogsdad had it. Another tweak: Gilbert's code automatically names the new.
PDF as whatever the spreadsheet was named. Meanwhile, Mogsdad's code prints out every sheet one at a time, naming each. PDF with the spreadsheet name followed by the name of the current sheet. I wanted to print the PDF with the name of the single sheet, if applicable, and also provide the user the ability to specify an output name. Since no method exists to "getSheetById", depending on the context of your code, it probably makes more sense for the function to take "optSheetName" instead of "optSheetID.
Both the name and the ID can be obtained programmatically from a bound script, but only the name can be used to get a specific existing sheet. I also added an optional email parameter so that you can print and email the PDF at the same time. All parameters described in the code are optional and if none are specified it uses the active spreadsheet, converts all of the tabs into a single PDF named after the spreadsheet and doesn't email the PDF. How are we doing?
Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 6 years, 6 months ago. Active 3 years, 3 months ago. Viewed 17k times. Improve this question. Mogsdad Bryan Buford Bryan Buford 61 1 1 gold badge 1 1 silver badge 2 2 bronze badges. NathanHughes - this question is about all sheets in a spreadsheet, while previous was about a single sheet.
Subtle difference, but not duplicate, imo. Further, since the time of the accepted answer on other question, the OAuth story became much simpler - not that it changes the question, but people are less likely to adapt code from closed questions, so we might do a disservice by closing this one.
Regardless, I tacked the answer on both to make it easy for others to find. Mogsdad: thanks for the clarification, I retracted my close vote. NOTE: This doesn't work if the sheet is hidden. Use activate to unhide a sheet. Don't have an account? Sign up for free. See what you can do with Google Sheets. Collaborate on data, from anywhere Establish a ground truth for data in your online spreadsheet, with easy sharing and real-time editing. Get to insights faster with built-in intelligence Assistive features like Smart Fill and formula suggestions help you analyze faster with fewer errors.
Seamlessly connect to other Google apps Sheets is thoughtfully connected to other Google apps you love, saving you time.
Build custom solutions Speed up workflows by building business apps and automations. Seamlessly connect to critical data Pull in and analyze data from the other tools you use, like customer data from Salesforce. Security, compliance, and privacy. Secure by default We use industry-leading security measures to keep your data safe, including advanced malware protections. Encryption in transit and at rest All files uploaded to Google Drive or created in Sheets are encrypted in transit and at rest.
Compliance to support regulatory requirements Our products, including Sheets, regularly undergo independent verification of their security, privacy, and compliance controls. You control your data. We never use your Sheets content for ad purposes. We never sell your personal information to third parties. Docs, Sheets, Slides, Forms content creation. Drive Secure cloud storage. Shared drives for your team.
0コメント