topic Re: Export to Excel in QlikView

Export to Excel

Wed, 24 Apr 2013 16:18:57 GMT

Hi,

I would like to know if there is any way to export many table object simultaneously into a single Excel file.

Thank you for your time

Ryu,

Re: Export to Excel

Anonymous — Wed, 24 Apr 2013 16:30:04 GMT

Ryu,

It can be done with a macro - export one table to Sheet1, another to Sheet2, etc.

Regards,

Michael

Re: Export to Excel

Gysbert_Wassenaar — Wed, 24 Apr 2013 16:46:22 GMT

It's possible. See here for a solution.

Re: Export to Excel

Wed, 24 Apr 2013 19:06:03 GMT

Thanks, that's what I thought

Re: Export to Excel

Wed, 24 Apr 2013 19:37:06 GMT

Thank you very much, that was exactly what I was looking for.

Re: Export to Excel

rsdhavle — Tue, 07 Jan 2014 07:28:55 GMT

Hi Gysbert,

Thanks for the link and we could create a Export to excel feature. Few questions:

1) At access point suppose user click on the button(containing vbscript) will the excel be generated without any issue on users machine Or there are any limitations to this export to excel feature by using VBscripts?

2) If there are any limitations how to overcome those so that export to excel feature works smoothly on any local machine through access point

Re: Export to Excel

Wed, 08 Jan 2014 10:05:26 GMT

I am Getting the type mismatch error for this line 'Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)".

Could you please let me know.

And one more thing I want to extract to the same sheet in the work book(Can you please let me know how to do that?)

Thanks in Advance

Regards,

Rajesh

Re: Export to Excel

Mon, 23 Feb 2015 13:40:50 GMT

Hi Ramesh,

Probably solved by now but for anyone searching with regards to the type mismatch error it's likely you haven't put the Sub () / end sub() on the VB subroutine.