Eric Gazoni's Blog

Daily thoughts for computer scientists

Month: October, 2011

openpyxl 1.5.6

Small compatibility release this time, no big features added, see the changelog by yourself:

  • [iter_worksheet] add support for calculated strings (they have a special data type for that ?)
  • [strings] make sure we always use unicode strings everywhere
  • [iter] fixed max row and column detection for iter reader
  • [styles] fixed custom number format detection under OOCalc
However, a large effort has been made on supporting the whole python 2.4 – 2.7 range. In the past, 2.4 and 2.5 compatibilities were damaged, now it should be restored back to normal.
Once again, thanks to all the contributors for their help ­čśë

openpyxl 1.5.5

After a long (long) break (sorry, I eventually bought a PS3, I knew this could happen), we come back with a new version of openpyxl !

This has been requested by a few people so here is a small changelog since the last (1.5.4 version):

  • Commented out the ‘scheme’ element as it appears to prevent the font┬áname from being applied in Excel.
  • [cell] added Decimal type as a numeric type (fixes #78)
  • [writer] added write support for wrapped text (fixes #65)
  • [cell] fixed the numeric regexp (fixes #77)
  • [cell] added encoding support for data input (fixes #76)
  • [excel(reader)] Added try except around loading workbook properties,┬áso that workbooks with no properties get the default properties
  • [date_time] Modified the re that deals with W3CDTF date format to┬áallow dates without an ending Z (fixes #73)
  • [cell] Altered the re for numeric in order to block out numbers with┬áleading zeroes (fixes #70)
  • [worksheet(writer)] fixed long number bug. using repr on a long┬ánumber causes it to return the number with L appended. Now using┬ástr() on long numbers
  • [dump] watching file descriptors to avoid a ‘too many open files’┬áerror when dumping a large number of worksheets

So, a lot of big fixes, such as file descriptors, numerical regexps and leading zeroes, and a few improvements, like encoding support.

I’m also very happy to see an ever-increasing number of contributors and of course users ­čÖé Thanks again everybody !

PS: special thanks to Yaroslav Halchenko for the late night licence checks ­čśë