topic Re: Qlik Excel Add-on in Reporting Service & Alerting

Qlik Excel Add-on

Mlamli — Fri, 15 Nov 2024 20:58:51 GMT

Hi guys,

Has anyone faced the issue of blank lines added to your reports when using the excel reporting feature?

Here are the last 4 lines from my qlik table with no blanks.

This is my template

This is the output with many blanks at the bottom of the table

Please advise how you resolved this.

Frank_S — Fri, 19 Jul 2024 14:39:12 GMT

If you are using an excel table, try using another sheet without inserting a table into the excel spreadsheet.

Then place your tags as needed and preview. (If you have any merged cell, also try without merged cells).

Kind regards..

marksouzacosta — Fri, 19 Jul 2024 17:53:49 GMT

@Camilla84 is this something you can help with?

Camilla84 — Fri, 19 Jul 2024 18:21:45 GMT

Thank you, @marksouzacosta!
@Mlamli can you please run a test trying to uncheck the "Expand Range"? Find below more context about it:

Mlamli — Mon, 22 Jul 2024 08:02:58 GMT

@Camilla84 @marksouzacosta Thank you very much. Unchecking the Expand range fixed my issue.