[CentOS] excel parser (preferably perl)?
Les Mikesell
lesmikesell at gmail.comMon Oct 18 22:13:24 UTC 2010
- Previous message: [CentOS] Who maintains php-pgsql package? I want to ask about using PostgreSQL 8.4 library instead of PostgreSQL 8.1.
- Next message: [CentOS] excel parser (preferably perl)?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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. Needs to deal with both xls and xlsx formats, the odd characters that are confused with quotes even after csv conversion, numbers with $'s and commas embedded, excel's date formatting nonsense, etc. -- Les Mikesell lesmikesell at gmail.com
- Previous message: [CentOS] Who maintains php-pgsql package? I want to ask about using PostgreSQL 8.4 library instead of PostgreSQL 8.1.
- Next message: [CentOS] excel parser (preferably perl)?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list