http://www.perlmonks.org?node_id=511836


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?
  • Comment on Re: Using Win32::OLE and Excel - Tips and Tricks

Replies are listed 'Best First'.
Re^2: Using Win32::OLE and Excel - Tips and Tricks
by explorer (Chaplain) on May 28, 2007 at 15:43 UTC 
        $sheet->Cells( $y, $x )->Select();
    $Excel->ActiveWindow->{FreezePanes} = 1;

    [download]
[reply]
[d/l]

In Section Tutorials