topic Re: Store into excel - multiple sheets in QlikView

Store into excel - multiple sheets

sibrulotte — Thu, 12 Jun 2014 17:39:22 GMT

I have a feeling this will be a categorical NO, but I'll try anyways:

Is there a way to STORE two different tables INTO two different sheets of the same excel file in the script.

I know, txt file, doesn't support multi sheets event with an .xls extension.

But if there's a whizz out there who thinks of something...

Re: Store into excel - multiple sheets

Anonymous — Thu, 12 Jun 2014 17:51:18 GMT

It is not a categorical "NO" - it is "Yes, but..". Possible - but you have to use a macro for this. And macro must have system access. So, in many cases it is practically "no".

Re: Store into excel - multiple sheets

sibrulotte — Thu, 12 Jun 2014 18:13:58 GMT

Thank you Michael.

You wouldn't happen to have an idea on this other thread I started regarding reports:

Reports with objects that have conditionnal show