topic Re: Load and Reload data from Excel to Qlikview in QlikView

Load and Reload data from Excel to Qlikview

Black_Hole — Mon, 26 Jan 2026 16:26:21 GMT

Hello all,

Firstly, I will describe the context.

I would like to load data from Excel in a QV table.

Moreover, I would like to reload/update data in my QV table if there are modifications in the data from Excel (maybe with a button, I could update data in my QV table).

But, after a lot of research on the web, I still don't know how I can do that and what is the best way (macro VB, or script, ...) ??

Please could you help with my request.

Thank you in advance for your support.

Re: Load and Reload data from Excel to Qlikview

Vegar — Tue, 09 Apr 2019 16:22:12 GMT

It is possible to trigger a QlikView task externally with an EDX job. So I assume you can have a macro in excel monitor the excekfile for changes and then trigger the edx job reloading your application.

Re: Load and Reload data from Excel to Qlikview

Black_Hole — Wed, 10 Apr 2019 08:44:43 GMT

Hello @Vegar ,

Great, if EDX job can help me to launch a macro which reload data from Excel to QV.

Honestly, I never used this functionality of QV.

Please could you share with me some advice, links... to apply an EDX Job in order load/reload data with a macro.

Thank you in advance for your help.

Re: Load and Reload data from Excel to Qlikview

Vegar — Wed, 10 Apr 2019 09:10:58 GMT

You can use the braathen/qv-edx-trigger (
https://github.com/braathen/qv-edx-trigger ) to trigger from the windows
command prompt/bat script. The readme-file in that project describes
pretty well how to get started.

The bat script you create should be able to run in excel using a macro VBA
script.

BR
Vegar

Re: Load and Reload data from Excel to Qlikview

PrashantSangle — Wed, 10 Apr 2019 09:26:03 GMT

How would you know that data is updated or not in excel???

Use button in qlikview sheet
right click on button > property > action > trigger > external > reload.

Regards,
Prashant

Re: Load and Reload data from Excel to Qlikview

Vegar — Wed, 10 Apr 2019 09:41:28 GMT

@PrashantSangle as I understand it @Black_Hole wants Excel it self to trigger an reload when the excel is updated hence QlikView can not know when an update i done.

An alternative solution would be to frequently trigger a job in QMC that reads the excelfile change date. When the file date is changed then perform an new load of the file.

Re: Load and Reload data from Excel to Qlikview

Black_Hole — Wed, 10 Apr 2019 10:11:58 GMT

Hello all,

Thank you both of you for your help.

@PrashantSangle : Great, I tried your solution and it's exactly what I research. It's an easy and quick way to do what I want (and particularly because I'm a novice in QV).

@Vegar : Thanks a lot for sharing the link. I will learn how I can do to trigger a job in QMC.

Re: Load and Reload data from Excel to Qlikview

PrashantSangle — Wed, 10 Apr 2019 10:42:22 GMT

welcome. 🙂