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

     

 

 

Reply via email to