Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gargi_bardhan
Creator
Creator

Send to excel (Not using Macro)

Hi All,

Can any one suggest any other alternative way for sending Qlivkiew objects(Grids & Charts) to Excel without the use of macro as due to security concerns in my organization its restricted.

Thanks all,

Gargi

1 Solution

Accepted Solutions
Not applicable

By using CIA report manager, you can extract data from specific QV objects in the form of tables, text, images, cyclic & iterative dimensions. You also have the ability to loop through fields to create focus set reports.

CIA also has a very powerful built-in scripting language that does high end development of report writing.

View solution in original post

12 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi,

You can use the normal way of clicking on the XL icon or right click on the chart and graph and select send to excel.

thanks,

Rajesh Vaswani

gargi_bardhan
Creator
Creator
Author

Thanks Rajesh for your time, but by sending to excel I mean to say automatically the reports need to be send to excel by using some tool or some other way around.

Regards,

Gargi

Anonymous
Not applicable

Gargi

Have you checked out the NPrinting tool ?

     www.vizubi.com/nprinting/

Best Regards,     Bill

gargi_bardhan
Creator
Creator
Author

Thanks Bill, not checked with this tool,will explore & let you know. In between if you have any suggestions about it let me know.

Regards,

Gargi

jerrysvensson
Partner - Specialist II
Partner - Specialist II

HI

Have a look at ServerSideExportEx in the API guide. If you want to export objects when reloading.


I also recommend NPrinting.

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Gargi.

With NPrinting you can schedule the delivery of QlikView charts, tables and objects in Excel, Word, Powerpoint and HTML format to folders, email addresses or Google Drive. You can also tailor each object by user so, in an international company for instance, you can filter the data so that a manager in India would receive objects containing only Indian business data.

Have a look at http://www.quickintelligence.co.uk/nprinting/.You can get a free 35 day trial licence so that you can try before you buy.

Regards,

Neil

gargi_bardhan
Creator
Creator
Author

Thank you so much Neil for your suggestions, in my organization there is CIA Report Manager tool Available for exporting to Excel or pdf,so focusing on that. Please let me know if you have any suggestion on that.

Regards,

Gargi

gargi_bardhan
Creator
Creator
Author

Thanks Jerry for replying, but in my organization we have licenses for CIA Report Manager ,so if you have any idea on it please let me know. I am very new to that tool so facing many issues.

Regards,,

Gargi

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Gargi.

Sorry, I have no experience of CIA so I cannot help you on that, I'm afraid.

Regards,

Neil