topic Re: Create XLS in Automation in Qlik Automate

Create XLS in Automation

xyz_1011 — Tue, 16 Dec 2025 15:21:01 GMT

Hi all,

i need to deliver an XLS, which contains a simple pivot table automatically to a dedicated recipient. The pivot table exists an app. We do not have the XLS plug in to connect directly from QExcel to Qlik Sense, hence my idea was to create an automation, which gets the pivot table's data and puts it in a spreadsheet, then save the spreadsheet and send it by email to the recipient. How would i do this using an automaion ?

Thanks in advance for some advise!

Re: Create XLS in Automation

kfoudhaily — Tue, 27 Jan 2026 18:21:19 GMT

Hello,
Don’t stream directly into Qlik.
Qlik is very fast for analytics, but it’s not designed to ingest raw IoT events continuously.

Best approach:

Sensors (ESP32, Arduino, Raspberry Pi) send data via HTTP or MQTT
A small ingestion layer (Node-RED, lightweight API, etc.) receives it
Data is stored in a database or time-series store (Postgres, SQL Server, InfluxDB)
Qlik reads from that store in a controlled way
This keeps dashboards fresh without overloading the Qlik engine.

Now how to keep dashboards “near real time”
Use Incremental reloads (most common)

Qlik reloads only new rows every few minutes
Data is stored in QVDs
Very stable, cheap in resources
Perfect if 1–5 minutes latency is acceptable
This is the default choice for most IoT dashboards.
regards,

Re: Create XLS in Automation

chriscammers — Tue, 27 Jan 2026 18:52:49 GMT

First of all don't over complicate things, contact your Office 365 administrator and your Qlik Administrator and look into getting the Excel plugin, you have to configure some things in Qlik Cloud and then add the manifest to Office. A report built with the Excel plugin should do exactly what you are proposing without having to learn the intricacies of the Excel API.

It sounds to me like you don't have much experience with automations so start by just writing the output from the chart to the output window, this will give you an idea of how the qlik api works.

There are some templates that write data to Excel, bring those into your personal space and see if you can make them work. once working modify them to see what you can do.