[CentOS] Reading .xlsx files with python?

Wed Jan 29 01:09:10 UTC 2014
Ljubomir Ljubojevic <centos at plnet.rs>

On 01/28/2014 11:43 PM, Larry Martell wrote:
> On Tue, Jan 28, 2014 at 5:37 PM,  <m.roth at 5-cent.us> wrote:
>> Larry Martell wrote:
>>> On Tue, Jan 28, 2014 at 5:15 PM,  <m.roth at 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.:
>>>
>>> https://pypi.python.org/pypi/xlrd/0.9.2
>>
>> 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?


-- 
Ljubomir Ljubojevic
(Love is in the Air)
PL Computers
Serbia, Europe

StarOS, Mikrotik and CentOS/RHEL/Linux consultant