Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Export to Excel not working

Hi,

I am trying to export to excel via the straight table menu option, however the data is not reaching the excel document and instead a XML string is written.

Any Idea!!!

8 Replies

Re: Export to Excel not working

Check the settings in UserSettings in export-tab.

- Marcus

neha_shirsath
Valued Contributor

Re: Export to Excel not working

Hii aravind_rajguru,

I'm facing the same problem. But I've downloaded the IE plugin nd in that it's working fine.

In fact in another PC also it's working fine.

So you also try on another PC. Hope it will help you.

Regards,

Neha

Not applicable

Re: Export to Excel not working

Thanks Neha

The application is used by 25 users in different machines and all of them get the same outcome. However, if I restart the Qlikview (Windows 2008) server, it works fine for a significant time.

Is there any permanent solution to this issue?

Arvind

neha_shirsath
Valued Contributor

Re: Export to Excel not working

Hii aravind,

I overcome this problem by right click on XL button and select the Export option,and save the file name and file type as .csv. And I'm getting more than 6500 data also in .csv.

Regards,

Neha

Not applicable

Re: Export to Excel not working

Hi Neha,

Right click and export to CSV is directly opening the contents in the browser itself. However the error sometime occurs. We only using firefox browser.  Can you share which browser you are using?

Arvind

phaneendra_kunc
Valued Contributor III

Re: Export to Excel not working

Seems this occurs if your temp directory has less space.

See below thread.

http://community.qlik.com/message/333748#333748

Not applicable

Re: Export to Excel not working

Thanks Phaneendra

Looks like this was the problem! There was no Alternative directory specified, therefore it was using the default path, which does not have enough space. I re-pointed the 'Alternate Extensions Path'  to a NAS path and is working fine.

Regards

Arvind

neha_shirsath
Valued Contributor

Re: Export to Excel not working

Hi Arvind,

I'm using Internet Explorer browser, & it's working fine. And in that it's asking for in which type you have to export Data.

Regards,

Neha

Community Browser