topic Re: Nprinting Excel Header in Qlik NPrinting

Nprinting Excel Header

sijojoseph22 — Tue, 03 Mar 2015 16:39:23 GMT

Hi All,

We need to add a date in the format in '03 March 2015' in excel header. Please could you advise if this is possible using Nprinting.

Thanks,

Sijo

Re: Nprinting Excel Header

JonnyPoole — Tue, 03 Mar 2015 17:03:15 GMT

Can you explain a bit more ? In NPRINTING you can design a report in the 'excel template' (use MS Excel to design the report) or when you design a report using the different editors , you can run the report to generate an excel output ?

If you need to run the report to generate an excel output, it probably makes sense to design the report in the excel template and you use the excel native formatting options to create the header. Here is a sample of a repeating header from the nprinting knowledge base.

How to Create One or More Levels in Excel Reports – Customer Feedback for Vizubi

Also, if you use the 'pixel perfect' editor you can drag and drop text, data, charts directly into the 'header', 'body' , or 'footer' area of a report . Whether or not you run the report as an excel output or other output (PDF) is separate to the template editor you choose to create the report in.

Re: Nprinting Excel Header

Bharat_Ahuja — Fri, 07 Aug 2015 03:04:47 GMT

Create a variable in QlikView and use that variable in NPrinting Excel Template.

You can use the following formula: =Date(max(Date),'DD MMMM YYYY')

Re: Nprinting Excel Header

Frank_S — Mon, 10 Aug 2015 22:56:19 GMT

NPrinting Tags or not currently supported in MS Office excel, word, pptx headers and footers.

Allow NPrinting tags to work inside MS Office Word and Excel Headers and Footers. – Customer Feedback for Vizubi

Re: Nprinting Excel Header

Tue, 11 Aug 2015 14:43:41 GMT

You can use the native Excel functionality to add the date into the header. The date format can be set to various types; some of this will depend on the date settings of the local machine of the person who opens the Excel file.

As Frank noted, it's not possible to put QlikView variables, formulas or fields into Excel Headers or Footers in NPrinting.