excel parser (preferably perl)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux