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