From: aero6dof@... (Alan Chen)
Date: 2004-04-15T03:19:12+09:00
Subject: Re: Sort Excel spreadsheet with Ruby?

"Moran, Craig M (BAH)" <MoranCM@navair.navy.mil> wrote in message news:<B9500E218FB4D2119DE30000F810BBBF0F117705@nems13.nawcad.navy.mil>...
> require 'win32ole'
> excel = WIN32OLE.new("excel.application")
> excel['Visible'] = TRUE
> spreadsheet =
> excel.Workbooks.Open("C:\\Path\\to\\your\\spreadsheet\\Spreadsheet.xls")
> sheet = spreadsheet.Worksheets(1)
....

I was able to perform a simple sort by replacing your code:
> sheet.Cells.Select 
> sheet.Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlNo,
> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

for this:
rng = sheet.Cells.Range("A:B") # or some other range
sheet.Cells.Sort(rng)

I haven't tried all the optional arguments yet, but at least this
gives you a minimally working code snippet.

Cheers,
- alan