topic Re: Nprinting: Excel report- Banded columns in Qlik NPrinting

Nprinting: Excel report- Banded columns

sujeet_shirude — Tue, 09 May 2017 22:06:54 GMT

Hi all,

We have a Nprinting 17.3 excel report which pulls data from Qlik Sense 3.2. I am trying to format an Nprinting excel report to have banded columns as attached but it only adds the bands to the first two rows. Is this a known issue? Can we have banded columns in the Nprinting excel report?

Any insights on the same are appreciated.

djk‌

sjw‌

Thank you,

Sujeet Shirude

Re: Nprinting: Excel report- Banded columns

Lech_Miszkiewicz — Wed, 10 May 2017 01:47:40 GMT

Hi,

Solution is simple - See screenshots with numbers and description

When creating an excel template

1 - move your entites to excel
2 - select headers and lines of your table (select table range/area)
3- go to "Insert" and
4 - select Table

this will change the range to the table. Table then can be formated according to all available designs (second screenshot), where you can choose from ready templates or create your own one.

also remember to change "keep the source formatting' in table properties (last screenshot)

hope this helps

cheers

Lech

result

Re: Nprinting: Excel report- Banded columns

mkelemen — Wed, 10 May 2017 10:27:59 GMT

Hi,
step 2 in Lech's instructions creates exactly this problem.
You Need to include one extra line in your table (you can insert the <deleterow> tag if you do not want it at the end).

This way the table grows with the exported data.

Of course the Expand range option needs to be selected.

BR,

Matus

Re: Nprinting: Excel report- Banded columns

sujeet_shirude — Wed, 10 May 2017 14:19:58 GMT

Thank you for the detailed solution, Lech! It worked.

Initially, I tried to select all the rows then selected the table style but did not work.

Now, when I selected the additional two rows, it worked.

Re: Nprinting: Excel report- Banded columns

sujeet_shirude — Wed, 10 May 2017 14:24:30 GMT

Thanks, Matus!

Initially, I tried to select all the rows then selected the table style but did not work.

Now, when I selected the additional two rows, it worked.

Re: Nprinting: Excel report- Banded columns

Lech_Miszkiewicz — Wed, 10 May 2017 22:12:56 GMT

Hi Matus

I am not sure, but i think it depends on version of Excel you are using.

I did not have to use this extra row&deleterow functionality to create a table and get formating done to whole table. I am on MSOffice 2016 and i had to select only headers and row line below and then go INSERT->Table.

I remember from past that sometimes i had to do what you wrote regarding adding one row (for example to provide Grand Total on the bottom of the table)

I am interested to see whether it is office related difference.

thanks

Lech

Re: Nprinting: Excel report- Banded columns

mkelemen — Thu, 11 May 2017 15:38:23 GMT

Hi Lech,

I have excel 2010. I tested it now and it works without the extra row. I just remember that in the past I had these cases and the solution was to add one extra row.

I am not sure if it is NP version dependent - currently I use 16.5 in prod and 17.3.1 in test and it works fine on both.

Matus

Re: Nprinting: Excel report- Banded columns

Lech_Miszkiewicz — Thu, 11 May 2017 22:19:55 GMT

Probably we will never find out - since nobody is on Office 2007 nowadays

On the other hand i think this "extra row" was related to situation where you would skip the INSERT TABLE step in my instruction and would started formatting cells straight away. Then you would need one row bellow to "sort of" format the next row. Maybe i am wrong - cant remember now.

cheers

Lech