topic Re: Qlikview Macros for XLSX or xlsb in App Development

Qlikview Macros for XLSX or xlsb

Nirpanthan — Fri, 07 Jan 2022 10:46:38 GMT

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

In Server we are using Excel 2010

Qlikview 12 sr3

but command for xls is working fine.

Qlik community kindly help

rwunderlich — Sat, 08 Jan 2022 04:32:40 GMT

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

-Rob

Nirpanthan — Mon, 10 Jan 2022 10:25:12 GMT

Dear Rob,

Qlikview version is 12.10 SR 1

rwunderlich — Mon, 10 Jan 2022 14:26:59 GMT

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

-Rob

Nirpanthan — Tue, 11 Jan 2022 05:11:25 GMT

Thanks Rob