Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^3: Copy paste rows in excel

by imrags (Monk)
on Jul 21, 2009 at 09:06 UTC ( #781893=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Copy paste rows in excel
in thread Copy paste rows in excel

As I said, think how you'll do it manually and make perl do it.

$Sheet->rows('4:4')->copy(); $Sheet->rows('15:15')->Select(); $Sheet->paste();
The above code copies 4th row cells to 15th row cells.
Raghu


Comment on Re^3: Copy paste rows in excel
Download Code
Re^4: Copy paste rows in excel
by Ankit.11nov (Acolyte) on Jul 21, 2009 at 09:36 UTC
    Thanks again Raghu. Its working :)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2015-07-06 06:29 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 (70 votes), past polls