header image

Excel 2010 PowerShell I

Posted by: | July 16, 2009 | 1 Comment |

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: PowerShell,Office 2010
under: PowerShell original

1 Comment

  1. By: Tibor Soos on December 20, 2009 at 10:12 am      

    It seems, that it still does not work with Hungarian locale :-((((