Re: Using Win32::OLE and Excel - Tips and Tricks

[pinguxx]

in reply to Using Win32::OLE and Excel - Tips and Tricks

is there anyway to do freeze_panes with win32-ole, i see that spreadsheet::writeexcel does, can win32 do it?

[explorer]

    $sheet->Cells( $y, $x )->Select();
    $Excel->ActiveWindow->{FreezePanes} = 1;