Export to excel

[tyagishaila]

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,

[awhitfield]

Hi Shail,

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

Andy

[Anonymous]

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 )

[buzzy996]

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

[tyagishaila]

Hi Andy,

Thanks,

Its also not working on IE .

is there any script problem, means path etc.

[tyagishaila]

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

[Anonymous]

I'm glad I could help

[tyagishaila]

Do you have another idea except merge two reports.

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

Thanks,

Shaila

[beck_bakytbek]

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

[Anonymous]

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.