LC019 Export Google Sheets as PDF with Apps Script
💮 about me 🔗 ashtonfei.com/
💮 upwork with me 🔗www.upwork.com/workwith/ashto...
🧑🏻💻 automation the boring
#pdf #clasp #googleappsscript
🔗 make a copy
docs.google.com/spreadsheets/...
🔗 source code
github.com/ashtonfei/live-cod...
🔗 repo live-coding
github.com/ashtonfei/live-cod...
🔗 repo google-apps-script-projects
github.com/ashtonfei/google-a...
🔗 repo gas-libs
github.com/ashtonfei/gas-libs/
🔗 gmail
yunjia.fei@gmail.com
🔗 upwork Freelancer
www.upwork.com/freelancers/~0...
🔗 twitter
/ ashton_fei
🔗 instagram
/ ashton.fei
🔗 buy me a beer
www.paypal.me/ashtonfei/
Пікірлер: 6
Viewer form Indonesia... 😊😊😊
Hwy Ashton, screen fo t size is not visible. Even the video quality is limited to 360p
@ashtonfei
Жыл бұрын
Came back later, HD is not yet available.
Google Apps Script - Login Multi User Category to Displaying Multiple Sheets kzread.info/dash/bejne/qWZnuqucZdO9m6w.html&ab_channel=ConsulthinkProgrammer
Hello, please help me export a Google Sheet to PDF with repeated headers like in Excel. I only want to repeat the header row (which has been entered beforehand, for example row 3:4) on all pages except for the first page. Thank you.
@ashtonfei
Жыл бұрын
You can use the query param 'fzr' to export them. However, I don't think it's possible to repeat row 3:4, it always starts from row 1. Example to repeat first top 4 rows (Make sure the rows are frozen in the tabs if you want them to repeat) docs.google.com/spreadsheets/d/{id}/export?format=pdf&fzr=4