Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Move Columns in Excel

by padawan_linuxero (Scribe)
on Jan 15, 2008 at 23:34 UTC ( [id://662588]=perlquestion: print w/replies, xml ) Need Help??

padawan_linuxero has asked for the wisdom of the Perl Monks concerning the following question:

Hello!!
I am still working on this problem, but now something diferent, I need to move to 2 columns C and D, to N,O. for it I have this code done
$Sheet->Columns('C:D')->Select(); $Sheet->Selection->Cut({Destination => $Sheet->Columns('P:Q')});
But when run the script is saying this
Win32::OLE(0.1707) error 0x80020003: "Member not found" in METHOD/PROPERTYGET "" at test111.pl line 20 Can't call method "Move" on an undefined value at test111.pl line 20.
Why?

Replies are listed 'Best First'.
Re: Move Columns in Excel
by loris (Hermit) on Jan 16, 2008 at 07:32 UTC

    There are rather a lot of Excel modules out there. Perhaps you could tell us which one you are using.

    Update: OK, stumbling around the monastery, I found your other post, so I assume you are using Win32::OLE. However, it is still a good idea to be a little more explicit in your postings, especially if you don't link to related postings, which, in my opinion, you should.

    loris


    "It took Loris ten minutes to eat a satsuma . . . twenty minutes to get from one end of his branch to the other . . . and an hour to scratch his bottom. But Slow Loris didn't care. He had a secret . . ." (from "Slow Loris" by Alexis Deacon)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (2)
As of 2026-04-10 17:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    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.