topic Re: Excel formatting in NPrinting. in Qlik NPrinting

Excel formatting in NPrinting.

renuka_sasikumar — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

I have a Excel report as below

1. I want to show header as Equity in a merge cell same like for Commodity & Currency which showing in each cell.

2. There are some value which is showing in left align of cell as a text in comment even though in Chat Properties-presentation-align I have checked for right (both in Data & Numeric).

Can anyone please help to resolve this as I have tried check in Keep as Source format in chat properties in NPrinting. Still it is not working.

Thanks & Regards,

Renuka S

Re: Excel formatting in NPrinting.

avinashelite — Fri, 16 Oct 2015 06:15:05 GMT

you can merge cell in the NPrinting , you need to prepare your chart in the Qlikview and then you the same in the NPrinting .

To achieve the above representation , follow this document

multi_header_pivot_import.qvw

and use the same chart in the NPrinting

Re: Excel formatting in NPrinting.

renuka_sasikumar — Fri, 16 Oct 2015 06:19:54 GMT

Hi,

See the images which I have in Qlkiview, which gets changed to the previous image when I export mail from NPrinting.

Thanks & Regards,

Renuka S

Re: Excel formatting in NPrinting.

avinashelite — Fri, 16 Oct 2015 06:23:45 GMT

you have done to dynamically right ?? that is the data is like that? if that is the case than NPrinting will not alter that representation. Check in Qlikview how your merging the cell ? if they are using any text object on top of that then it will not have any effect in the NPrinting

Re: Excel formatting in NPrinting.

renuka_sasikumar — Fri, 16 Oct 2015 06:45:36 GMT

Hi,

Its a Dimension which I have used in QlikView.

Re: Excel formatting in NPrinting.

avinashelite — Fri, 16 Oct 2015 06:49:16 GMT

Ok wait let me try

Re: Excel formatting in NPrinting.

avinashelite — Fri, 16 Oct 2015 07:01:07 GMT

It seem like a limitation in NPrinting, if you have limited let of data you can try like this , copy the object as a clipboard object or you need to create a manual Pivot table . Check this

//community.vizubi.com/knowledgebase/articles/261211-how-to-create-a-pivot-table-from-excel-table-colum

Re: Excel formatting in NPrinting.

Fri, 16 Oct 2015 12:11:02 GMT

How are you bringing this chart into NPrinting? as an image or as a table.

If you bring it in as an iamge, there is not much you can do in Nprinting - all formatting needs to be done in QlikView

If you bring the object in as a table, then you can move either the entire table as a whole, or column by column, which will allow you to format each cell/column in excel

see attached for reference and further detail

Can I apply Excel formatting to my Excel reports? – Customer Feedback for Vizubi

How to Create Excel Reports – Customer Feedback for Vizubi

NPrinting Features for Creating Excel Reports – Customer Feedback for Vizubi

You can also go to the main NPrinting community, Customer Feedback for Vizubi, and search on Excel for additional articles and pointers

Re: Excel formatting in NPrinting.

renuka_sasikumar — Thu, 03 Mar 2016 05:52:33 GMT

Hi,

I am bringing this as an Table not image.

Anyway for the Merging cell its not possible. For that we need to create Pivot Table in the Excel. So I am going with the same.

But for the 2 point i.e

2. There are some value which is showing in left align of cell as a text in comment even though in Chat Properties-presentation-align I have checked for right (both in Data & Numeric).

I have got the solution and it is in QVW

HELP---About QlikView---Right Click the Qlikview icon which is in down left corner, you get a pop up in that select

ExcelExportMixedAsText mention 0 and then click on Set ---- Save Next Script on Load.

then you will get it.

Regards,

Renuka S

Re: Excel formatting in NPrinting.

Fri, 27 May 2016 09:52:57 GMT

Hi,

For 2, is there anyway the set all the cells as text? Since I have format the cells in qvw expressins, if set ExcelExportMixedAsText to 0 will lost all the format in excel. If set it to 1, some sell will show as text,but some cells still number. It's really pain.