Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report

Full Excel Table Compatibility in NPrinting Release 12.3 and Later

Support
Support

Full Excel Table Compatibility in NPrinting Release 12.3 and Later

QlikView objects can now populate Excel tables, so you can use Excel table functions. You can create Excel tables with all the unformatted QlikView data or inject only selected columns. Both will be illustrated in this tutorial. Though all four columns will be embedded in our second Excel table, a table with fewer columns could be created and the selected columns embedded in any order. Here is how to do it.

    
    
        
          

Create New Excel Report and Template

                    
         Create-New-Excel-Report-and-Template.png                       
          

See: NPrinting Features for Creating Excel Reports if you need help with basic Excel report creation procedures.

        
        
        
          

Save Template in .xlsx Format

                    
       Save-Template-in-xlsx-Format.png                         
          
  1. Change Save as type: to Excel Workbook (*.xlsx) because the older Excel 97-2003 Workbook (*.xls) type is not compatible with the present feature. NPrinting 14.1 and later releases automatically pre-select the latest format featured by the Microsoft Office installation that you have for saving each document type.
  2. Click on the Save button
        
        
        
          

Add Chart as Table and Adjust Properties

                    
         Add-Chart-as-Table-and-Adjust-Properties.png                       
          
  1. Add CH184 - Top 25 Products to the template
  2. Uncheck the Keep Source Formats
  3. Set Show Headers to Show above tag cell
        
        
        
          

Embed QlikView Table in Template

                    
          Embed-QlikView-Table-in-Template.png                      
          

Drag and drop the CH184 - Top 25 Products token onto the second cell of Column B.

        
        
        
          

Insert Excel Table

                    
         Insert-Excel-Table.png                       
          
  1. Select a cell containing the CH184 tag if it si not already selected
  2. Click on the Toolbar icon in the View group if the Excel tool bar is not already open
  3. Select the Insert tab in the Excel tool bar
  4. Click on the Table icon in the Tables group
        
        
        
          

Apply Excel Formatting

                    
        Apply-Excel-Formatting.png                        
          

Column Widths can be set independently.

        
        
        
          

Apply Table Styles

                    
           Apply-Table-Styles.png                     
          

Apply Table Styles from the Design tab of Table Tools in the Excel tool bar.

        
        
        
          

Apply Font and Alignment Formatting

                    
         Apply-Font-and-Alignment-Formatting.png                       
          
  • Font and Alignment formatting applied from the Excel tool bar to the Heading cell will be applied to all table cells in the heading row.
  • Font and Alignment formatting applied from the Excel tool bar to the Content cell will be applied to all table cells in the content rows.
  • Number formatting will have no effect.
        
        
        
          

Preview Report

                    
          Preview-Report.png                      
          

Click on the Preview icon in the Actions group

        
        
        
          

Inspect Table

                    
         Inspect-Table.png                       
        
        
        
          

Add CH184 - Top 25 Products to Template Again and Alter Properties

                    
          Add-CH184---Top-25-Products-to-Template-Again-and-.png                      
          
  1. Add CH184 - Top 25 Products to the template again resulting in the CH184_1 - Top 25 Products node
  2. Uncheck the Keep Source Formats
  3. Set Show Headers to Hide
        
        
        
          

Embed Columns in Template

                    
         Embed-Columns-in-Template.png                       
          

Expand the CH184_1 - Top 25 Products node and embed the columns one by one in the template by dragging them and dropping them onto empty cells.

        
        
        
          

Create Four Column Table

                    
          Create-Four-Column-Table.png                      
          
  1. Select four horizontally contiguous cells
  2. Click n the Table icon in the Tables group to open the Create Table dialog
  3. Click on the OK button
        
        
        
          

Apply Excel Formatting Tools

                    
          Apply-Excel-Formatting-Tools.png                      
          
  • Font, Alignment, and Number formatting can be applied from the Excel tool bar to the Heading cell independently by column.
  • Font, Alignment, and Number formatting applied from the Excel tool bar to the Content cell in the template will be applied to all Content cells in the respective column independently by column.
        
        
        
          

View Excel Table

                    
           View-Excel-Table.png                     
          

Jubilate at the variety.

        
        
    
  
Version history
Revision #:
1 of 1
Last update:
‎2015-11-25 09:34 AM
Updated by: