./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.5nb1, Package name: py312-openpyxl-3.1.5nb1, 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: 182.094 KB

Version history: (Expand)

CVS history: (Expand)


   2025-04-22 11:46:24 by Adam Ciarcinski | Files touched by this commit (2) 
Log message:
py-openpyxl: fix for setuptools>=78
   2025-04-14 14:39:22 by Adam Ciarcinski | Files touched by this commit (32) | Package updated
Log message:
Fix PLIST after py-setuptools update; bump depends and revision
   2024-11-11 08:29:31 by Thomas Klausner | Files touched by this commit (862) 
Log message:
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays
   2024-06-30 13:26:36 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-openpyxl: updated to 3.1.5

3.1.5
Bug fixes
   2024-06-13 07:07:44 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
py-openpyxl: updated to 3.1.4

3.1.4 (2024-06-12)

Assigning named styles doesn't work
Problems caused when saving workbooks created by LibreOffice

Changes

Python 3.6 and 3.7 are no longer supported.
   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