ANN: Openpyxl 3.1.4 released
Charlie Clark
Hi everybody,
it's been a while but I'm pleased to announce that Openpyxl 3.1.4 has been released.
Before I get to the release notes some housekeeping: the team behind the platform Read The Docs decided earlier this year to drop support for Mercurial, which we and other projects use to manage our code. It's their decision which we have to respect even if we don't really understand it: it already worked and required little maintenance. Furthermore, if open source is about anything, it is about choice. We choose to use Python, we choose to use Openpyxl, we choose our browser, computer system, mobile phone and, we even choose our VCS (Version Control System). Unfortunately, to me at the moment it looks like a lot of developers are turning their backs on choice and moving towards a monoculture that is likely to be dominated by one or two providers.
We're still working out how to deal with the change but have at least a solution for the moment. Documentation will now be available at https://openpyxl.pages.heptapod.net/openpyxl/
And so to the release. 3.1.3 contains the most changes with 3.1.4 containing an important fix for a regression on the use of named styles.
Some of the most important changes:
- File handlers are released on Windows in read-only mode. This was due to a change in Python itself
- Rich-text can be saved even if lxml is not installed
- Non-numerical filters can be read. And anyone who writes filters should check out the new API
- Reading workbooks with lots of pivot tables or custom properties can be very slow
- Start up time and memory use have been improved
- Support for Python 3.6 and 3.7 has been dropped. The library should still work but is no longer being tested against these versions and pip will, by default, not allow you to install Openpyxl ≥ 3.1.3 on them.
- Openpyxl is more tolerant of some of the files that LibreOffice produces which often have some confusing stylesheet definitions.
The full list of changes is in the release notes:
https://openpyxl.pages.heptapod.net/openpyxl/changes.html
Thanks to those who contributed to this release! Some interesting work is being done on the 3.2 branch and special thanks to Liam Sanders (@snippet) for taking on some grunt work and patiently listening to my feedback.
Hope you enjoy it!
Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Sengelsweg 34
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226