Best way to Export all the charts into a single Excel file...?

[Anonymous]

Hi All,

We need some better method to Export all the related charts/tables into a single Excel file.

We know that we have a macro for that  but , we will face the issues if we use macros.

So please suggest some other alternative without macro.

or incase if this is not at all possible with macros , at least suggest how to do it with a single and small macro.

instead of writing macro to each and every chart/table its better if write it for including all.

Thanks in advance.

Best Regards,

Sravan

[#2]

Use macro allow you to save multiple objects into a single excel in different cells or sheets. I am facing the same issue with you but still do not find any good solutions. I think you can save the whole sheet as the image without macro.The way is click "File"->"Export"->"Export sheet image" But we cannot do other analyze in the excels anymore, I understand its pretty annoying to copy objects one by one. For more, is it possible to integrate the charts values into one big straight table and export it to excel? Hope it wells.

[jharke]

Hello Sravan

There are a few posts with some suggestions by users for a problem like you describe here:

https://community.qlik.com/message/1055761#1055761

And

https://community.qlik.com/message/646894#646894

Maybe this will help?