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

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


Branch: CURRENT, Version: 2.5.0, Package name: py27-openpyxl-2.5.0, 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:
[devel/py-setuptools] [textproc/py-lxml] [textproc/py-cElementTree] [lang/python27] [time/py-jdcal]

Required to build:
[pkgtools/cwrappers]

Master sites:

SHA1: b802d74bf6ddc0b286746a698b8a3957e4db4e56
RMD160: fd3fcbcc4a5e1989af65c1507402a3d4da3a49f1
Filesize: 165.434 KB

Version history: (Expand)


CVS history: (Expand)


   2018-02-13 12:49:38 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-openpyxl: updated to 2.5.0

2.5.0:
Minor changes
Correct definition for Connection Shapes.

2.5.0-b2:
Bugfixes
TableStyleInfo has no required attributes
Cannot read files with 3D drawings
Incorrect version check in installer
Cell merging uses transposed parameters
ExtLst missing keyword for PivotFields
Inf causes problems for Excel
Cannot load table styles with custom names

Major Changes
You can now insert and delete rows and columns in worksheets

Minor Changes
pip now handles which Python versions can be used.

2.5.0-b1:
Bugfixes
Explicitly support for multiple cell ranges in conditonal formatting
Non-contiguous cell ranges in validators get merged
Empty data validators create invalid Excel files
Large validation ranges use lots of memory
Unicode in chart axes not handled correctly in Python 2
ScatterCharts have defective axes
Charts with empty numVal elements cannot be read
Scaling options from existing files ignored
Charts with PivotSource cannot be read
Cannot read gradient fills
Quotes in number formats could be treated as datetimes
   2018-01-27 09:35:59 by Thomas Klausner | Files touched by this commit (1)
Log message:
py-openpyxl: add required py-cElementTree dependency

From Fekete, Zoltán in PR 52953.
   2017-10-30 11:10:20 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-openpyxl: updated to 2.4.9

2.4.9 (2017-10-19)
Bugfixes
* 809 Incomplete documentation of copy_worksheet method
* 811 Scoped definedNames not removed when worksheet is deleted
* 824 Raise an exception if a chart is used in multiple sheets
* 842 Non-ASCII table column headings cause an exception in Python 2
* 846 Conditional formats not supported in write-only mode
* 849 Conditional formats with no sqref cause an exception
* 859 Headers that start with a number conflict with font size
* 902 TableStyleElements don’t always have a condtional format
* 908 Read-only mode sometimes returns too many cells
Pull requests
* 179 Cells kept in a set
* 180 Support for Workbook protection
* 182 Read support for page breaks
* 183 Improve documentation of copy_worksheet method
* 198 Fix
   2017-06-01 18:58:27 by Adam Ciarcinski | Files touched by this commit (3)
Log message:
2.4.8 (2017-05-30)

Bugfixes
* AutoFilter.sortState being assignd to the ws.sortState
* Cannot open files created by Microsoft Dynamics`
* Negative percents not case correctly`
* Runtime imports can cause deadlock`

Minor changes
* Preserve any table styles
   2016-06-08 19:43:49 by Thomas Klausner | Files touched by this commit (356)
Log message:
Switch to MASTER_SITES_PYPI.
   2015-11-04 03:00:17 by Alistair G. Crooks | Files touched by this commit (797)
Log message:
Add SHA512 digests for distfiles for textproc category

Problems found locating distfiles:
	Package cabocha: missing distfile cabocha-0.68.tar.bz2
	Package convertlit: missing distfile clit18src.zip
	Package php-enchant: missing distfile php-enchant/enchant-1.1.0.tgz

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.
   2014-10-26 00:19:45 by Aleksey Cheusov | Files touched by this commit (4) | Imported package
Log message:
Imported from wip/py-openpyxl
   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/