topic Re: Load data from excel using Macro in QlikView

Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:05:17 GMT

Hi All,

Can any help me in loading the data from excel file to the Qlikview using Macro.

Using Macro I need to create connection to excel and load the data from excel to Qlikview.

Thanks in Advance

Thanks,

Leni

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:07:56 GMT

You can't load data from the macro (except for dynamic data update). The closest would be to trigger a reload or EDX job to start a reload and pull the Excel file in the script.

I'm guessing you're trying to create some kind of on demand reload where users can add data into an excel sheet and want to bring that into QlikView on the fly?

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:15:01 GMT

Yes Johannes.

How we can do it??

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:16:29 GMT

I would probably recommend storing the Excel in a specific place (Folder) and then have the users trigger an EDX task to reload the document and then pick up the Excel file in the QlikView script.

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:24:03 GMT

So we cannot do the below steps using Macro??

Create a connection to the source data (xls).
Read data from xls.

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:26:02 GMT

Technically you can using Dynamic Data Update, however, this only feeds data into the session for a particular user. If the user closes the document and opens it again, the data is gone. This is why I recommend the other approach instead

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:30:45 GMT

Can you tel me how to do that using Dynamic update because my requirement is something like that thats y.

Thanks for your help Johannes

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 07:32:15 GMT

There should be a few examples of dynamic data update if you search the forums but in general I think it's better to revisit the requirements than pursue this solution for most situations.

Re: Load data from excel using Macro

Anonymous — Tue, 20 Nov 2012 09:10:06 GMT

I searched in forum but I got for Insert, update and Delete only. Did'nt get an example to load data from an excel file.

If you have any samples it would be very helpful for me.

Thanks

Re: Load data from excel using Macro

Anonymous — Wed, 21 Nov 2012 06:19:40 GMT

Hi,

I have loaded data from excel using macro with Dynamic Update. Sample is attached

Do the following before using this sample:

1. Set Current Local Security -> Allow System Access in Macro settings

2. In the Macro give your excel file path.

3. If you are giving same fields as in my macro then no need to do anything, else changed the Field names in macro.

Regards,

Leni Balakrishnan

Re: Load data from excel using Macro

farolito20 — Wed, 09 Jan 2013 23:04:31 GMT

How can I load data from a qvd file using macro?

Re: Load data from excel using Macro

Sat, 16 Mar 2013 11:08:44 GMT

I am getting one error message :-

ActiveX component can't create object: 'Excel.Application'

Can you help me what is the problem ?

Thanks

Re: Load data from excel using Macro

Anonymous — Mon, 18 Mar 2013 05:56:59 GMT

Check whether you did the belwo step

Set Current Local Security -> Allow System Access in Macro settings

Thanks,

Leni Balakrishnan