Categories

Excel 2010 beta

 

The beta still allows those of us that aren’t in the USA to use the simple method of creating a new spreadsheet using PowerShell.

001
002
003
$xl = New-Object -comobject "excel.application" 
$xl.visible = $true
$xlbooks =$xl.workbooks.Add()

 

Makes life easier.

In case you are wondering – if you don’t have your machine set to US English and you are using Excel 2007 or earlier you have to do this.

001
002
003
004
005
$xl = New-Object -comobject "excel.application" 
$xl.visible = $true
$xlbooks =$xl.workbooks
$newci = [System.Globalization.CultureInfo]"en-US"
$xlbooks.PSBase.GetType().InvokeMember("Add", [Reflection.BindingFlags]::InvokeMethod, $null, $xlbooks, $null, $newci)

 

Leave a Reply