Qlik Sense data download in Excel using vba macros

[davifoga]

Hi,

I am quite new to Qlik Sense and I am trying to create a macro in VBA Excel MS in order to download directly the data in the Excel file.

Basically, I wish by clicking a macro-button to download the data from a table in a Qlik App. Possibly according to parameters that I can set every time in the Excel sheet, as if they were Selections in the Qlik App.

How can I proceed? I have tried with Qlik Sense .Net SDK but with no success.

Thank you very much for the help.

David

[Patricia_Silva · Accepted solution]

Hello @davidfoga,maybe you could try using exporting with exportDataMethod: https://help.qlik.com/en-US/sense-developer/June2019/apis/EngineAPI/services-GenericObject-ExportDat... and  https://help.qlik.com/en-US/sense-developer/June2020/Subsystems/APIs/Content/Sense_ClientAPIs/Capabi...