Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sujeet_shirude
Contributor

Nprinting: Excel report- Banded columns

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

1 Solution

Accepted Solutions
lech_miszkiewic
Honored Contributor III

Re: Nprinting: Excel report- Banded columns

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

np1.png

np2.png

result

np3.png

np4.png

7 Replies
lech_miszkiewic
Honored Contributor III

Re: Nprinting: Excel report- Banded columns

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

np1.png

np2.png

result

np3.png

np4.png

mkelemen
Contributor III

Re: Nprinting: Excel report- Banded columns

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).

table.JPG

This way the table grows with the exported data.

Of course the Expand range option needs to be selected.

expand.JPG

BR,

  Matus

sujeet_shirude
Contributor

Re: Nprinting: Excel report- Banded columns

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.

sujeet_shirude
Contributor

Re: Nprinting: Excel report- Banded columns

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.

lech_miszkiewic
Honored Contributor III

Re: Nprinting: Excel report- Banded columns

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

mkelemen
Contributor III

Re: Nprinting: Excel report- Banded columns

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

lech_miszkiewic
Honored Contributor III

Re: Nprinting: Excel report- Banded columns

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

Community Browser