topic Re: Open and save exel file using script in QlikView

Open and save exel file using script

Thu, 17 Oct 2013 08:02:36 GMT

Hi All,

Is anyone able to advise me how write a script to open a exel file and save the exel file please?

Thank you very much!!

Re: Open and save exel file using script

rustyfishbones — Thu, 17 Oct 2013 08:11:45 GMT

Create a Button and Add an action to it to Launch the excel file

Action-Add Action- External-Launch

Click ok

Then add the file name

Re: Open and save exel file using script

Thu, 17 Oct 2013 08:19:08 GMT

Thanks very much Allan.

How do I write a script for this please? I am planned to have this script before my Load statement..

Thanks very much!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Find out more about Platts Oil Methodology Explained Sessions<http://marketing2012.platts.com/content/OLGL2013OM_MethodologyTraining?mvr=eventlisting> in Houston, Singapore and London, or visit the On Demand Session<http://www.plattsmethodology.com/>

Re: Re: Open and save exel file using script

rustyfishbones — Thu, 17 Oct 2013 08:24:24 GMT

I don't have a script, but check this post

http://community.qlik.com/message/192704#192704

it may help

Re: Open and save exel file using script

Thu, 17 Oct 2013 08:39:32 GMT

That script does not work.

So I will stick to your advice.

I need one last action with the Button. Add a new worksheet in the exel and save the exel.

Any advise please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Re: Open and save exel file using script

rustyfishbones — Thu, 17 Oct 2013 08:43:29 GMT

You cant use button to do that.

You need to add Macros like the previous post I gave.

To add a Macro, press CTRL M which will bring you to the Edit Module where you can add the Macro

You then call that macro from an action on a button

Re: Open and save exel file using script

rustyfishbones — Thu, 17 Oct 2013 08:46:08 GMT

here is a link to a video on how to create a simple macro

Qlikview Macro to Show-Hide TabRow by RFB 150 - YouTube

Re: Open and save exel file using script

Thu, 17 Oct 2013 09:14:20 GMT

Thanks Alan.

I am getting error below when test the macro ..

Any suggestion what is the issue please?

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Re: Open and save exel file using script

rustyfishbones — Thu, 17 Oct 2013 09:37:45 GMT

Allow system access in the Edit Module

Re: Open and save exel file using script

Thu, 17 Oct 2013 09:54:52 GMT

All is GOOD now ☺

Correct answer !!

Thanks Alan !!

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston