topic Re: Create an Excel with multiple tabs in QlikView

Create an Excel with multiple tabs

kris_vliegen — Sat, 16 Nov 2024 20:03:44 GMT

Hi All,

We've a customer with fuelstations. Now he want's that Qliview (version 11 or 12) creates an Excel with the data of the payementtype(Columns) by month (row).

And every tab should have the data of 1 station.

Tab1 -> data of station 1, tab 2 -> data of station 2, ...

Is this possible via Qlikview?

Regards,

Kris

Re: Create an Excel with multiple tabs

lironbaram — Wed, 18 Sep 2019 10:13:15 GMT

Qlik nprinting will do this easily for you

you should check this out

https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/Introduction/Introduction.htm

Re: Create an Excel with multiple tabs

avinashelite — Wed, 18 Sep 2019 10:22:31 GMT

Using Qlikview load script its not possible , only way using Qlikview is you need to use macros .

Check this link

https://community.qlik.com/t5/Qlik-Sense-App-Development/Storing-Data-into-Multiple-Tabs-in-an-Excel-CSV-file/td-p/116366

Re: Create an Excel with multiple tabs

Frank_Hartmann — Wed, 18 Sep 2019 11:06:07 GMT

have alook at the attached qvw

hope this helps

Re: Create an Excel with multiple tabs

kris_vliegen — Wed, 18 Sep 2019 11:06:43 GMT

Hi,

I found a macro that create's an excel with multiple tabs.

But it dosn't work on my access-point. Only in my desktop version.

Re: Create an Excel with multiple tabs

kris_vliegen — Wed, 18 Sep 2019 11:22:21 GMT

Hi Frank,

Tnaks for this QVW. This is working in my deskotop but not in the accesspoint...

Regards,

Kris

Re: Create an Excel with multiple tabs

Brett_Bleess — Mon, 30 Sep 2019 15:41:12 GMT

Kris, this is by design most likely given how you are attempting to run things. You will have to use QV.exe /r option and run via External Task in Pulisher...

See the following Article for further help:

Publisher and Actions/Macros

Regards,
Brett