topic Re: macro pivot to excel with format as biff in QlikView

macro pivot to excel with format as biff

warfollowmy_ver — Thu, 29 Dec 2016 06:54:45 GMT

Hi all!

How do it? Creating excel file through macro from pivot with format as biff.

Re: macro pivot to excel with format as biff

tamilarasu — Thu, 29 Dec 2016 07:01:15 GMT

Could you post a sample application?

Re: macro pivot to excel with format as biff

warfollowmy_ver — Thu, 29 Dec 2016 07:10:48 GMT

I have two pivot tables.

It is necessary to insert them into Excel sheet and a lower second.

I put the first pivot through macro, define the number of lines in the first pivot and following in Excel file into a second table under the first table. But the format needs a biff.

That is a normal export will not do.

Re: macro pivot to excel with format as biff

tamilarasu — Thu, 29 Dec 2016 07:18:23 GMT

Fine. Could you post a sample file with what you have done (Macro) so far. It will be easy for me to help you further.

Re: macro pivot to excel with format as biff

warfollowmy_ver — Thu, 29 Dec 2016 07:37:16 GMT

Ready. Reworked to not shine data...

Re: macro pivot to excel with format as biff

Anonymous — Thu, 29 Dec 2016 08:04:22 GMT

Hi,

I've searched on Macro tutorial

sub Export()

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\Qlikview\test.xls"

end sub

Best regards,

Cosmina

Re: macro pivot to excel with format as biff

tamilarasu — Thu, 29 Dec 2016 09:25:38 GMT

Kindly check the attached file and let me know If any issues.