LinkBack URL
About LinkBacks
Hello I'm looking to create a PDF from a Google sheet. I have tried many things in the Google help, even did a macro but it is not working. Trying to use app script. Is there a simple code? If can someone point me in the right direction. Thank you.
Hello I'm looking to create a PDF from a Google sheet. I have tried many things in the Google help, even did a macro but it is not working. Trying to use app script. Is there a simple code? If can someone point me in the right direction. Thank you.
file>download>PDF(.pdf)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you etaf that does work. Do you know how I can automate that using app script?
you are welcome
No - sorryDo you know how I can automate that using app script?
Using apps script, you can export the file to PDF that will be stored in your Google Drive.Do you know how I can automate that using app script?
An apps script cannot create the PDF and cause a download because apps script doesn't have that level of access (to browser/system functions)
The only way to automatically download as PDF is with the menu options given by etaf
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Thank you janmorris I appreciate the information. So then what I would be looking for then is instead of creating a PDF I would export the spreadsheet as a pdf using app script and then putting that exported pdf into a google drive folder. would I use the convertToPDF script to perform that function? I have also seen that when I was looking for information on this subject matter of PDFs. Do you know of a place where I can find an easy script to be able to use for exporting the sheet as a pdf?
Hi Appolobsg75,
Without getting into all of the details, an apps script to export Sheets to PDF can be complicated depending on the requirements.
I recommend you take a look at posts in StackOverflow, and see if theres something that closely matches your requirements then try to modify to your particular needs:
https://stackoverflow.com/search?q=%...-script%5D+pdf
Thank you very mush janmorris I will take a look there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks