dfinke / ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel
https://www.powershellgallery.com/packages/ImportExcel/
Apache License 2.0
2.48k stars 400 forks source link

ImportExcel 7.8.7 cannot be imported, fails with loading of EPPlus.dll assembly #1597

Closed FH-Inway closed 6 months ago

FH-Inway commented 6 months ago

When importing the 7.8.7 version of ImportExcel, an error occurs:

Import-Module : Could not load file or assembly 'file:///C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules\ImportExcel\7.8.7\EPPlus.dll' or one of its dependencies. The system cannot find the file specified.

Tested with the following commands on Windows 11 (locally) and Windows Server 2022 (Azure DevOps pipeline running on windows-latest agent).

Install-Module ImportExcel
Import-Module ImportExcel

Installing and importing version 7.8.6 works.

Not sure which change since 7.8.6 caused that error.

scm7ak commented 6 months ago

got the same issue too. I've reverted back to 7.8.6 also.

vandanchev commented 6 months ago

We are hitting the same as we always use the latest available version.

ildjarnisdead commented 6 months ago

If you compare the file list of https://www.powershellgallery.com/packages/ImportExcel/7.8.7 with https://www.powershellgallery.com/packages/ImportExcel/7.8.6 you see that almost all files are missing. Something seems to have gone wrong with publishing 7.8.7 to PSGallery.

claytonsaliba commented 6 months ago

Do you have any ETA when this issue is going to be fixed? As this is breaking automations which requires a module and this module as a submodule.

dfinke commented 6 months ago

Looking at it now

dfinke commented 6 months ago

I bumped the version to 7.8.8. Re-published. The file list looks good now.

Please check.

claytonsaliba commented 6 months ago

Confirmed - new version has fixed this issue in our automations. Thanks!

dfinke commented 6 months ago

Strange, I published the 7.8.7

I go thru a process of:

It all worked.

FH-Inway commented 6 months ago

Thanks for the quick fix, can confirm, it is working again.