3 Replies Latest reply: Dec 20, 2017 11:47 AM by Alex Xie RSS

    How to hide empty columns for NPrinting

    Alex Xie

      Currently, I have a excel report get data from QV dashboard's straight table. but this table will show the data based on fiscal year till now.

       

       

      e.g. current month is Jun 2017, and then Jul 2017 columns is empty.

       

      Apr 2017
      May 2017Jun 2017Jul 2017...
      112233
      112233
      112233

       

       

      We have use excel macro script to hide the empty columns when this Excel workbook open. But now we want to send this report as PDF format to user. It will show the empty column Jul 2017 and others always. The problem is how to hide the empty columns when convert the excel report into PDF format? Thanks