Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When migrating from NPrinting to Qlik Cloud, existing Excel report templates can be reused with the Tabular Report feature through the Qlik Add-in for Microsoft Excel. This article walks through the correct steps to adapt and connect an NPrinting Excel template to a Qlik Cloud app when you don’t have access to the “Export Qlik Cloud Reports” option in Nprinting.
Prerequisites- The Qlik Add-in for Microsoft Excel installed via Microsoft AppSource or your organization’s Office Add-ins manifest. If you need assistance on how to install the Add-in, check this page: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Install/report....
- Access to a Qlik Cloud tenant with at least one published app containing the data you want to report on.
- Export template permission in Nprinting.
The template can be downloaded directly from the Reports section in NPrinting. Use the Export > Download option. You may optionally set a password for the exported file if required by your organization.
Once downloaded, unzip the file and save the template to a location that is easy to find and access later.
Step 2 — Ensure the Qlik Add-in is Installed and Connect to Your AppMake sure the Qlik Add-in is already installed in the version of Microsoft Excel you intend to use.
When you open the template, you will see the field names as they were defined in the NPrinting Designer Console.
Using the Add-in panel, connect to the appropriate Space and App that correspond to this report.
Step 3 — Locate the Chart Sources in Your Qlik Cloud App
Open your Qlik Cloud app and identify the chart objects that contain the fields used in the report template. For each relevant object, note:
- The Sheet where the chart is located.
- The Object ID of the chart.
To find it, you can right click in the table/Chart > Share > Embed:
In the next window, you will see info about this chart, including the Object ID:
You will need the Object ID in the next step to match the correct table in the Add-in console.
Step 4 — Add the Table to the Add-in Console (Without Inserting Fields)
In the Qlik Add-in console, locate the table or chart that matches the Object ID identified in Step 3.
Add this table or chart to the console.
Important: Do not insert any fields from the console into the template. Since the field names are already present in the template (from the original NPrinting layout), the table only needs to be added to the console to establish the field mapping. The Add-in will use the existing field references in the template cells automatically, as long as the corresponding table is active in the console.
Step 5 — Preview and Validate the ReportRun a preview from the Qlik Add-in panel to check that all fields are returning data correctly. Verify that each mapped cell is populated as expected and refine the formatting if necessary before distributing or scheduling the report.
Additional Notes- Formatting, styling, and layout from the original NPrinting template (colors, fonts, borders) are preserved and do not need to be recreated.
- If a field shows no data during preview, double-check that the field name in the template cell exactly matches the field name in the Qlik Cloud app — including capitalization and spacing. Even a minor mismatch will result in blank output.
- If your Qlik Cloud app uses master measures or calculated dimensions, make sure those are exposed as fields or that the chart object added to the console includes them. The Add-in can only resolve references to fields that are part of the loaded object.
- If the NPrinting template used variables or expressions directly in cells (rather than field references), those will need to be reviewed manually — the Add-in does not support NPrinting-style expression syntax and may require adjustments in the template or in the app’s load script.
