topic Re: Export to excel in QlikView

Export to excel

tyagishaila — Thu, 07 May 2015 13:22:04 GMT

Hi All,

I am using Export to Excel_variant(2) macro in my qlikview document.

In this I want to save 2 reports(Straight Tables) in a single excel file as two different sheets.

This macro is working well on my local pc but not working on Access point and browser.

How can I achieve this? Please help me out.

Thanks,

Re: Export to excel

awhitfield — Thu, 07 May 2015 13:40:49 GMT

Hi Shail,

which client are you using? As macros will only working in the IE Pluign.

Andy

Re: Export to excel

Anonymous — Thu, 07 May 2015 14:47:15 GMT

Have you enabled "Print and Export to Excel" option in QMC?

Some macros can be unusable in AJAX

Have you tried to prepare reports including these tables and then print them ( or save ) via Access Point?

You can add a table with values from both tables and make a report including that table ( as in a attached qvw file )

Re: Export to excel

buzzy996 — Thu, 07 May 2015 15:30:17 GMT

which client ur using? ajax won't support most of the macro's.

Re: Export to excel

tyagishaila — Fri, 08 May 2015 05:36:50 GMT

Hi Andy,

Thanks,

Its also not working on IE .

is there any script problem, means path etc.

Re: Export to excel

tyagishaila — Fri, 08 May 2015 05:39:26 GMT

Hi Thomas,

Thanks for reply,

Send to excel is working on browser, but Macro for export to excel only working on local computer not working on browser.

Thanks

Re: Export to excel

Anonymous — Fri, 08 May 2015 06:19:25 GMT

I'm glad I could help

Re: Export to excel

tyagishaila — Fri, 08 May 2015 09:35:21 GMT

Do you have another idea except merge two reports.

I am still stuck with my problem, not find any solution till now.

Thanks,

Shaila

Re: Export to excel

beck_bakytbek — Fri, 08 May 2015 09:37:52 GMT

Hi Shaila,

to this issue read this, is very helpful :

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

kindly

Beck

Re: Export to excel

Anonymous — Fri, 08 May 2015 09:59:01 GMT

Take a look at:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/‌

How to store report in excel format like we can able to store in csv format.