2.2.4 (2015-06-17) ================== Bug fixes --------- * `#464 `_ Cannot use images when preserving macros * `#465 `_ ws.cell() returns an empty cell on read-only workbooks * `#467 `_ Cannot edit a file with ActiveX components * `#471 `_ Sheet properties elements must be in order * `#475 `_ Do not redefine class __slots__ in subclasses * `#477 `_ Write-only support for SheetProtection * `#478 `_ Write-only support for DataValidation * Improved regex when checking for datetime formats 2.2.3 (2015-05-26) ================== Bug fixes --------- * `#451 `_ fitToPage setting ignored * `#458 `_ Trailing spaces lost when saving files. * `#459 `_ setup.py install fails with Python 3 * `#462 `_ Vestigial rId conflicts when adding charts, images or comments * `#455 `_ Enable Zip64 extensions for all versions of Python 2.2.2 (2015-04-28) ================== Bug fixes --------- * `#447 `_ Uppercase datetime number formats not recognised. * `#453 `_ Borders broken in shared_styles. 2.2.1 (2015-03-31) ================== Minor changes ------------- * `PR54 `_ Improved precision on times near midnight. * `PR55 `_ Preserve macro buttons Bug fixes --------- * `#429 `_ Workbook fails to load because header and footers cannot be parsed. * `#433 `_ File-like object with encoding=None * `#434 `_ SyntaxError when writing page breaks. * `#436 `_ Read-only mode duplicates empty rows. * `#437 `_ Cell.offset raises an exception * `#438 `_ Cells with pivotButton and quotePrefix styles cannot be read * `#440 `_ Error when customised versions of builtin formats * `#442 `_ Exception raised when a fill element contains no children * `#444 `_ Styles cannot be copied 2.2.0 (2015-03-11) ================== Bug fixes --------- * `#415 `_ Improved exception when passing in invalid in memory files. 2.2.0-b1 (2015-02-18) ===================== Major changes ------------- * Cell styles deprecated, use formatting objects (fonts, fills, borders, etc.) directly instead * Charts will no longer try and calculate axes by default * Support for template file types - PR21 * Moved ancillary functions and classes into utils package - single place of reference * `PR 34 `_ Fully support page setup * Removed SAX-based XML Generator. Special thanks to Elias Rabel for implementing xmlfile for xml.etree * Preserve sheet view definitions in existing files (frozen panes, zoom, etc.) Bug fixes --------- * `#103 `_ Set the zoom of a sheet * `#199 `_ Hide gridlines * `#215 `_ Preserve sheet view setings * `#262 `_ Set the zoom of a sheet * `#392 `_ Worksheet header not read * `#387 `_ Cannot read files without styles.xml * `#410 `_ Exception when preserving whitespace in strings * `#417 `_ Cannot create print titles * `#420 `_ Rename confusing constants * `#422 `_ Preserve color index in a workbook if it differs from the standard Minor changes ------------- * Use a 2-way cache for column index lookups * Clean up tests in cells * `PR 40 `_ Support frozen panes and autofilter in write-only mode * Use ws.calculate_dimension(force=True) in read-only mode for unsized worksheets 2.1.5 (2015-02-18) ================== Bug fixes --------- * `#403 `_ Cannot add comments in write-only mode * `#401 `_ Creating cells in an empty row raises an exception * `#408 `_ from_excel adjustment for Julian dates 1 < x < 60 * `#409 `_ refersTo is an optional attribute Minor changes ------------- * Allow cells to be appended to standard worksheets for code compatibility with write-only mode. 2.1.4 (2014-12-16) ================== Bug fixes --------- * `#393 `_ IterableWorksheet skips empty cells in rows * `#394 `_ Date format is applied to all columns (while only first column contains dates) * `#395 `_ temporary files not cleaned properly * `#396 `_ Cannot write "=" in Excel file * `#398 `_ Cannot write empty rows in write-only mode with LXML installed Minor changes ------------- * Add relation namespace to root element for compatibility with iWork * Serialize comments relation in LXML-backend 2.1.3 (2014-12-09) ================== Minor changes ------------- * `PR 31 `_ Correct tutorial * `PR 32 `_ See #380 * `PR 37 `_ Bind worksheet to ColumnDimension objects Bug fixes --------- * `#379 `_ ws.append() doesn't set RowDimension Correctly * `#380 `_ empty cells formatted as datetimes raise exceptions 2.1.2 (2014-10-23) ================== Minor changes ------------- * `PR 30 `_ Fix regex for positive exponentials * `PR 28 `_ Fix for #328 Bug fixes --------- * `#120 `_, `#168 `_ defined names with formulae raise exceptions, `#292 `_ * `#328 `_ ValueError when reading cells with hyperlinks * `#369 `_ IndexError when reading definedNames * `#372 `_ number_format not consistently applied from styles 2.1.1 (2014-10-08) ================== Minor changes ------------- * PR 20 Support different workbook code names * Allow auto_axis keyword for ScatterCharts Bug fixes --------- * `#332 `_ Fills lost in ConditionalFormatting * `#360 `_ Support value="none" in attributes * `#363 `_ Support undocumented value for textRotation * `#364 `_ Preserve integers in read-only mode * `#366 `_ Complete read support for DataValidation * `#367 `_ Iterate over unsized worksheets 2.1.0 (2014-09-21) ================== Major changes ------------- * "read_only" and "write_only" new flags for workbooks * Support for reading and writing worksheet protection * Support for reading hidden rows * Cells now manage their styles directly * ColumnDimension and RowDimension object manage their styles directly * Use xmlfile for writing worksheets if available - around 3 times faster * Datavalidation now part of the worksheet package Minor changes ------------- * Number formats are now just strings * Strings can be used for RGB and aRGB colours for Fonts, Fills and Borders * Create all style tags in a single pass * Performance improvement when appending rows * Cleaner conversion of Python to Excel values * PR6 reserve formatting for empty rows * standard worksheets can append from ranges and generators Bug fixes --------- * `#153 `_ Cannot read visibility of sheets and rows * `#181 `_ No content type for worksheets * `241 `_ Cannot read sheets with inline strings * `322 `_ 1-indexing for merged cells * `339 `_ Correctly handle removal of cell protection * `341 `_ Cells with formulae do not round-trip * `347 `_ Read DataValidations * `353 `_ Support Defined Named Ranges to external workbooks 2.0.5 (2014-08-08) ================== Bug fixes --------- * `#348 `_ incorrect casting of boolean strings * `#349 `_ roundtripping cells with formulae 2.0.4 (2014-06-25) ================== Minor changes ------------- * Add a sample file illustrating colours Bug fixes --------- * `#331 `_ DARKYELLOW was incorrect * Correctly handle extend attribute for fonts 2.0.3 (2014-05-22) ================== Minor changes ------------- * Updated docs Bug fixes --------- * `#319 `_ Cannot load Workbooks with vertAlign styling for fonts 2.0.2 (2014-05-13) ================== 2.0.1 (2014-05-13) brown bag ============================= 2.0.0 (2014-05-13) brown bag ============================= Major changes ------------- * This is last release that will support Python 3.2 * Cells are referenced with 1-indexing: A1 == cell(row=1, column=1) * Use jdcal for more efficient and reliable conversion of datetimes * Significant speed up when reading files * Merged immutable styles * 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 * Lower memory footprint when reading files Minor changes ------------- * All tests converted to pytest * Pyflakes used for static code analysis * Sample code in the documentation is automatically run * Support GradientFills * BaseColWidth set Pull requests ------------- * #70 Add filterColumn, sortCondition support to AutoFilter * #80 Reorder worksheets parts * #82 Update API for conditional formatting * #87 Add support for writing Protection styles, others * #89 Better handling of content types when preserving macros Bug fixes --------- * `#46 `_ ColumnDimension style error * `#86 `_ reader.worksheet.fast_parse sets booleans to integers * `#98 `_ Auto sizing column widths does not work * `#137 `_ Workbooks with chartsheets * `#185 `_ Invalid PageMargins * `#230 `_ Using \v in cells creates invalid files * `#243 `_ - IndexError when loading workbook * `#263 `_ - Forded conversion of line breaks * `#267 `_ - Raise exceptions when passed invalid types * `#270 `_ - Cannot open files which use non-standard sheet names or reference Ids * `#269 `_ - Handling unsized worksheets in IterableWorksheet * `#270 `_ - Handling Workbooks with non-standard references * `#275 `_ - Handling auto filters where there are only custom filters * `#277 `_ - Harmonise chart and cell coordinates * `#280 `_- Explicit exception raising for invalid characters * `#286 `_ - Optimized writer can not handle a datetime.time value * `#296 `_ - Cell coordinates not consistent with documentation * `#300 `_ - Missing column width causes load_workbook() exception * `#304 `_ - Handling Workbooks with absolute paths for worksheets (from Sharepoint) 1.8.6 (2014-05-05) ================== Minor changes ------------- Fixed typo for import Elementtree Bugfixes -------- * `#279 `_ Incorrect path for comments files on Windows 1.8.5 (2014-03-25) ================== Minor changes ------------- * The '=' string is no longer interpreted as a formula * When a client writes empty xml tags for cells (e.g. ), reader will not crash 1.8.4 (2014-02-25) ================== Bugfixes -------- * `#260 `_ better handling of undimensioned worksheets * `#268 `_ non-ascii in formualae * `#282 `_ correct implementation of register_namepsace for Python 2.6 1.8.3 (2014-02-09) ================== Major changes ------------- Always parse using cElementTree Minor changes ------------- Slight improvements in memory use when parsing * `#256 `_ - error when trying to read comments with optimised reader * `#260 `_ - unsized worksheets * `#264 `_ - only numeric cells can be dates 1.8.2 (2014-01-17) ================== * `#247 `_ - iterable worksheets open too many files * `#252 `_ - improved handling of lxml * `#253 `_ - better handling of unique sheetnames 1.8.1 (2014-01-14) ================== * `#246 `_ 1.8.0 (2014-01-08) ================== Compatibility ------------- Support for Python 2.5 dropped. Major changes ------------- * Support conditional formatting * Support lxml as backend * Support reading and writing comments * pytest as testrunner now required * Improvements in charts: new types, more reliable Minor changes ------------- * 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 1.7.0 (2013-10-31) ================== Major changes ------------- Drops support for Python < 2.5 and last version to support Python 2.5 Compatibility ------------- Tests run on Python 2.5, 2.6, 2.7, 3.2, 3.3 Merged pull requests -------------------- * 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 Known bugfixes -------------- * `#109 `_ * `#165 `_ * `#179 `_ * `#209 `_ * `#112 `_ * `#166 `_ * `#109 `_ * `#223 `_ * `#124 `_ * `#157 `_ Miscellaneous ------------- Performance improvements in optimised writer Docs updated