Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

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

by ArmandoG (Sexton)
on Jan 25, 2008 at 00:56 UTC ( #664186=note: print w/ replies, xml ) Need Help??


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

this tutorial has being my foundation on the project at work thank you, since that said, I am a newbie in Win32::OLE I got this problem I need to copy a cell and cant do it this is the code I am using:

$Sheet->Range('A17')->Select(); $Sheet->Selection->Copy('A17'); $Sheet->Range('B15')->Select(); $Sheet->ActiveSheet->Paste();
but that did not work what is wrong? I take this from the VBA in the macro.
Oh. yes I am using only WIN32::OLE


Comment on Re: Using Win32::OLE and Excel - Tips and Tricks
Download Code
Re^2: Using Win32::OLE and Excel - Tips and Tricks
by Anonymous Monk on Jan 28, 2008 at 06:13 UTC
    Try if it works:

    $range1=$sheet->range('A17');

    $Sheet->copy($range1);

    $range2=$sheet->range('B15');

    $range2=$sheet->paste();

Re^2: Using Win32::OLE and Excel - Tips and Tricks
by HelenCr (Monk) on Dec 11, 2012 at 19:22 UTC

    This piece of code doesn't work because "Selection" is a method of the parent Excel application, not the sheet.

    So if you had, in the beginning of your code:

    my $XcelApp = Win32::OLE->new( 'Excel.Application' );

    Then the second line in your post should go:

    $XcelApp->Selection->Copy('A17');

    Helen

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (9)
As of 2015-07-06 16:25 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