topic Re: Excel Export - Set tab names in QlikView

Excel Export - Set tab names

Tue, 08 Apr 2014 13:30:17 GMT

I've searched the forum and don't see a similar question posted so far. When I use the 'Send to Excel' function, is there a way to set the name of the tab/worksheet?

Thanks

Re: Excel Export - Set tab names

alexandros17 — Tue, 08 Apr 2014 13:31:31 GMT

No, you can only if you use macro (you can find examples on forum)

Re: Excel Export - Set tab names

Tue, 08 Apr 2014 13:34:07 GMT

OK... could you point me to some of those examples? As I mentioned, I have searched the forum already and wasn't able to find what I was looking for. I see lots of macros for exporting objects to multiple tabs, but nothing for renaming the sheet tab, and I'm not comfortable enough with writing macros to adapt it myself.

Re: Excel Export - Set tab names

alexandros17 — Tue, 08 Apr 2014 13:39:07 GMT

Here it is

common Macro to export excel for 6 different objects

Re: Excel Export - Set tab names

Tue, 08 Apr 2014 16:27:57 GMT

Thanks for pointing me in the right direction. I found this that really helped me understand how the macro code works.

QlikTip #32: Exporting multiple QV objects to a single Excel document

Now I just have to figure out how it gets implemented in the design of the document.