It has been almost one full year since I started this project, and it has now reached a state where it is well suited for production, and intensively tested by an increasing number of people around the globe.
The most recent additions I’m the most proud of are the optimized reader and writer, that become stable in this version. It took around 6 months to get them working properly (the reader was the hardest actually), and now they’re here !
You can read and write workbooks of any size, with low and almost constant memory consumption (which is not the case with Excel actually).
I’m also really happy that people keep sending patches and asking for features, so the project continues to live, even when I’m not fully available to work on it.
You can get the latest version of openpyxl either with easy_install:
easy_install openpyxl
or from the official website.
7 responses to “openpyxl 1.5.0 released”
Eric,
I am able to get a style from a cell but I am unable to set a style for a cell.
How do you do this? I tried to assign a value to
cell.style
but it looks like a read-only value.
Brad Zoltick
Hi Brad,
actually .style is a property (see http://packages.python.org/openpyxl/_modules/openpyxl/cell.html#Cell.style)
To change the style, you need to change the style attributes instead of the style itself. I’ll make a new tutorial on how to change different styles soon. In the meantime, you can still browse the code and try to tinker with it (see https://bitbucket.org/ericgazoni/openpyxl/src/bb2891e7d81a/openpyxl/style.py).
thanks so much for you efforts, I use this lib extensively in my project, I wonder if there will be python3 version ? thanks again
Davy, a python 3 version is planned, but unfortunately I don’t have much time those days to work on openpyxl, so it will have to wait a few days 🙂 Heikki Junes has a 2.7-3.x branch, but I don’t think it’s ready for production yet. You may want to check with him if you’re in a hurry, or wait a little bit until I make the needed changes in the main branch 😉
Hi,
I’ve been using openpyxl for about 2 weeks and I’ve used it to automate some very tedious spreadsheet building. It saves tons of manhours and prevents mistakes!
Thanks very much for writing it!
Thanks for your support Jeff ! 🙂
Hello Eric,
Thank you very much for your effort concerning the
development of “openpyxl”. I’m using it for almost
6 months now and I’m quiet happy.
I have a question: how can I get the number of columns that
a certain cell expands (i.e. merges)? I didn’t manage to
get this from the current documentation. Is it available
or do you plan to implement it soon?
Thank you. Best regards,
F.