Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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

by Anonymous Monk
on Jun 25, 2002 at 18:21 UTC ( [id://177161]=note: print w/replies, xml ) Need Help??


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

In fact, my problem is more about Excel rather than perl (I think).
I was wondering if there is an option so when my perl program update a value in a cell I can see it immediately in Excel (the file is always open on my desktop)
  • Comment on Re: Re: Re: Using Win32::OLE and Excel - Tips and Tricks

Replies are listed 'Best First'.
Re:(4) Using Win32::OLE and Excel - Tips and Tricks
by cacharbe (Curate) on Jun 25, 2002 at 19:22 UTC
    If its always open on your desktop, make sure that you are only using the current, open instance of Excel, set your worksheet=ActiveSheet and don't close the worksheet or workbook before terminating your script.
    my $Excel = Win32::OLE->GetActiveObject('Excel.Application')|| die "You gotta have it open first!!\n"; my $Sheet = $Excel->{ActiveSheet};

    C-.

    ---
    Flex the Geek

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://177161]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2025-07-11 06:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.