Loading .xls file with macros using PowerShell Core for Mac

Question

I am trying to load an Excel file using PowerShell Core for Mac but I am encountering an issue with New-Object. It's failing on the very first line

$Excel = New-Object -ComObject Excel.Application

This is the error message I receive:

New-Object : A parameter cannot be found that matches parameter name
'ComObject'.
At line:1 char:21
+ $Excel = New-Object -ComObject Excel.Application
+                     ~~~~~~~~~~
     + CategoryInfo          : InvalidArgument: (:) [New-Object], ParameterBindingException
     + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.PowerShell.Commands.NewObjectCommand

Has anyone encountered this issue and does anyone know how to fix it?

The Excel.Application COM object is only available when Excel is installed. And I'm not sure if the Mac version of MS Office even provides COM objects. You may want to consider using the ImportExcel PowerShell module instead. — Ansgar Wiechers
– Ansgar Wiechers, Commented Aug 10, 2018 at 13:41
There is not ComObject in Mac OSX even when Excel for Mac is installed. — corretge
– corretge, Commented May 7, 2019 at 15:56

veefu · Accepted Answer · 2018-08-12 07:16:42Z

4

The error message you're receiving says the -ComObject parameter is invalid. Judging from this issue posted on the powershell github I'd say -ComObject is invalid because it is not supported on the Mac platform.

answered Aug 12, 2018 at 7:16

veefu

2,9001 gold badge19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loading .xls file with macros using PowerShell Core for Mac

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related