0

Is there any way to use URL parameters to horizontally/vertically align a sheet when exporting it to a PDF? Something like:

https://docs.google.com/spreadsheets/d/1oAvIn28488l95xiMZPt_dLJebcT3jqoaQZ9axdIpDGw/export?exportFormat=pdf&format=pdf&gid=582165762&horizontalAlignment=center

I've tried several variations of this but nothing has worked so far.

Lauren
  • 371
  • 2
  • 19
  • What does that even mean? You can set the alignment of rows & columns with Apps Script prior to exporting (be sure to flush after altering). – tehhowch Sep 17 '18 at 17:15
  • @tehhowch I mean the way the sheet displays as a PDF when it's exported. The sheet is always aligned to the left of the paper. – Lauren Sep 17 '18 at 17:21

1 Answers1

3

Ended up finding the answer here. The parameter I was looking for was &horizontal_alignment=CENTER.

Lauren
  • 371
  • 2
  • 19