# Export to PDF

{% hint style="success" %}
**Who can use this feature?**

The **Export to PDF** function can be used by those with the **Builder** subscription plan.

For more details, see our [**pricing comparison matrix**](https://squirrel365.io/pricing/).
{% endhint %}

The Export to PDF function allows the user to create a hard copy of the data in the spreadsheet of the Squirrel project. This can be used to save data and information that cannot be modified but is still easily shared and printed.

## Export to PDF Properties <a href="#export-to-pdf-properties" id="export-to-pdf-properties"></a>

The properties panel consists of one drawer called Export Configuration.

Within this drawer are various sub-sections:

1. The initial properties for configuring the data in the PDF
2. The **Header** sub-section is used to configure the layout of the PDF header, such as the Title
3. The **Footer** sub-section is used to configure the format of the PDF footer, such as the Page Numbers
4. The **Refresh** sub-section is used to configure at what point the PDF is exported

### INITIAL PROPERTIES <a href="#initial-properties" id="initial-properties"></a>

* **PDF Filename** - This is a simple input box where you can either type in or bind the name of the exported file. Give the file a meaningful name to help identify its contents.
* **Pages for the PDF** - This is a list of the pages seen in the PDF. Each item represents a page with separate data ranges bound to each.
  * *Add* additional pages by clicking the + icon.
  * *Select* the page to be configured by clicking on it in the list.
  * *Delete* pages by selecting the page in the list and clicking the bin icon.
* **Name** - The name of the page (displayed in the list **below**). Give the page a meaningful name to help identify its purpose.
* **Page Data Range** - Bind the range of data in the spreadsheet to determine what data will be displayed on the page selected in the **Pages** list. Do this by selecting the Bind to Cell button at the top-right corner of the input box.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FOgOgRzNohvd67hvN0ZL2%2FExportConfiguration.png?alt=media&#x26;token=453c43ec-8374-45f8-911f-f1d5ebb823a9" alt=""><figcaption></figcaption></figure>

### HEADER <a href="#header" id="header"></a>

* **Title Text** - The title is displayed in the top section of the exported PDF. Give the Header a meaningful name to help identify its purpose.
* **Show Image** - This will determine whether an image is displayed in the header of the PDF.
  * **Import** - *Press* this button to open the Import Image window in the File Explorer. Select the image to be displayed.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FirEMq97aod9mzDixI7eR%2FExportConfiguration_Header.png?alt=media&#x26;token=bb532296-6363-4068-a589-398028a4e8d0" alt=""><figcaption></figcaption></figure>

### FOOTER <a href="#footer" id="footer"></a>

This sub-section will contain 2 options displayed as check-boxes:

* **Show Page Numbers** - This will show what page is being displayed.
* **Show Exported Date** - This will show the date on which the file was exported. This can help determine changes in data over time.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FhcJ0zTGN9DRqvJ8SdIcy%2FExportConfiguration_Footer.png?alt=media&#x26;token=8a1afe69-3f25-4a8e-82f0-ffcfcf0e9386" alt=""><figcaption></figcaption></figure>

### REFRESH <a href="#refresh" id="refresh"></a>

* **Triggered by** - This will be used to determine what causes the export to occur. You have two options displayed as radio buttons:
  * **Cell Change** - *Select* this option to have the function trigger when a cell in the spreadsheet is changed from its original value
  * **Cell Equals** - *Select* this option to have the function trigger when a cell in the spreadsheet is changed to meet a specific requirement.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FEFtBnTyGCHU8nmUM7cLP%2FExportConfiguration_Refresh.png?alt=media&#x26;token=3fc736c3-5003-4718-935e-d315daba8674" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Note that the requirement of the cell change/equals can be in any format e.g. Value, Text, Boolean, etc.
{% endhint %}

{% hint style="info" %}
NB: Export to PDF cannot be successfully tested in design, debug, or preview as this will result in the exported file having no format. A project must be published before it can be exported with a default file format.
{% endhint %}