Monthly Archive

Excel 2010 PowerShell I

This now works for a non-US locale.

$xl = New-Object -ComObject "Excel.Application"
$xl.visible = $true
$wb = $xl.workbooks


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

Technorati Tags: ,

One Response to Excel 2010 PowerShell I

Leave a Reply