Move Columns in Excel

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')});
[download]

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.
[download]

Why?

Comment on Move Columns in Excel Select or Download Code

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)	[reply]

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)

[reply]