Qlik Excel Add-on

[Mlamli]

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]

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]

@Camilla84 is this something you can help with?

[Camilla84 · Accepted solution]

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

If you want more information about formatting Tabular Report, please visit: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-t... 

[Mlamli]

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