Openpyxl 1.6.2 has been released

Hello, this blog has moved to here :, the blog on WordPress will be kept not to break links, but will not be updated anymore, see you there !

This is the first post-sickness release of the year ! \o/

Major changes include :

  • bugfixes (many)
  • improved documentation
  • new image inclusion support, using optional dependency on PIL
  • improved robustness for the charts module (still a work in progress, due to the size of the module)
  • data validation module

Once again, this is the release with the most external contributions so far, I’m really happy to see people interested in making the library go further, and providing such quality code, with tests and even documentation. I can’t thank you enough.

However, several pull request remain open, for various reasons from difficulty to merge with the current state of the code, to open question on the benefits of the change. Anyway, if a pull request didn’t make it into this release, it will probably be in the next ๐Ÿ˜‰

Thank you as well for reporting issues you find on the bug tracker, the issues keep piling up so I still need as much help as possible to solve them, but that also means people are using the library ๐Ÿ˜‰

I have now decided to stop using the Bitbucket Wiki page and instead use the ReadTheDocs documentation mini-site, which is better structured and more readable. I tried for a few hours to hide the wiki page, but it was only causing errors while installing openpyxl using pip, so I reverted my change and the wiki is still online for the moment, but won’t be updated anymore.

Here it is, don’t hesitate to give it a try and report errors if you find any ๐Ÿ˜‰

Happy coding !

5 responses to “Openpyxl 1.6.2 has been released

  1. Hi,
    Congrats on getting better ! and thank you for your great work! Openpyxl has been such a great help ! =D. However i do face a problem of Openpyxl consuming too much memory (some 500K rows by 30columns with coloring =\). I could not use optimize writer as i need random access to the cells and the styling of the cells. Is there anything that I can do yet ?

    • Hi ! Unfortunately, there is no easy fix for you, as handling large amounts of data is precisely why I made the optimized writer in the first place ๐Ÿ™‚
      There is a very old planned improvement regarding styles, but well, having to handle styling + large data is pretty uncommon, so I haven’t spent much time on it yet, sorry.

      • Oh well, guess I’ll have to find some way to work around. Once again, thank you very much ! =D

  2. Eric Gazoni.. congrats for Openpyxl 1.6.2 !!

    so.. I have a question.. and don’t know where to do ..
    Is about optimized read/write mode…
    So.. Is it possible to modifty..edit some file using that mode ?

    Like.. put some values in an existing xlsx file ?

    tks a lot

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s