You enable the print functionality for your app by selecting the worksheet with the printing area from your Excel file. This way you can generate a PDF within your app and send it via email.
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 the print functionality in your app, please proceed as follows:
- Open your app in the web portal.
- Navigate to "Edit".
- Select "Print functionality
- Select the print sheet.
- Save the changes and update your app.
Attached please find a sample file in which the worksheet "angebot" is used as print sheet for the app.
Please be advised that charts will not be visible in the PDF, especially if your source file is an .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".