Store data in the same File Excel but different sheet

[livio218526]

Hello to all, I would like to know if there is a way to store data in the same excel file but in different sheets, using the load script.

Thanks,

Livio

[davidfdezcalleja]

Hi,

for example, in this file excel there is two diferent sheets (AirPassangers and Hoja1)

using the load script

I hope it fits you.

[davidfdezcalleja]

Hi,

for example, in this file excel there is two diferent sheets (AirPassangers and Hoja1)

using the load script

I hope it fits you.

[livio218526]

Hello,

I am referring to the store and not to the load

[davidfdezcalleja]

Add these lines in bold

[AirPassengers]:
LOAD
[ID] AS [AirPassengers.ID],
[Date] AS [AirPassengers.Date],
[Year] AS [AirPassengers.Year],
[Month] AS [AirPassengers.Month],
[AirPassengers] AS [AirPassengers.AirPassengers]
FROM [lib://datos/AirPassengers_prueba.xlsx]
(ooxml, embedded labels, table is AirPassengers);

Store * from AirPassengers into 'lib://datos/AirPassengers.qvd';

[Hoja1]:
LOAD
[ID] AS [Hoja1.ID],
[Date] AS [Hoja1.Date],
[Year] AS [Hoja1.Year],
[Month] AS [Hoja1.Month],
[AirPassengers] AS [Hoja1.AirPassengers]
FROM [lib://datos/AirPassengers_prueba.xlsx]
(ooxml, embedded labels, table is Hoja1);

Store * from Hoja1 into 'lib://datos/Hoja1.qvd';

[livio218526]

No, in thisway i stored in two different qvd....

[jonathandienst · Accepted solution]

I don't think that its possible to direct a store to more than on tab in a sheet using the load script alone.  You could write a VBS or VBA macro to consolidate two outputs into a single file after the load is complete, and you may be able to find some code searching here and/or Excel macro coding web sites.

[andoryuu]

Qlik will tell you to get NPrinting.  We have it here (although I can't recommend it) and it is used to generate multi-sheet excel outputs.

[simonaubert]

Hello @livio218526 

You can't as of today.
However, you can promote this idea by voting
https://community.qlik.com/t5/Suggest-an-Idea/QS-Script-store-with-more-format/idi-p/2005668

Best regards