Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Inserting copied rows in Excel using Win32::OLE

by bmann (Priest)
on Aug 29, 2004 at 00:53 UTC ( [id://386676]=note: print w/replies, xml ) Need Help??


in reply to Inserting copied rows in Excel using Win32::OLE

Passing the parameters to Insert as an anonymous hashref (as mentioned in Re: Inserting copied rows in Excel using Win32::OLE) is half the battle.

The second problem is quoting 'xlDown'. You don't show where xlDown is defined in your code. If you are defining it as a Constant or importing it via Win32::OLE::Const then drop the quotes and it will work as expected. If you aren't defining xlDown in your script, you'll need to use whatever number xlDown means to Excel.

Personally, I'd import the constants from Excel's typelib with use Win32::OLE::Const 'Microsoft Excel';.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (2)
As of 2024-04-25 21:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found