Openpyxl 1.6.2 has been released

Hello, this blog has moved to here : http://blog.ericgazoni.me, 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 !

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s