topic Re: Export to XLS without Macros in QlikView

Export to XLS without Macros

Wed, 30 Sep 2015 13:43:21 GMT

Dear QV Experts,

We have few charts in the sheet & need to be exported to XLS SpreadSheet without Macros.

Can you please share your thoughts.

Thanks,
SasikumarR

Re: Export to XLS without Macros

pamaxeed — Wed, 30 Sep 2015 13:47:18 GMT

Hi,

if you want to export the charts data into a single sheet then the only way you can achieve it is to use macro.
On the other way there is the possibility to export a chart one by one in a diff. .xls, but as I understood it is not what are you looking for.

Cheers,

Patric

Re: Export to XLS without Macros

Wed, 30 Sep 2015 13:53:05 GMT

If each sheet can be exported seperately you can right click on the chart and select Send to Excel or Export, which will then send to a .csv file

Re: Export to XLS without Macros

datanibbler — Wed, 30 Sep 2015 13:57:30 GMT

Hi Sasi,

in addition to the possibility thatPatric has mentioned, there is a third-party tool called "ReportToMail" which supports exporting charts to Excel - to a specific worksheet and into a specific range of cells. But well, that would again be an additional tool that you'd need.

Without anything extra, I guess Patric's solution is the only one.

HTH

Re: Export to XLS without Macros

Chanty4u — Fri, 09 Oct 2015 10:02:09 GMT

hope this helps you..