Top
English (US) Deutsch

Articles in this section

See more

Generate PDF files in the app | Activate print function

Avatar
Damian Roller
Updated
Follow

By selecting the worksheet with the print area you activate the print function for your app. This enables you to save the content of your calculation as a PDF file and send it by email.

Activate "print as PDF" functionality

First, make sure your source Excel file contains a worksheet that contains the relevant info for your print data. For more information about how to define print areas, please visit the article "Set or clear a print area on a worksheet".

If you want the printout to be in landscape orientation, change the page orientation in your source file. (See: "Print a Worksheet in Landscape or Portrait")

To enable the print functionality in your app, please proceed as follows:

  1. Open your app in the web portal.
  2. Navigate to "Edit".
  3. Select "Print functionality
  4. Select the print sheet.
  5. Save the changes and update your app.

Attached please find a sample file in which the worksheet "angebot" is used as a print sheet for the app.

Please be advised that charts will not be visible in the PDF, especially if your source file is a .xlsx file. Sometimes charts are printed if you save your file as .xls and use this version as source file for your app. In this article, you can find out how to switch/update the source file of your app: https://support.openasapp.net/hc/en-us/articles/207939275

You can find a step by step guide on how to build an app with print functionality here: "Create a license calculator with print functionality".

Add "print as PDF" action button with additional options

It is possible to print different sheets from Excel, depending on which action button the user clicks.

To add a "PDF Print" button to your app, do the following:

  1. Open your app in the web portal.
  2. Navigate to the Pages & Elements view in the left menu.
  3. Click on the "+" icon on the right.
  4. Grab the box "Action Button".
  5. Place the button at the desired location of your app.
  6. Open the editor for this item by clicking on the gear icon.
  7. Enter a caption for this element in the "Main" tab of the editor. This text will be displayed in the action button.
  8. In the "Action" drop-down, select the "Print" function.
  9. Specify which worksheet's print area should be turned into a PDF when the button is pressed:
    1. (1) by selecting the print sheet
    2. (2) by defining the cell in your spreadsheet that contains the sheet name of the range you want to printmceclip0.png
  10. Save your changes.
  11. Update your app.

The hierarchy for the print area is structured as follows: 1. print area from a cell -> 2. print area selected in the drop down -> 3. print area set in the global print setting

Now you have a button in the app which generates the PDF file immediately after clicking on it.

Related articles

Comments

2 comments

Sort by Date Votes
  • Avatar
    MUHAMMAD ALI

    Hi Damian, thanks for your help article.

    I recently had some problems with the printsheet function.  I could not get it work.

    Then I realized that when I made the page names in the App, some of the page names I made were different from the spreadsheet names

     
    so for example.  I called one page 'Dash Chart' and in the printsheet, I wrote printsheet=Dash Chart.   However, the spreadsheet actual page was a different name.  it was called Dashboard (2)
     
    so what I did, I fixed all the pages and then the printing works just fine.
     
    So Just to remind people that when you use the printsheet function it must be the same as the spreadsheet and not the App page.
     
    Thanks Muhammad.
     
    0
    Comment actions Permalink
  • Avatar
    Jignesh patel

    Hi,

    I Need to define two different sheets as print in two pages in same app have provided print buttons on both pages, Have tried changing xml but not done.

    Please help.

    0
    Comment actions Permalink

Please sign in to leave a comment.