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

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

In Section Seekers of Perl Wisdom