Cross-platform way to read Excel files in Python?

Question

I have (Excel 2000) workbooks. I want to extract the data in each sheet into a separate file.

I work on Linux.

Is there a library that I can use to access (read) XLS files on Linux from Python?

Answer 1

http://www.lexicon.net/sjmachin/xlrd.htm may work for you.

Answer 2

Get xlrd from PyPI . Also go to the python-excel website to learn about (a) the tutorial (b) discussion group (c) xlwtand xlutils.

[Dis]: xlrd xlwt ( pyExcelerator ).

Answer 3

The easiest way is to run excel under Wine or as a virtual machine and do it from Windows. You can use the COM Mark Hammond bindings that ship with ActiveState Python. In addition, you can export data in CSV format and read them from it.

Answer 4

I have used pyexcelerator for this purpose in the past with good results.