topic Re: NPrint - Excel - Hide Trailing Empty Rows in Qlik NPrinting

NPrint - Excel - Hide Trailing Empty Rows

wonkymeister — Thu, 05 Jan 2017 08:43:10 GMT

Morning

does anyone know if its possible to automatically hide the empty rows in excel when a report is produced by NPrint?

I.e. NPrint may produce a report with 50 rows of data - i'd like to hide all of the remaining rows as they're blank.

is this possible?

cheers,

Phil.

NPrint 16.5

Qlik 11.2 SR12

mkelemen — Thu, 05 Jan 2017 09:36:05 GMT

Hi Phil,

it is possible.

In the template select all rows under your table tag (ctrl+shift+down arrow) and hide them.

Make sure you have the Expand range checkbox set on your table.

Btw. you can hide the columns the same but there is no expanding of columns so you need to leave as many columns visible as you will get.

BR,

Matus

wonkymeister — Thu, 05 Jan 2017 12:50:07 GMT

Thanks Matus, Perfect!