topic Re: ExportEx not working in QlikView

ExportEx not working

Mon, 26 Jan 2026 16:26:21 GMT

Hello,

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")

chart_kpi5_1.ExportEx"C:\Folder1\test.xls",5

The problem is that when I go to that folder it has not created anything!

Does anyone had the same problem?

Thank you!

Re: ExportEx not working

tamilarasu — Fri, 22 Apr 2016 09:41:05 GMT

Miguel,

Try,

set chart_kpi5_1 = ActiveDocument.GetSheetObject("CH368")

chart_kpi5_1.ExportEx "C:\Folder1\test.xls" , 5

Re: ExportEx not working

Fri, 22 Apr 2016 09:47:55 GMT

Hi Tamil,

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!

Re: ExportEx not working

tamilarasu — Fri, 22 Apr 2016 09:55:42 GMT

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.

Re: ExportEx not working

Fri, 22 Apr 2016 10:07:42 GMT

Hi Tamil,

This is my code:

Sub includeFile(ByVal fSpec)

executeGlobal CreateObject("Scripting.FileSystemObject").openTextFile(fSpec).readAll()

End Sub

includeFile "QvUtils.vbs"

with New QlikView

.open("..\..\QVW\Sales\Field Performance.qvw")

set chart_kpi5_2 = ActiveDocument.GetSheetObject("CH356")

When I do this I get: Object required: ActiveDocument

Thank you again!

Re: ExportEx not working

tamilarasu — Fri, 22 Apr 2016 11:07:26 GMT

Miguel,

Try,

Sub includeFile(ByVal fSpec)

executeGlobal CreateObject("Scripting.FileSystemObject").openTextFile(fSpec).readAll()

End Sub

includeFile "QvUtils.vbs"

with New QlikView

.open("..\..\QVW\Sales\Field Performance.qvw")

set chart = .doc.GetSheetObject("TB03")

chart.ExportBiff("C:\Folder1\test.xls")

.doc.CloseDoc

.Quit

end with

Re: ExportEx not working

Fri, 22 Apr 2016 11:14:25 GMT

Hi Tamil,

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...

Thank you again!

Re: ExportEx not working

marcus_sommer — Fri, 22 Apr 2016 11:49:57 GMT

with New QlikView

.open("..\..\QVW\Sales\Field Performance.qvw")

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","","")

set App = ActiveDocument.GetApplication

App.OpenDoc "C:\MyDocuments\Budget.qvw","JNN","123456"

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.

- Marcus

Re: ExportEx not working

Fri, 22 Apr 2016 11:53:52 GMT

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!

Re: ExportEx not working

tamilarasu — Fri, 22 Apr 2016 12:01:20 GMT

Relative path is working fine. I have attached sample application.

Re: ExportEx not working

marcus_sommer — Fri, 22 Apr 2016 13:21:59 GMT

In this case you might need to make these object visible - this meant a minimized chart could not be exported as image, here another example from the APIGuide.

ActiveDocument.GetSheetObject("CH01").Restore

rem ** restore all sheet objects on sheet Main **

set s=ActiveDocument.Sheets("Main")

for i=0 to s.NoOfSheetObjects-1

s.SheetObjects(i).Restore

Also it might help to change the export-feature from ExportEx to Export or to ExportBitmapToFile.

- Marcus

Re: ExportEx not working

tamilarasu — Fri, 22 Apr 2016 18:44:09 GMT

Hello Miguel,

Sorry for the late reply. I had left for the day and I saw your message before an hour. After gathering some knowledge from google, I found a solution for you.

Below code exports the graph into .XLS format.

'==========================================================
Sub includeFile(ByVal fSpec)
    executeGlobal CreateObject("Scripting.FileSystemObject").openTextFile(fSpec).readAll()
End Sub

includeFile "QvUtils.vbs"

with New QlikView
'==========================================================
'File Path & Date Format => YYYYMMDD_HHMMSS

    strPath = GetAbsolutePath("..\Output\")
    strDate = Year(now) & Right ("0" & Month(Now),2) & Right ("0" & Day(Now),2)
    strTimeStamp = Right("0" & Hour(Now),2) & Right ("0" & Minute(Now),2) & Right ("0" & Second(Now),2)
    strFile = StrPath & "Test " & strDate & "_" & strTimeStamp & ".xls"
'==========================================================

   .open("..\App\1.qvw")
    set chart = .doc.GetSheetObject("CH01")
    chart.CopyBitmapToClipboard
'==========================================================  

    Set obj = CreateObject("Excel.Application")
    obj.visible = False
    Set objWb = obj.Workbooks.Add
    obj.Activeworkbook.Activesheet.Paste()
    obj.Activeworkbook.SaveAs strFile, -4143   '51 for xlsx
    obj.Quit
    obj.visible = True
    Set chart = Nothing
    Set obj  = Nothing
    Set objWb = Nothing
'=========================================================

  .doc.CloseDoc
  .Quit
  Msgbox "Graph Exported Successfully!!", VbOKOnly + VbInformation ,"VBScipt Status"
end with

Output:

If you want to save the graph as JPG format, you can use the below code.

Sub includeFile(ByVal fSpec)
    executeGlobal CreateObject("Scripting.FileSystemObject").openTextFile(fSpec).readAll()
End Sub


includeFile "QvUtils.vbs"

with New QlikView
  .open("..\App\1.qvw")
  set chart = .doc.GetSheetObject("CH01")
  chart.ExportBitmapToFile  (GetAbsolutePath("..\Output\Test.jpg"))
  .doc.CloseDoc
  .Quit
  Msgbox "Graph Exported (JPG) Successfully!!", VbOKOnly + VbInformation ,"VBScipt Status"
  Set chart = Nothing

end with
end w

I have attached all the tested files for your reference. Have a look and let me know if you still have any issues.

Re: ExportEx not working

Mon, 25 Apr 2016 07:00:27 GMT

Hi Tamil,

First of all thank you very much for your help and collaboration but that is not what I need... Maybe it is my fault as I have not explain myself very good. What I am trying to do is:

I have this object (that is a graph):

And I want to do this:

So I get this:

That is why I was trying ExportEx because Graphs does not support ExportBiff...

Do you know how should I proceed in order to export that graph to excel using VBS?

Thank you very much again!

Regards,

Re: ExportEx not working

tamilarasu — Tue, 26 Apr 2016 10:12:06 GMT

Miguel,

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 .

chart.CopyBitmapToClipboard

chart.CopyTableToClipboard True

Actual Chart:

Output:

Seems you have opened wrong attachment. Herewith, I have attached the updated one.

Re: ExportEx not working

Tue, 26 Apr 2016 10:25:09 GMT

Thank you very much for your suppor Tamil!