Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create an automation that more or less exports the sheet to excel. For example, when you right-click on a report/sheet and select download, select data and then download. So far with the help of MattGrayndler automation I have managed to create an automation that sends an email with a link to an excel file in sharepoint. The dilemma I have is that the formatting and color codes that are implemented to sheet have not been included to the exported excelfile. Does it mean that I need to include all ObjectsID in the automation or could it be due to something else entirely?
Thanks in advance
Kind regards
Abdirahman Yasin
Are you interested to get reports of the sheet in PDF or PowerPoint format or only Get Straight Table Data in excel format via QAA?
The PDF / PowerPoint report can be generated using Qlik Reporting Connector
We have a few templates already available in the template picker which helps to generate the report
You can find it by navigating to Add new -> New automation -> Categories(left panel) -> click on Reporting.
Select any of these templates depending on your use case and click on the Use template option in order to use it in the automation
Please let me know if I misunderstood your question
Thanks!
Hi @AfeefaTk
Thank for responding
Not quite what I'm looking for 🙂
I'm looking for automation where the out format is an Excel file containing the formatting and colour coding that is implemented on the sheet. Colour coding and formatting are correctly included when I
right-click on the sheet -> press download - > Select Data -> Click Download. That's the result I want the automation to put out.
Kind regards
Abdi
I don't think it is currently possible to create excel reports from the sheet. The approach you have tried will allow you to create excel reports out of straight table data.
We have plan to add excel feature to reporting connector, but no ETA yet
I would suggest you create feature request in the Ideation forum
Meanwhile, could you mind showing me how the excel report looks while downloading from the Qlik Sense app? Maybe a screenshot of the sheet in Qlik Sense and excel file downloaded from the sheet.
Thanks