Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
ana_ag_qlik
Contributor
Contributor

Export/download data from Qlik Sense using VBA

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.

Capture.PNG

 

 

4 Replies
davifoga
Contributor II
Contributor II

Hi,

I am trying to do the same.

Did you figure out a working solution? 

Thank you.

yko
Employee
Employee

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
Contributor II
Contributor II

Thank you @yko , 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

yko
Employee
Employee

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