Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nirpanthan
Contributor III
Contributor III

Qlikview Macros for XLSX or xlsb

Hi all,

I am using this command to export a chart using macros,

But my exported file is generated as 

sub ChartExport()
set obj = ActiveDocument.GetSheetObject("CH08")
obj.ServerSideExportEx "F:\TEST\Export.xlsx", ";" , 6
end sub

Nirpanthan_0-1641552261502.png

In Server we are using Excel 2010 

Qlikview 12 sr3

 

but command for xls is working fine.

Qlik community kindly help

 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That is a very old release from Dec 2016.  I think you need a newer version for the xlsx support. 

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think you may need a newer version of QlikView.  What is the full build number of your version? Help > About Qlikview. 

-Rob

Nirpanthan
Contributor III
Contributor III
Author

Dear Rob,

Qlikview version is  12.10 SR 1

 

Nirpanthan_0-1641810300351.png

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That is a very old release from Dec 2016.  I think you need a newer version for the xlsx support. 

-Rob

Nirpanthan
Contributor III
Contributor III
Author

Thanks Rob