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

Excel Export Pivot Table with formatting( unmerged fields)

Thu, 29 Jan 2015 08:42:55 GMT

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 ?

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

Thu, 29 Jan 2015 08:54:46 GMT

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

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

sandeepprasad_j — Thu, 29 Jan 2015 10:13:13 GMT

Hello Litan,

Write a macro like below

set obj = ActiveDocument.GetSheetObject("CH15")

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

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.

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

Tue, 17 Feb 2015 10:00:40 GMT

Hi.

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

thanks

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

marcus_sommer — Tue, 17 Feb 2015 11:09:28 GMT

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

- Marcus

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

MEJ — Tue, 21 May 2019 13:41:08 GMT

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.