Powershell issue when opening file in x86 vs x64 about importexcel HOT 8 CLOSED

in studio, is it runing in PS 5.1?

from importexcel.

It's running a PS 7 session.

from importexcel.

Don't know the difference. Powershell Extension Terminal and PWSH terminal

Are they both running PSv7?

from importexcel.

I can simplify the issue by taking out Visual Studio Code & PowerShell Extension. I ran a couple of commands from the command window and you can see in x86 the Worksheets object is empty and in x64 it is populated.

from importexcel.

I tried deleting the contents of the 12 sheets and saved the file as test2 and x86 loaded the sheets, so x86 doesn't like the content of my file?
I had to remove confidential info but was able to create test3.xlsx file
Report_Template - TEST3.xlsx
which produces the same issue.

from importexcel.

Ok. I'm not sure how to run PS7 on x86. I've never done it and it is not part the automated unit tests that are run.

from importexcel.

https://learn.microsoft.com/en-us/powershell/scripting/whats-new/migrating-from-windows-powershell-51-to-powershell-7?view=powershell-7.4

https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.4
https://github.com/PowerShell/PowerShell/releases/download/v7.4.2/PowerShell-7.4.2-win-x64.msi
https://github.com/PowerShell/PowerShell/releases/download/v7.4.2/PowerShell-7.4.2-win-x86.msi

from importexcel.

Sorry, I don't have the bandwidth to track this and you are the only person to report it as an issue.

from importexcel.