Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
tyagishaila
Valued Contributor

Export to excel

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,

9 Replies
Highlighted
Partner
Partner

Re: Export to excel

Hi Shail,

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

Andy

Highlighted
thomas_kuler
New Contributor III

Re: Export to excel

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 )

Highlighted
buzzy996
Honored Contributor II

Re: Export to excel

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

Highlighted
tyagishaila
Valued Contributor

Re: Export to excel

Hi Andy,

Thanks,

Its also not working on IE .

is there any script problem, means path etc.

Highlighted
tyagishaila
Valued Contributor

Re: Export to excel

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

Highlighted
thomas_kuler
New Contributor III

Re: Export to excel

I'm glad I could help

Qlik Community - Correct or Helpful.png

Highlighted
tyagishaila
Valued Contributor

Re: Export to excel

Do you have another idea except merge two reports.

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

Thanks,

Shaila

Highlighted
beck_bakytbek
Honored Contributor

Re: Export to excel

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

Highlighted