Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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

by Anonymous Monk
on Jun 25, 2002 at 18:21 UTC ( #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
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
Node Status?
node history
Node Type: note [id://177161]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (12)
As of 2015-07-06 15:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (77 votes), past polls