- Type inference is disabled by default
- RawCell renamed ReadOnlyCell
- ReadOnlyCell.internal_value and ReadOnlyCell.value now behave the same as Cell
- Provide no size information on unsized worksheets
- All tests converted to pytest
- Pyflakes used for static code analysis
#70 Add filterColumn, sortCondition support to AutoFilter #82 Update API for conditional formatting #87 Add support for writing Protection styles, others #89 Better handling of content types when preserving macros
#46 - ColumnDimension style error #137 - Workbooks with chartsheets #269 - Handling unsized worksheets in IterableWorksheet #275 - Handling auto filters where there are only custom filters
#260 better handling of undimensioned worksheets #268 non-ascii in formualae #282 correct implementation of register_namepsace for Python 2.6
Always parse using cElementTree
Slight improvements in memory use when parsing
Bugfix #256 - error when trying to read comments with optimised reader Bugfix #260 - unsized worksheets Bugfix #264 - only numeric cells can be dates
Bugfix #247 - iterable worksheets open too many files Bugfix #252 - improved handling of lxml Bugfix #253 - better handling of unique sheetnames
Bugfix #246
Support for Python 2.5 dropped.
- Support conditional formatting
- Support lxml as backend
- Support reading and writing comments
- pytest as testrunner now required
- Improvements in charts: new types, more reliable
- load_workbook now accepts data_only to allow extracting values only from
formulae. Default is false. * Images can now be anchored to cells * Docs updated * Provisional benchmarking * Added convenience methods for accessing worksheets and cells by key
Drops support for Python < 2.5 and last version to support Python 2.5
Tests run on Python 2.5, 2.6, 2.7, 3.2, 3.3
#27 Include more metadata #41 Able to read files with chart sheets #45 Configurable Worksheet classes #3 Correct serialisation of Decimal #36 Preserve VBA macros when reading files #44 Handle empty oddheader and oddFooter tags #43 Fixed issue that the reader never set the active sheet #33 Reader set value and type explicitly and TYPE_ERROR checking #22 added page breaks, fixed formula serialization #39 Fix Python 2.6 compatibility #47 Improvements in styling
#109 #165 #179 #209 #112 #166 #109 #223 #124 #157
Performance improvements in optimised writer
Docs updated