Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Monday, January 19, 2009

list out all services and store them an MS Excel spreadsheet

PS>
$a = new-object -comobject excel.application
$a.Visible = $True
$b = $a.Workbooks.Add()
$c = $b.Worksheets.Item(1)
$c.Cells.Item(1,1) = "Service Name"
$c.Cells.Item(1,2) = "Service Status"
$i = 2
get-service | foreach-object{ $c.cells.item($i,1) = $_.name; $c.cells.item($i,2) = $_.status; $i=$i+1}
$b.SaveAs("Test.xls")
$a.Quit()

Make sure you have installed MS Excel because it will register it as a COM-type, otherwise it can't load during processing.