topic Re: Export to xlsx in QlikView

Export to xlsx

Wed, 27 Jul 2011 19:59:13 GMT

Is it possible to export to xlsx instead of xls?

Export to xlsx

rahulgupta — Thu, 28 Jul 2011 07:19:25 GMT

Hey Hi,

You can export to xlsx by using the following code in the Edit Module, using as a button or somewhere else:

sub testxlsx

set obj = ActiveDocument.GetSheetObject("TB01")

obj.Export "E:\Test.xlsx",","

end sub

Hope this helps

Regards

Export to xlsx

Thu, 28 Jul 2011 13:17:43 GMT

Thanks Rahul. Your solution would work pretty good for individual objects, but to go in and do every object for multiple objects, on multiple tabs, on multiple QV files would be time consuming. It's nice however to know it can be done. However I was hoping that one of the versions of QV would be able to export natively without having to recode each object. I'm going to guess the answer is no, QV can only export to .xls at this time. But I could be wrong. I'll wait to see if others chime in but greatly appreciate your answer which will come in handy for specific objects and tables.

Export to xlsx

dkbhatt51 — Fri, 29 Jul 2011 15:19:56 GMT

I just "save the file as" xlsx after exporting it works for me.

Darshan

Export to xlsx

Fri, 13 Apr 2012 21:11:07 GMT

To this end, does anyone know how you can track what data comes out of Qlikview into Excel?

Re: Export to xlsx

Anonymous — Thu, 01 Dec 2016 13:55:17 GMT

Found this old topic. At the end of 2016, is there still no setting in QV to default export objects to .xlsx files?

I'm using QlikView 11.20 SR 15.

Re: Export to xlsx

jamal_mezzourh — Fri, 02 Dec 2016 15:33:21 GMT

Hi Filip,

Unfortunatly no even on the latest version 12.1

have a look at this post Re: Export to xlsx with a button

Re: Export to xlsx

Wed, 07 Dec 2016 18:02:45 GMT

Does anyone know if there is a plan for Qlikview to incorporate this? it would be nice since xlsx format has been around for almost 10 years now.

Re: Export to xlsx

Anonymous — Wed, 07 Dec 2016 18:26:34 GMT

Couln't agree more!