Anyone know what package my user can use to read .xlsx files with python in CentOS 6?
mark
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.:
On 1/28/2014 2:24 PM, 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.:
I suspect any such package will just read data on the sheet... interpreting excels formulas, database links, active X embedded objects, graphs, VBA macros, etc etc would likely be insane.
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.
mark
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 was able to install 0.9.2 with:
pip install xlrd
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?
-
John R Pierce -
Larry Martell -
Ljubomir Ljubojevic -
m.roth＠5-cent.us