[wplug] Automate conversion from Excel to text in Linux

Eric C. Cooper ecc at cmu.edu
Wed Feb 4 14:38:40 EST 2004


On Wed, Feb 04, 2004 at 02:25:58PM -0500, Embery, Nathan wrote:
> -----Original Message-----
> From: Scott Eicher [mailto:Scott.Eicher at e-profile.com]
> Sent: Wednesday, February 04, 2004 1:53 PM
> To: WPLUG Mailing List (E-mail)
> Subject: [wplug] Automate conversion from Excel to text in Linux
> 
> Does anyone have a script or have any suggestions on how to automate the
> conversion of an excel spreadsheet to plain text in Linux?
> -----Original Message-----
> 
> I was just looking into doing this last week. The best thing I found was the
> DBD::Excel perl module.

You might not need the full-blown DBI interface.  It looks like
Spreadsheet::ParseExcel::Simple (or the more general
Spreadsheet::ParseExcel) might suffice.  See:
  http://search.cpan.org/~tmtm/Spreadsheet-ParseExcel-Simple-1.01/Simple.pm

-- 
Eric C. Cooper          e c c @ c m u . e d u



More information about the wplug mailing list