To export to PPT what do we need toinstall Qlikview OCX or IE Plugin
Hi,I have recently started using Qlik view and I would like to know that to be able to export all the sheets of qlikview in a powerpoint what needs to be installed -Qlikview OCX or Qlikview IE plugin?
I went through some of the old post in the community but some posts mention it as OCX and some as IE plugin.I am totally confused what is best.Also,if anyone could throw some light on what is the exact difference between the two and the benefits it will be easier to evaluate which one is best needed for ones use.
You didn't mention if you want to take every object from a sheet, because all objects from 1 sheet will be a lot of informations in 1 slide of powerpoint, which you have to iterate all objects from every sheet.
If you plan to write some Add-In or something it is good to use the OCX, while downloading it and register it with regsvr32.exe <OCX-name> in order to be able to use it later in C#.
Now, if you want to export your sheets, you can either program it in C# or as XXX. mentioned, you can write it in macro. Now if you plan to export a lot of sheet and a lot other QlikView documents, start using the OCX, because you can automatically make usage of your C# program to be run every day like a scheduling task which will do that export into PowerPoint.
What is the + of the C#? You write it once and never again, since you launch your program with a batch file. The - of macro, you need to copy/paste the code again and again for every new QlikView report and adapt it, which makes things boring after the 100 time of copy/paste/adapt.
The + of C# is, it can generate websites from your PowerPoint in order to visualize it and code can be fast changed in such a way that you can export it to Excel in same time.
A question to you, how many time do you have to do it and what is your knowledge in programming?
If you want to loop through all sheets and objects you can do it with following code in VBScript:
return items; // have all objects/items of your report.
You see the difference in code? That's only for getting the items, now you still have to use Mircosoft.Office.Interop to open a new powerpoint and paste the object inside etc etc. It's getting more complexe working with the OCX than with the macro, but the once the code written it's easier for the export of sheets to Powerpoint.
If you have a lot of time, write it in C# and work with OCX, if you don't, work with macro and do copy/paste/adapt( what my company used to do before I came, and now kicked that and doing it with C# program instead) and schedule it every day.
Hope this opens another vision of your perspective