./textproc/py-openpyxl, Python library to read/write Excel xlsx/xlsm files

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 3.1.2, Package name: py310-openpyxl-3.1.2, Maintainer: kamelderouiche

openpyxl is a pure python reader and writer of Excel OpenXML files.

It was born from lack of existing library to read/write natively from
Python the new Office Open XML format. All kudos to the PHPExcel team
as openpyxl is a Python port of PHPExcel http://www.phpexcel.net/


Required to run:
[textproc/py-lxml] [lang/python310]

Master sites:

Filesize: 181.618 KB

Version history: (Expand)


CVS history: (Expand)


   2023-03-17 09:22:07 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-openpyxl: updated to 3.1.2

3.1.2
Cannot read worksheets in read-only mode with locally scoped definitions
Empty custom properties cause invalid files
   2023-02-22 13:50:46 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-openpyxl: updated to 3.1.1

3.1.1 (2023-02-13)

Bugfixes

* DocumentProperties times set by module import only
* Worksheet-specific definitions are missing

3.1.0 (2023-01-31)

New Features

Added support for data table formulae
Mapped chartspace graphical properties to charts for advanced formatting

Bugfixes

* Table filters are always overriden
* Can’t read some ScatterCharts if n
* Problem with multilevel indices in dataframes
* Problem with category indices in dataframes
* NamedStyles share attributes - mutables gotcha
* Allow print area to be set to None
* Worksheet for print title and print areas can’t be found
* Custom document properties that are strings can be empty
* ConditionalFormatting lost when pivot table updated
* Better handling of defined names
* dataframe_to_rows() misalignment on multiindex
* Ditto
* Excel doesn’t like xmlns:space on nodes with only whitespace, which it \ 
treats as empty.
* Exception when print areas use table references.

Pull Requests

Support for Rich Text in cells
Provide more information when workbook cannot be loaded
Support for Custom Document Properties

Deprecations

The following properties have been removed from worksheets: formula_attributes, \ 
page_breaks, show_summary_below, show_summary_right, page_size orientation. \ 
Client code should use the relevant objects.

Removals

The following deprecated methods have been removed from workbooks: \ 
get_named_range, add_named_range, remove_named_range. And the get_emu_dimesions \ 
from images.
   2022-11-29 17:31:53 by Adam Ciarcinski | Files touched by this commit (1)
Log message:
py-openpyxl: put correct DEPENDS
   2022-11-29 11:20:57 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
py-openpyxl: updated to 3.0.10

3.0.10 (2021-05-13)

Bugfixes

* Image files not closed when workbooks are saved
* Problem with missing scope attribute in Pivot Table formats
* Excel unhappy when multiple sorts are defined

3.0.9 (2021-09-22)

Bugfixes

* Ignore blank ignored in existing Data Validations
* Add support for cell protection for merged cell ranges
* Timezone-aware datetimes raise an Exception
* Improved normalisation of chart series
* Catch OverflowError for out of range datetimes
* Alignment.relativeIndent can be negative
* Incorrect default value groupBy attribute

3.0.8 (brown bag)

Deleted because it contained breaking changes from 3.1

3.0.7 (2021-03-09)

Bugfixes

* Problems with zero time values
* Not possible to correctly convert excel dates to timedelta
* Exception raised when merging cells which do not have borders all the way round.
* Python 2 print statement in the tutorial

Pull Requests

* Add documentation on datetime handling
* Drop dependency on jdcal
* Datetime rounding
* Unify handling of 1900 epoch
* Add explicit support for reading datetime deltas
* Millisecond precision for datetimes

3.0.6 (2021-01-14)

Bugfixes

* Borders in differential styles are incorrect
* Error when opening some pivot tables
* Resave breaks the border format in conditional formatting rules
* Read-only workbook not closed properly if generator interrupted
* Pandas.Multiindex.labels deprecated
* Pandas.Multiinex not expanded correctly
* Cannot read rows with exponents
* numpy.float is deprecated
* Cells without coordinate attributes not always correctly handled

Pull Requests

* Improved handling of borders for differential styles
* Support subclasses of datetime objects
* Improved handling of cells without coordinates

3.0.5 (2020-08-21)

Bugfixes

* Incorrectly consider currency format as datetime
* Cannot copy worksheets with merged cells
* Empty worksheets do not return generators when looping.
* Hyperlinks duplicated on multiple saves
* Incorrectly literal format as datetime
* Links set to range of cells not preserved
* Exception when opening workbook with chartsheets and tables

3.0.4 (2020-06-24)

Bugfixes

* Find tables by name
* Worksheet protection missing in existing files
* Exception when reading files with external images
* Reading lots of merged cells is very slow.
* Read support for Bubble Charts.
* Preserve any indexed colours
* Reading many thousand of merged cells is really slow.
* Adding tables in write-only mode raises an exception.

Pull Requests

* Add support for finding tables by name or range.

3.0.3 (2020-01-20)

Bugfixes

* Exception when handling merged cells with hyperlinks
* Problems when both lxml and defusedxml are installed
* CFVO with incorrect values cannot be processed

3.0.2 (2019-11-25)

Bug fixes

* DeprecationError if both defusedxml and lxml are installed
* ws._current_row is higher than ws.max_row
* Border bottom style is not optional when it should be
* Empty cells in read-only, values-only mode are sometimes returned as ReadOnlyCells
* Cannot add page breaks to existing worksheets if none exist already

Pull Requests

* Improvements to the documentation

3.0.1 (2019-11-14)

Bugfixes

* Cannot read empty charts.

Pull Requests

* Fix for 1250
* TableStyleElement is a sequence

3.0.0 (2019-09-25)

Python 3.6+ only release
   2022-06-24 04:29:01 by David H. Gutteridge | Files touched by this commit (2) | Package updated
Log message:
py-openpyxl: update to 2.6.4

This is a release with a single bug fix that corrects a file corruption
issue.

Cannot save workbooks with comments more than once.
https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1330

(There is a newer 3.x branch with many more changes since, but it drops
Python 2.7 support and is more involved, so can't be committed during
the pkgsrc freeze.)
   2022-01-04 21:55:40 by Thomas Klausner | Files touched by this commit (1595)
Log message:
*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS
   2021-10-26 13:23:42 by Nia Alarie | Files touched by this commit (1161)
Log message:
textproc: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

Unfetchable distfiles (fetched conditionally?):
./textproc/convertlit/distinfo clit18src.zip
   2021-10-07 17:02:49 by Nia Alarie | Files touched by this commit (1162)
Log message:
textproc: Remove SHA1 hashes for distfiles