Geek Answers Handbook

Python library for processing Excel files (xls | xlsx)

I need a python library that could read and write Excel files with all formats (e.g. xls and xlsx).

I am new to python and I used to use Java before. In Java, I used the POI , and it was perfect. I need a python library with the same functionality, if possible.

+4
source share
2 answers

I know this thread has been inactive for a while, but I thought it would be nice to add an answer here, since I made a new solution to this problem.

I had the same problem, so I went ahead and created a small library containing python-excel (xlrd, xlwt) and openpyxl in it . You can find it here: https://github.com/camyoung1234/spreadsheet

Then, to use it, enter the same code as openpyxl, except that you replace openpyxl with spreadsheet . When you download and save files, it looks at the extension and determines which library to use to process it.

To install it, just download it, extract it, rename the spreadsheet-master folder to spreadsheet and put it in PythonXX/Lib/site-packages/ (I tested only with Python 2.7, but it should work with others)

README has a few examples to help you get started.

+4
source

Python excel looks like go: http://www.python-excel.org/

OpenPyXl may also have the necessary functions: http://packages.python.org/openpyxl/

+1
source

More articles:


All Articles