Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Using Win32::OLE and Excel - Tips and Tricks

by Anonymous Monk
on Sep 12, 2007 at 21:09 UTC ( [id://638681]=note: print w/replies, xml ) Need Help??


in reply to Using Win32::OLE and Excel - Tips and Tricks

After 2 weeks of losing hair and sleep, this one article shows enough detail for me to move past 'hanging open' excel files and several other issues. I'm writing a tool that has to scan several hundred XLS files in a swamp of folders and extract specific data. Thank you for writing this article, my program will behave so much better for it.
I noticed your request for handling square brackets and other strange animals in links. Just use the hex representation for them, as in www.badly%5Bformed_url%5D.as.only.MS.can.do

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (2)
As of 2025-07-15 04:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.