Perl-Sensitive Sunglasses | |
PerlMonks |
comment on |
( [id://3333]=superdoc: 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 reply to Re: Inserting copied rows in Excel using Win32::OLE
by jmcnamara
|
|