Discussion Board for collaboration on QlikView Integration.
I am having an issue with Export Ex when I try to export a Graph to .xls This is the code I am using:
set chart_kpi5_1 = .doc.GetSheetObject("CH368")
The problem is that when I go to that folder it has not created anything!
Does anyone had the same problem?
Go to Solution.
First of all, no need to say thanks and all. I am just sharing with you what I knew. If you could post your issues clearly, you might get answers quickly (almost four days in your case).
Now coming to your issue. Change below line .
Seems you have opened wrong attachment. Herewith, I have attached the updated one.
set chart_kpi5_1 = ActiveDocument.GetSheetObject("CH368")
chart_kpi5_1.ExportEx "C:\Folder1\test.xls" , 5
First of all thank you. But it still does not work as I am using a .vbs script... Any other idea?
Thank you very much again!
Miguel, The above one is working fine. Could you post your full script and explain us what you are trying to do.? So that we can check and provide a solution.
This is my code:
Sub includeFile(ByVal fSpec)
with New QlikView
set chart_kpi5_2 = ActiveDocument.GetSheetObject("CH356")
When I do this I get: Object required: ActiveDocument
Thank you again!
set chart = .doc.GetSheetObject("TB03")
Thank you very much again. The problem is that the object I am trying to export is a Graph and Graphs do not suppor ExportBiff... That is why I am trying with ExportEx...
with New QlikView
isn't a valid statement to open another qvw - see here an example from the APIGuide.qvw (is in your install-folder by automation):
rem ** VBScript **
set App = ActiveDocument.GetApplication
set newdoc = App.OpenDoc ("C:\MyDocuments\QV4Automation.qvw","","")
rem ** Visual Basic **
dim App as New QlikView.Application
set newdoc = App.OpenDoc ("C:\MyDocuments\Budget.qvw","JN","123456")
and I'm not sure if relative paths are working here.
I am not having issues opening the app furthermore I am able to export many other objects but when I try to export a Graph is when I am having that issue...
Thank you for your response!
Relative path is working fine. I have attached sample application.