[CentOS] excel parser (preferably perl)?
Bill Campbell
centos at celestial.com
Mon Oct 18 22:33:46 UTC 2010
On Mon, Oct 18, 2010, Les Mikesell 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.
>
>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.
I don't do much perl these days, having switched to python for
most of my stuff.
There is at least one python package for this:
http://pypi.python.org/pypi/xlrd
A google search on ``python excel reader'' came up with quite a
few hits.
Of course there are easy python dbi interfaces to mysql, postgresql, and
other SQL databases as well.
Bill
--
INTERNET: bill at celestial.com Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/ PO Box 820; 6641 E. Mercer Way
Voice: (206) 236-1676 Mercer Island, WA 98040-0820
Fax: (206) 232-9186 Skype: jwccsllc (206) 855-5792
It is practically impossible to teach good programming style to
students that have had prior exposure to BASIC: as potential
programmers they are mentally mutilated beyond hope of
regeneration. -- Dijkstra
More information about the CentOS
mailing list