Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^4: OLE module working 'part-time'

by Aim9b (Monk)
on Sep 25, 2007 at 15:08 UTC ( [id://640960]=note: print w/replies, xml ) Need Help??


in reply to Re^3: OLE module working 'part-time'
in thread OLE module working 'part-time'

That WOULD be a limitation, for sure. If we have MS Office on all the boxes, would you prefer one method over the other. Also, I'm leaning towards using Text::CSV, do you have any insight to that vs. Text::CSV_XS, Text::xSV, etc.? Thanks.

Replies are listed 'Best First'.
Re^5: OLE module working 'part-time'
by roboticus (Chancellor) on Sep 25, 2007 at 16:16 UTC
    I prefer the Spreadsheet module even when Office is available primarily because:

  • I don't have to worry about someone installing a different version that causes my code to fail.
  • Any mistakes I make won't leave a hung Office process running in the background.
  • I find the Spreadsheet module to be *quite* easy to use, and I don't find navigating the automation docs for Excel as simple.
  • My same code works on my Linux boxes as well as my WinTel boxes.
  • I have no experience with Text::CSV & friends. (I tend to process databases and fixed-format files.)

    ...roboticus

      Thanks, I really appreciate your input. Those are all great points.
      I'll look into it. That Office Upgrade part is waaaaay scary. ;-)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2024-04-26 00:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found