I try to produce as much of the formatting as possible already in Qlikview (I cannot produce a target file as the exported tables vary in size). Even if I change the pivot table style to classic in Qlikview, it does not alter the output.
How can I maintain the border style (or produce a border style) in a macro:
This is what I get:
This is what I would like to get:
I would like to be able to select the area of the table I just put into excel and then make borders.