[wplug] Automate conversion from Excel to text in Linux

[Embery, Nathan]

I was just looking into doing this last week. The best thing I found was the
DBD::Excel perl module. It'll let you perform sql queries over the excel
sheet just like a DB, and if your familiar with the perl DBI at all, it
should be a breeze.
The only drawback is that this is pretty slow. It takes several minutes to
connect to the excel DB with ~3000 rows. ymmv.
You also have to track down a lot of modules to get it working. I think all
I had to get were: IO-stringy, parse-excel, write-excel, dbi, dbd-excel,
parse-recdescent, ole-storage, and sql-statement. 

Nate

-----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? I'd like to
automate a process that we have where we use excel to convert a spreadsheet
to text and then transfer the text file from the M$ system to a Linux box.
We'd like to transfer the excel file, in binary, from the M$ system and then
convert it on the Linux box rather than autmating the conversion on the M$
side.

Any help or suggestions would be appreciated.

Thanks,
Scott
_______________________________________________
wplug mailing list
wplug at wplug.org
http://www.wplug.org/mailman/listinfo/wplug