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) |