I'm using Win32:OLE
to manipulate an Excel spreadsheet. I want to sort the sheet on the "F"
column. My code is
$range1 = "A1:H" .
$numrows;
$sheet->Range($range1)->Sort({
Key1 => "F1",
Order1 => xlDescending,
});
But it doesn't
work. Does anyone have any ideas or an example of working
code?
____________________________________________________________________
Steve
Gross
Director of Information Technology
www.jesna.org
Tel:
212-284-6558
Fax: 212-284-6951
Cell: 917-575-4028