topic Excel Files In QlikView in QlikView

Excel Files In QlikView

naziralala — Tue, 09 Feb 2016 21:26:57 GMT

Hello All,

I followed this thread below:

https://community.qlik.com/thread/189024

and implemented this script code below in powershell.

$shell_app=new-object -com shell.application

02.$filename = "Gain.zip"

03.$zip_file = $shell_app.namespace((Get-Location).Path + "\$filename")

04.$destination = $shell_app.namespace((Get-Location).Path)

05.$destination.Copyhere($zip_file.items())

In my Qlikview script:

execute "c:\Program Files\7-Zip\7z.exe" e "C:\Apps\Gain.zip"

// -y -oc:\Apps\

I am not getting the files unzipped in this location.

Is there something that i am missing?

Please assist.

Thanks.

Re: Excel Files In QlikView

avinashelite — Wed, 10 Feb 2016 06:31:55 GMT

did you check this threads

Can one load file info of .zip files in Qlikvie... | Qlik Community

Unzip a file

How to unzip files in qlikview ?

Re: can i unzip a file in Qlikview?

Re: Excel Files In QlikView

naziralala — Wed, 10 Feb 2016 18:01:42 GMT

Yes. i have checked them.

Thanks

Re: Excel Files In QlikView

petter — Wed, 10 Feb 2016 18:30:25 GMT

You show two different approaches... have you tried both separately and none of them worked?

Both seems a bit like they won't work.

The first since you have some line numbers in front of line 2 to 5 like...

They shouldn't be there or the PowerShell script won't work. How do you execute the PowerShell script
from QlikView? You haven't described how?

The next approach has the last parameter commented out - is that right?

// -y -oc:\apps

Could you please clarify?

Re: Excel Files In QlikView

naziralala — Wed, 10 Feb 2016 19:21:59 GMT

Hello Peter,

I followed this thread below:

https://community.qlik.com/thread/189024

Please guide me how to execute the PowerShell script in QlikView?

The comment before the //-y is not in my script.(a typing error)

Thanks

Re: Excel Files In QlikView

petter — Wed, 10 Feb 2016 21:39:14 GMT

Currently I have a better suggestion. Try this Unzip-function that I developed by using VBscript and can be called from the LOAD SCRIPT.

What you see in the screenshots below is all in the UNZIP.QVW that I have attached that demonstrates the use of the unzip routine: