So far we've learned how to create a URL to export your Google Sheets spreadsheet. Portrait=false: Sets the orientation to landscape (setting portrait=true will result in portrait orientation) In the above URL, we're using four parameters:įormat=pdf: Set the exported file format to PDF For example, suppose you want to export your spreadsheet as a PDF file in landscape orientation, without gridlines, using the B5 page size, your URL will look like this: You can use one or more of these parameters to ensure the exported file meets your requirements. This tutorial will cover a number of parameters that you can use to customize the exported file. Also, note that there is an ampersand ( &) separating each parameter. Please note that there is a question mark ( ?) in the URL right before the parameters are specified. The parameter format is assigned the value pdf and the parameter portrait is assigned the value false. In the URL below, you have two parameters: format and orientation. The URL of that spreadsheet will look something like: How to export a Google Sheets spreadsheet into other file formats?īefore jumping into details, let me explain the high-level approach that we'll use to convert Google Sheets to other file formats. If you are new to coding or if you're not familiar with Apps Script, please consider reading my tutorial series on learning to code using Google Sheets and Apps Script. This tutorial assumes that you're familiar with Google Sheets and Apps Script. Please note that most of these custom settings will only apply to PDF exports. In addition, you'll learn how to customize the exported file. This tutorial is for you if you've ever wanted to use Apps Script to automatically convert a Google Sheets spreadsheet to: In this tutorial, I will show you how to export a Google Sheets spreadsheet into other file formats using Apps Script. Comprehensive guide □: Export Google Sheets as PDF, Excel, CSV, or other formats using Apps Script
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |