Excel Files In QlikView

naziralala · ‎2016-02-09

Hello All,

I followed this thread below:

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.

avinashelite · ‎2016-02-10

did you check this threads

naziralala · ‎2016-02-10

Yes. i have checked them.

Thanks

petter · ‎2016-02-10

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?

naziralala · ‎2016-02-10

Hello Peter,

I followed this thread below:

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

petter · ‎2016-02-10

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:

Related Topics