CODEWITHSUNDEEP
powershell
Peter3
Peter3

Reputation: 2679

How to sort an excel column using Powershell

I need to sort an excel spreadsheet by sorting one column be ascending numbers so 1,2,3,4,5...

Does anyone know a quick and dirty way to sort a excel column in powershell?

Upvotes: 1

Views: 16646

Answers (1)

Peter3
Peter3

Reputation: 2679

function Release-Ref ($ref) { 
    ([System.Runtime.InteropServices.Marshal]::ReleaseComObject( 
    [System.__ComObject]$ref) -gt 0) 
    [System.GC]::Collect() 
    [System.GC]::WaitForPendingFinalizers() 
} 
$objExcel = new-object -comobject excel.application 
$objExcel.Visible = $True 
$objWorkbook = $objExcel.Workbooks.Open("C:\test\flag for errors\1921BB.xls")
$objWorksheet = $objWorkbook.Worksheets.Item(1) 

$objRange = $objWorksheet.UsedRange 
$objRange2 = $objworksheet.Range("E1")  
[void] $objRange.Sort($objRange2) 
$objWorkbook.Save()
$a = Release-Ref($objWorksheet) 
$a = Release-Ref($objWorkbook) 
$a = Release-Ref($objExcel)

Upvotes: 5

Related Questions