Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^2: Xlxs Parsing Issue

by dasgar (Deacon)
on Nov 08, 2013 at 00:50 UTC ( #1061649=note: print w/ replies, xml ) Need Help??


in reply to Re: Xlxs Parsing Issue
in thread Xlxs Parsing Issue

On one hand, I agree with you and I personally prefer to use Win32::OLE to control Excel when trying to manipulate Excel files when on a Windows system that has Excel installed.

However, I would urge caution about leveraging macros, which is what I think that you're referring to when you mention "VB script". To make a long story short, apparently there was a situation at my job some time prior to when I started where a macros in an Excel file got infected by a virus and was deleting "random" files on our file server whenever that macros was run. I don't have all of the details on what happened there. Also, there's a reason that Microsoft's latest versions of Office has macros disabled by default.

Not disagreeing with you on anything, but just wanted to pass on a word of caution.


Comment on Re^2: Xlxs Parsing Issue
Re^3: Xlxs Parsing Issue
by Anonymous Monk on Nov 08, 2013 at 00:55 UTC
    That word of caution applies to any and every file on windows -- they're all attack vector -- every file is executable

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2014-10-22 04:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (112 votes), past polls