Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Excel Export Pivot Table with formatting( unmerged fields)

Whenever I export a pivot table to excel - It exports the excel with cells - unmerged . I want to export it with the exact formatting . Any solutions or workarounds ?

4 Replies
Not applicable

Re: Excel Export Pivot Table with formatting( unmerged fields)

Natively I don't think so sorry, the closest you will get is the print option on a chart when using the Ajax client which opens you a html page with the formatting retained.

Third party options such as Nprinting might allow you to do this though, so maybe have a look at that

hope that helps

Joe

sandeepprasad_j
Contributor

Re: Excel Export Pivot Table with formatting( unmerged fields)

Hello Litan,

Write a macro like below

set obj = ActiveDocument.GetSheetObject("CH15")

obj.ExportEx "C:\Documents\test.xls"


or


Try to Click on the Pivot Table in the Qvw Application CTRL+A,CTRL+C and then open the new excel worksheet and CTRL+V ,you will get the desired output


Hope it helps

Sandeep.

Not applicable

Re: Excel Export Pivot Table with formatting( unmerged fields)

Hi.

I'm having the same issue. did you find a solution?

thanks

Re: Excel Export Pivot Table with formatting( unmerged fields)

You could choose copy into clipboard from context-menu and then the complete table.

- Marcus

Community Browser