topic export Pivot table in biff format in QlikView

export Pivot table in biff format

rohit214 — Fri, 22 Jun 2012 04:12:27 GMT

Hi alll,

I am using QV9 sr7 when i am exporting pivot table through macro (on reload) so its comes in ooxml format

i want exported file should be in biff format.

Thanks&regards

rohit

rohit214 — Fri, 22 Jun 2012 06:10:28 GMT

any one.....

Jason_Michaelides — Fri, 22 Jun 2012 06:13:37 GMT

Check the export section of user preferences.

rohit214 — Fri, 22 Jun 2012 06:26:05 GMT

hi jason,

i alredy checked that option here i attached the screen shot please find the attachment an dguide me

thanks&regards

rohit

Jason_Michaelides — Fri, 22 Jun 2012 06:31:12 GMT

Can you please post your app.

rohit214 — Fri, 22 Jun 2012 06:41:41 GMT

in my appication i am exporting pivot table into excel its working fine but it changes the format

from biff to ooxml if i am exporting pivot table manually at that time the format is biff only

please find the attachment

Thanks&regrads

rohit

rohit214 — Fri, 22 Jun 2012 07:07:09 GMT

any other option....

Jason_Michaelides — Fri, 22 Jun 2012 07:13:14 GMT

Sorry - I'm not really sure about this. I have previously used

	set obj = ActiveDocument.GetSheetObject("CH01")
	vFilename = "C:\MyFile_" & getVariable("FileName") & ".xls"
	obj.ExportBiff vFilename

for exporting to Excel in a macro.

rohit214 — Fri, 22 Jun 2012 10:18:59 GMT

its not working

thanks

rohit