On 01/28/2014 11:43 PM, Larry Martell wrote:
On Tue, Jan 28, 2014 at 5:37 PM, m.roth@5-cent.us wrote:
Larry Martell wrote:
On Tue, Jan 28, 2014 at 5:15 PM, m.roth@5-cent.us wrote:
Anyone know what package my user can use to read .xlsx files with python in CentOS 6?
I believe xlrd does.:
That's 0.9.2. I just installed the latest package from the usual repos, and it's python-xlrd-0.6.1-10.el6.noarch, and my user reports that doesn't work. Suprises me, that being from Excel 2007, and Libre Office reads it fine. I gave that suggestion to him as a workaround - import into LibreOffice, and export, but he's trying to automate this. I did see what seems to be a perl package, but he's working in python.
I think Libre Office can be run from command line, headless, and it can be scripted.
Also look at unoconv from RepoForge. I am not sure about .xlsx, .but working with .xls is possible. Maybe automatic conversion older standard then unoconv?