ANN: Openpyxl 3.1 released

63 views
Skip to first unread message

Charlie Clark

unread,
Jan 31, 2023, 10:12:48 AM1/31/23
to openpyxl-users

Dear all,

I'm pleased to announce that Openpyxl 3.1 has finally been released. It's been a long time coming, I know, but a lot of stuff was happening away from the keyboard which made it difficult to put the finishing touches to the release.

Along with bug fixes, 3.1 contains lots of changes in detail such as removal of long deprecated attributes.

It also contains several new features:

  • support for "data table" formulae and improved support for array formulae
  • support for rich text in cells
  • support for custom document properties
  • improved support for Pandas data frames
  • improved support for defined names
  • more informative error reporting when workbooks can't be loaded.

Full details https://openpyxl.readthedocs.io/en/3.1.0/changes.html

Many thanks to those who have contributed to the development through pull requests or by sponsoring features. Much of the recent development of the library has been made possible by commercial sponsorship. Do get in touch if there are features that you'd like to see in the library or if you require professional support.

Thanks also to Octobus (https://octobus.net/) for providing hosting for the project.

Work on 3.2 started a while ago and includes significant improvements in the handling of macros, ActiveX elements and drawings, which is hopefully good news for those who rely on Excel files in their workflows.

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

Reply all
Reply to author
Forward
0 new messages