Categories

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

Technorati Tags: ,

One Response to Excel 2010 PowerShell I

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>