Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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 ?

5 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

MVP & Luminary
MVP & Luminary

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

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

- Marcus

Mathias_Johnson
New Contributor

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

If I use the copy to clipboard, it works with the merged dimensions, but NOT the number formats (thousands). So by sending to Excel it works well in one way (number formats), but not the merged dimensions.