Beefy Boxes and Bandwidth Generously Provided by pair Networks Bob
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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

by pinguxx (Initiate)
on Nov 26, 2005 at 01:33 UTC ( [id://511836]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


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 11:43 UTC
    $sheet->Cells( $y, $x )->Select(); $Excel->ActiveWindow->{FreezePanes} = 1;

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://511836]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.