2 Replies Latest reply: Jan 28, 2016 8:25 AM by Colin Albert RSS

    Conditionally hide columns in NPrinting Excel Template

    Colin Albert

      Is there a way to conditionally hide columns in an NPrinting Excel Template?

       

      I know that the columns can be conditionally hidden in the source QlikView chart, but I need to control the final columns headings in Excel so this is not an option.

       

      All references I can find to conditionally hiding columns in Excel require macros.

      I have tried using a .xlsm template with the macro but the macro does not appear to be passed through to the output spreadsheet.

       

      Any suggestions how this can be done in NPrinting?