I know we already have a programming thread, but powershell is in its own league when it comes to horrible horrible languages with no consistency and structure.. I cant take the pain anymore, so I figure I'll ask my FHC brosif..
So starting this thread off in the best way possible, this is a 'powershell but also not' question.
How the fuck do i insert a column in excel.. I have the following code creates a COM object, opens a file and opens the appropriate worksheet.. But then I get stuck.
I just cant find a good reference for excel COM programming, combined with me not really understanding how powershell interacts with COM stuff..Code:$xl=New-Object -ComObject "Excel.Application" $xl.Visible=$True $Workbook = $xl.Workbooks.Open($filename) $WorkSheet = $Workbook.WorkSheets.Item("Server List") $WorkSheet.activate()