Excel 2010 PowerShell I
This now works for a non-US locale.
| 001
002
003
004
| $xl = New-Object -ComObject "Excel.Application"
$xl.visible = $true
$wb = $xl.workbooks
$wb.Add() |
Well to be strictly correct it works in a UK locale and I’m assuming it works for other non-US locales. As previous versions of Excel threw a wobbly and we had to use an awful work around this is a step forward.
Now we need true PowerShell support for Office :-)
I know the OpenXml PowerShell functionality has been extended. Time to try that against Office 2010