尝试使用Powershell解压文件

我试图解压一堆包括新的xlsx文件到TMP文件夹的档案，然后在该文件夹上工作，然后将其删除。 而狗屎只是不想走我的路。

$spath = "C:\_PS\TestFolder" $destination=”C:\TestFolder\Testzip" Get-ChildItem $spath -include *.xlsx -Recurse | foreach-object { # Remove existing TMP folder and create a new one Remove-Item -Recurse -Force $destination New-Item $destination -type directory $archiveFile = $_.fullname | out-string -stream "Extract this: " + $archiveFile "To here: " + $destination $shellApplication = new-object -com shell.application $zipPackage = $shellApplication.NameSpace($archiveFile) $destinationFolder = $shellApplication.NameSpace($destination) $destinationFolder.CopyHere($zipPackage.Items()) } 

它总是给我这些错误

 Exception calling "NameSpace" with "1" argument(s): "Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))" At C:\_PS\FindCC.ps1:62 char:46 + $zipPackage = $shellApplication.NameSpace <<<< ($archiveFile) + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : ComMethodTargetInvocation You cannot call a method on a null-valued expression. At C:\_PS\FindCC.ps1:64 char:50 + $destinationFolder.CopyHere($zipPackage.Items <<<< ()) + CategoryInfo : InvalidOperation: (Items:String) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull 

• 设置MySQL INNODB压缩KEY_BLOCK_SIZE
• 如何在SSLstream压缩时禁用Apache http压缩（mod_deflate）
• 无法发送到压缩（压缩）文件夹
• 如何在CentOS上编译带有zip支持的PHP 5.2.13版本？
• 支持multithreading的Linux压缩工具

 Get-ChildItem $spath -include *.zip -Recurse 

  -include *.xlsx 

 function Extract-Zip { param([string]$zipfilename, [string] $destination) if(test-path($zipfilename)) { $shellApplication = new-object -com shell.application $zipPackage = $shellApplication.NameSpace($zipfilename) $destinationFolder = $shellApplication.NameSpace($destination) $destinationFolder.CopyHere($zipPackage.Items()) } else { Write-Host $zipfilename "not found" } }