I'm trying to learn powershell from a vbscript background and for the life of me I can't figure out how to properly sort a worksheet in powershell.
I want to sort descending on column H, but I have a header row, so I'd like to start on cell H2.
How would I do something like this? And how would I sort on 2 separate columns? I can't seem to find any references specifically for powershell on the web.
$excel = New-Object -ComObject excel.application
$wb = $excel.Workbooks.Open("C:\scripts\worksheet.xls")
$ws = $wb.Worksheets.item(1)