Operation is not supported. (Exception from HRESULT: 0x80131515)

[RyanFromIT]

Ran this:
Import-Module .\PSExcel.psm1

Got this in return:
`Add-Type : Could not load file or assembly 'file:///F:\PowerShell\ClassComp\PSExcel-master\PSExcel\lib\epplus.dll' or
one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)
At F:\PowerShell\ClassComp\PSExcel-master\PSExcel\PSExcel.psm1:9 char:26

• if( -not ($Library = Add-Type -path $BinaryPath -PassThru -ErrorAction stop) ...
  

•                      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (:) [Add-Type], FileLoadException
  • FullyQualifiedErrorId : System.IO.FileLoadException,Microsoft.PowerShell.Commands.AddTypeCommand`

[RyanFromIT]

There is a fix to this...
I went to the EPPlus site and download the latest (4.1 at this time). I extract the DotNet4 version and replaced the dll and xml that cam with PSExcel.

[RamblingCookieMonster]

Hiyo! Glad you found a workaround!

How did you install PSExcel? If via download, do you recall if you unblocked the zip/files? Have seen this before e.g. this issue

Cheers!

[RyanFromIT]

I installed via zip

Get-ChildItem .\PSExcel* -Recurse | Unblock-File
Import-Module .\PSExcel\PSExcel.psm1 -Scope Global

In my case, it's a different module loading the PSExcel module, so I needed to specify the scope.