Export/download data from Qlik Sense using VBA

[ana_ag_qlik]

Hello there,

My colleagues have asked for my help for developing some Excel macros. However, the data that would have to feed the Excel file come from files they download from web Sense app, which I have never used.

What they do to get the data is just to export as shown in the image. However, they would like the Excel macros to automatically download the data as xlsx/csv files. Would that be possible using the web Sense app?

Is there a way to fulfill this need of automatically getting the data using VBA? I guess that if it is not possible at all, I would not be able to help them in the way they need.

Thanks a lot for your time.

[davifoga]

Hi,

I am trying to do the same.

Did you figure out a working solution? 

Thank you.

[Øystein_Kolsrud]

You can export to Excel using the following method in the Engine API:

https://help.qlik.com/en-US/sense-developer/May2021/apis/EngineAPI/services-GenericObject-ExportData...

If you're using Visual Basic, then you probably want to use the .NET SDK for accessing the corresponding endpoint in that library:

https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGen...

The .NET SDK is available as a NuGet packet:

https://www.nuget.org/packages/QlikSense.NetSDK/

[davifoga]

Thank you @Øystein_Kolsrud , I think this is exactly what I am looking for.

Maybe you can help me though - when I try to import the new QlikSense.NetSDK reference in the Excel VB project, I receive an error stating "Can't add a reference to the specified file".

Do you know what may cause it? Maybe do I need to take other actions before importing the .NET SDK library?

Thank you very much.

David

[Øystein_Kolsrud]

I'm afraid I know very little about VB development in Excel, but this page might be of interest:

https://docs.microsoft.com/en-us/office/client-developer/excel/how-to-access-dlls-in-excel