Win32::OLE::Const 'Microsoft Excel' - sort & freeze pane
- From: Slickuser <slick.users@xxxxxxxxx>
- Date: Tue, 29 Apr 2008 21:48:46 -0700 (PDT)
I would like to sort column A by descending order and other columns to
sort as well.
I used this code and it's doesn't work and I do have Sheet1 in my
workbook.
$CurrentSheet = $Workbook->Worksheets("Sheet1");
$RangeA = $Current***->Range("A1");
$RangeB = $Current***->Range("A20");
$Excel->Selection->Sort({
Key1 => $RangeA,
Order1 => xlDescending,
Key2 => $RangeB
});
I also want to freeze row 2 but this doesn't work as well.
$Excel->Rows("2")->Select; or $Excel->Rows("2:2")->Select;
$Excel->ActiveWindow->{FreezePanes} = "True";
Any help? thanks a lot
.
- Prev by Date: Re: Newbie to programming, Net::Divert, Linux-Debian, autoflush error
- Previous by thread: DBIx::Threaded examples
- Index(es):