On Tue, Oct 19, 2010 at 12:13 AM, Les Mikesell lesmikesell@gmail.com wrote:
I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or maybe a scripted OpenOffice conversion would be possible.
No idea about the csv from excel, but I have had good experiences with Text::CSV_XS.