topic Re : Export Pivot Table Data to XLS in QlikView

Re : Export Pivot Table Data to XLS

sona_sa — Fri, 15 Nov 2024 23:14:42 GMT

I have two pivot table.

I am able to export data in xls, but in different xls. But I want both pivot table data should to go in single xls but in different - different sheet. One Pivot Table Data in Sheet1 and another Pivot Table Data in Sheet2. Below is my code. Working properly. I want one excel file in sheet 1 and sheet 2 instead of two excel file.

Sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")
set obj = ActiveDocument.GetSheetObject("CH03")
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH01.xls"
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH03.xls"

End sub

Please look into it and let me know any idea. Thanks in advance.

Regards

Re: Re : Export Pivot Table Data to XLS

sona_sa — Thu, 28 Jan 2021 07:16:04 GMT

Can anyone help me on this ?

I have two pivot table.

Sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")
set obj = ActiveDocument.GetSheetObject("CH03")
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH01.xls"
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH03.xls"

End sub

Please look into it and let me know any idea. Thanks in advance.

Regards