Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Normally in Nprint excel reports, we normally choose expand option , how can we remove the last row while maintaining the format of the existing template
you mean grand total?
if not please share the screen shot
Best
Chanty
Hi Chanty,
What I want is to insert the column data from Nprint to an excel template. I want to use the template format(e,g border) and I want no more blank row after the last row information from the Qlik. Can I achieve that? I know I can do that by having an empty row to maintain the template format
Hi Ronald,
you can delete row by dragging the <deleterow> into some cell in that row.
BR,
Matus
Hi Matus,
Yes, but deleting row I can remove the blank rows, but will also delete the format (border) of the last row, which is what I want to maintain. is there a work-around to this so that I can delete the last row but keeping the format of the last row.
why dont you create an Excel table? as in excel select a range with your headers and nodes and then Insert -> Table - then you can format whole table the way you like and deleting last row will not affect it
cheers
Lech
Hi Lech,
That is because I am using an existing template and using Nprint just to export the data to the template. it is easier this way so that I don't have to format the whole table from beginning again. I have tried to export the data as a whole excel table to the template but it did not work.
How many columns this table has? It is not as difficult task to format a table in Excel as you already have nodes in it and it just requires converting a range to table in excel and applying your format to table (borders and colors)
thanks, I may give it a try, I got about 30 columns