laziness, impatience, and hubris | |
PerlMonks |
Re: Inserting copied rows in Excel using Win32::OLEby jmcnamara (Monsignor) |
on Aug 29, 2004 at 00:10 UTC ( [id://386669]=note: print w/replies, xml ) | Need Help?? |
The correct syntax should probably be (note the anonymous hash ref): However, I've tried this and it doesn't work. I don't know why, perhaps xlDown is superfluous in the context of a row range. As a workaround, if you use the Insert() method without parameters it will give the desired effect of shifting the rows down:
Update: bmann got it below, ++. In addition to the hashref xlDown is an imported constant and shouldn't be quoted. The following works:
--
In Section
Seekers of Perl Wisdom
|
|