0

I have a sheet that I would like to be able to export into multiple PDFS - each one containing the first frozen column A and the next column of respective data, eg. A1:A31;B1:B31, A1:A31;C1:C31, etc.

I found this answer to a similar question asked previously and I'm able to use the method to export a single range (A1:A31, A1:B31, etc) very easily, but I can't figure out how to add two separate ranges to the URL.

I've tried https://docs.google.com/spreadsheets/d/{spreadsheet_id}/export?exportFormat=pdf&format=pdf&gridlines=false&size=A4&gid={gid_id}&range=**A1:A31;C1:C31**, as well as replacing the ; with + and &, but can't get it exporting correctly.

Can anyone help me out, or maybe even suggest a simple script I could use? Thank you!

Tom Gallagher
  • 1
  • Hi there! You can easily reach this goal by using [Apps Script](https://developers.google.com/apps-script) to programatically create an additional sheet with the required columns and then export it to PDF. Would that be a valid solution for you? – Jacques-Guzel Heron Jul 22 '21 at 08:00

0 Answers0