Regarding Excel upload

[#1]

Hello Friends,

Is there any way to upload  an excel file on a fly using a macro in a desktop application with out publisher?

Thanks,

Kiru

[Anonymous]

Certainly using Reload action of Button.You can create xls name in variable based on dynamics of xl file name

[#3]

Thanks Swapnil !

Kindly could you explain a little in detail or share an example if you already have one?

In reload button action ,I am able to reload only the existing application.

Thanks so much

Kiru

[Anonymous]

Kiru, Can you explain a bit what exactly you are trying to achieve?What does on the fly mean exactly what is your use case?

[shree909]

Hi,

I think u need to create an action on the button or textbox and when u hit the button it will reload the application.

or create an if statement when to  reload the button depending on the time.

Thanks

[#6]

Dear Swapnil,

Thanks so much!

My scenario:

I have an application which is fetching data from 2 excel files.

Now, In the same application , the user wants to upload new excel files by them selves when ever needed by clicking a button in user interface instead in edit script.

Say for eg, I have attached an application which fetches data from excel,kindly let me know that I can update that source with the new source by clicking a botton in front end and charts changes according after reload with new source?

Kindly let me know if you did not get it!

Thanks,

Kiru

[#7]

Hello Shree,

Thanks so much!

I need to upload a file before reload,kindly let me know is there any way to upload an excel file by clicking a button instead of using through edit script because the user is unfamiliar with the QlikView?

What I am looking is just by clicking a button in user interface,it navigates to a folder ,I can then select and upload the excel file into QlikView!

so then I can create a button for reload as you suggested!

Please let me know

Thanks,

Kiru

[Anonymous · Accepted solution]

I think of this which will work on desktop client

Step 1: Create a input box for file name (user will input file name)

Step 2: Populate variable with value in input box

Step 3: Have your script as below

Load

*

From

<Variable Name>

Step 4:Create button and set action to reload

If path is going to change always user need to give file name along with complete path. If path is same you can hardcode path and take file name from input box

[#9]

Awesome!

Thanks so much for your timely help and I really appreciate it

Regards,

Kiru