notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
2024-11-06 Today brought in a new category: filesystems. Sadly, the website did not process it well. I am working on that. It may take a few days.
2024-11-07 Commit processing is halted. I have a fix for the new category. It is making its way through the system.
UPDATE: the backend is processing the original filesystems commit now. It should take about an hour.
UPDATE: as of 20:30 UTC, the filesystems commit has been processed. Commit processing is now up to date.
Port details
py-openpyxl Python library to read/write Excel 2007 xlsx/xlsm files
3.1.1 textproc on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.1.1Version of this port present on the latest quarterly branch.
Maintainer: antoine@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2013-09-06 21:02:24
Last Update: 2023-02-21 19:30:46
Commit Hash: af38994
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
Also Listed In: python
License: MIT
WWW:
https://foss.heptapod.net/openpyxl/openpyxl
Description:
OpenPyxl is a Python library to read/write Excel 2007 xlsx/xlsm files.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}openpyxl>0:textproc/py-openpyxl@${PY_FLAVOR}
To install the port:
cd /usr/ports/textproc/py-openpyxl/ && make install clean
To add the package, run one of these commands:
  • pkg install textproc/py-openpyxl
  • pkg install py39-openpyxl
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py39-openpyxl listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py39-openpyxl
Package flavors (<flavor>: <package>)
  • py39: py39-openpyxl
distinfo:
TIMESTAMP = 1677003796 SHA256 (openpyxl-3.1.1.tar.gz) = f06d44e2c973781068bce5ecf860a09bcdb1c7f5ce1facd5e9aa82c92c93ae72 SIZE (openpyxl-3.1.1.tar.gz) = 185802

Packages (timestamps in pop-ups are UTC):
py37-openpyxl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--2.6.4---2.6.4-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py39-openpyxl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--3.1.1--3.1.13.1.13.1.1
FreeBSD:14:latest--2.6.4--3.1.1-3.1.1
FreeBSD:14:quarterly-----3.1.13.1.13.1.1
FreeBSD:15:latest--n/a-n/a3.1.13.1.13.1.1
 
py311-openpyxl
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.1.13.1.1-3.1.13.1.1---
FreeBSD:13:quarterly3.1.13.1.1-3.1.13.1.1---
FreeBSD:14:latest3.1.13.1.1-3.1.13.1.1---
FreeBSD:14:quarterly3.1.13.1.1-3.1.13.1.1---
FreeBSD:15:latest3.1.13.1.1n/a3.1.1n/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py39-setuptools>=63.1.0 : devel/py-setuptools@py39
  2. python3.9 : lang/python39
Test dependencies:
  1. python3.9 : lang/python39
Runtime dependencies:
  1. py39-et_xmlfile>=0 : textproc/py-et_xmlfile@py39
  2. py39-setuptools>=63.1.0 : devel/py-setuptools@py39
  3. python3.9 : lang/python39
This port is required by:
for Build
  1. finance/ktoblzcheck
for Run
  1. biology/py-resdk
  2. devel/py-robotframework-excellib
  3. devel/py-tabulator
  4. finance/py-thepassiveinvestor
  5. math/py-qats
  6. misc/orange3
  7. security/py-pnu-certwatch
Expand this list (15 items / 8 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. textproc/py-agate-excel
  3. textproc/py-csvkit
  4. textproc/py-pyexcel-xlsx
  5. textproc/py-tablib
  6. www/py-wagtail
  7. www/seahub
  8. Collapse this list.

Deleted ports which required this port:

Expand this list of 2 deleted ports
  1. science/psychopy*
  2. security/py-volatility*
  3. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options:
No options to configure
Options name:
textproc_py-openpyxl
USES:
cpe python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/o/openpyxl/
  2. https://pypi.org/packages/source/o/openpyxl/
Collapse this list.

Number of commits found: 62

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.1.1
21 Feb 2023 19:30:46
commit hash: af38994e5054d78a7a1b32cf9c06456e9f74c9a3commit hash: af38994e5054d78a7a1b32cf9c06456e9f74c9a3commit hash: af38994e5054d78a7a1b32cf9c06456e9f74c9a3commit hash: af38994e5054d78a7a1b32cf9c06456e9f74c9a3 files touched by this commit
Antoine Brodin (antoine) search for other commits by this committer
textproc/py-openpyxl: update to 3.1.1
2.6.4
11 Jan 2023 15:58:34
commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656 files touched by this commit
Dmitry Marakasov (amdmi3) search for other commits by this committer
*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
2.6.4
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.6.4
20 Jul 2022 14:23:14
commit hash: 5cf7e35e8664e11393fedc7d89b4d09e0fcced9bcommit hash: 5cf7e35e8664e11393fedc7d89b4d09e0fcced9bcommit hash: 5cf7e35e8664e11393fedc7d89b4d09e0fcced9bcommit hash: 5cf7e35e8664e11393fedc7d89b4d09e0fcced9b files touched by this commit
Tobias C. Berner (tcberner) search for other commits by this committer
textproc: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  -
  *  <glewis@FreeBSD.org>
  *  <koshy@india.hp.com>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Aaron Dalton <aaron@daltons.ca>
  *  Aaron Straup Cope
  *  Aaron Straup Cope <ascope@cpan.org>
  *  Ache
  *  Adam Herzog <adam@herzogdesigns.com>
  *  Adam Weinberger <adamw@FreeBSD.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.6.4
14 Oct 2021 11:02:08
commit hash: 17a1b3241661cb6e16bc0efcff7af07e3295c6eecommit hash: 17a1b3241661cb6e16bc0efcff7af07e3295c6eecommit hash: 17a1b3241661cb6e16bc0efcff7af07e3295c6eecommit hash: 17a1b3241661cb6e16bc0efcff7af07e3295c6ee files touched by this commit
Stefan Eßer (se) search for other commits by this committer
textproc/py-openpyxl: Add CPE information

Approved by:	portmgr (blanket)
2.6.4
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
2.6.4
28 Dec 2020 23:02:15
Revision:559531Original commit files touched by this commit
antoine search for other commits by this committer
Drop python 2.7 support from a few ports

With hat:	portmgr
2.6.4
20 Oct 2019 07:50:41
Revision:514881Original commit files touched by this commit
antoine search for other commits by this committer
Add portscout limit
2.6.4
19 Oct 2019 20:47:28
Revision:514840Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.6.4
2.6.3
28 Aug 2019 16:29:00
Revision:510077Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.6.3
2.6.2
14 Apr 2019 12:14:22
Revision:498897Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.6.2
2.6.1
21 Mar 2019 10:53:04
Revision:496441Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.6.1
2.6.0
01 Mar 2019 15:29:08
Revision:494300Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.6.0
2.5.14
10 Feb 2019 10:01:12
Revision:492594Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.14
2.5.12
01 Dec 2018 12:48:48
Revision:486336Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.12
2.5.11
24 Nov 2018 10:06:18
Revision:485751Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.11
2.5.10
17 Nov 2018 21:34:58
Revision:485202Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.10
2.5.8
07 Oct 2018 16:39:55
Revision:481461Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.8
2.5.7
22 Sep 2018 08:22:19
Revision:480362Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.7
2.5.5
11 Aug 2018 17:34:28
Revision:476931Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.5
2.5.4
25 Jun 2018 17:34:41
Revision:473329Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.4
2.5.3
20 Jun 2018 17:05:44
Revision:472884Original commit files touched by this commit
mat search for other commits by this committer
Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight
2.5.3
21 Apr 2018 11:35:15
Revision:467880Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.5.3
2.4.11
25 Jan 2018 22:29:01
Revision:459965Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.11
2.4.10
21 Jan 2018 12:38:25
Revision:459601Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.10
2.4.9
30 Nov 2017 15:50:34
Revision:455210Original commit files touched by this commit Sanity Test Failure
mat search for other commits by this committer
Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.4.9
29 Oct 2017 08:17:26
Revision:453099Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.9
2.4.8
03 Jun 2017 10:47:15
Revision:442476Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.8
2.4.7
07 May 2017 11:37:46
Revision:440331Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.7
2.4.5
18 Mar 2017 12:06:23
Revision:436400Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.5
2.4.4
25 Feb 2017 09:02:00
Revision:434774Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.4
2.4.2
05 Feb 2017 16:58:40
Revision:433428Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.2
2.4.1
27 Nov 2016 19:24:23
Revision:427271Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.1
2.4.0
20 Nov 2016 14:01:53
Revision:426591Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.4.0
2.3.5
01 May 2016 08:15:37
Revision:414401Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.3.5
2.3.4
01 Apr 2016 14:25:18
Revision:412349Original commit files touched by this commit
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories r, s, t, and u.

With hat:	portmgr
Sponsored by:	Absolight
2.3.4
21 Mar 2016 07:18:28
Revision:411544Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.3.4
2.3.3
24 Jan 2016 09:29:28
Revision:407092Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.3.3
2.3.2
07 Dec 2015 18:49:45
Revision:403228Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.3.2
2.2.6
04 Oct 2015 16:55:43
Revision:398583Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.2.6
2.2.4
27 Jun 2015 20:38:05
Revision:390729Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.2.4
2.2.0
27 Mar 2015 12:24:07
Revision:382400Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.2.0
2.1.4
20 Dec 2014 21:49:49
Revision:375131Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.1.4
2.1.2
11 Nov 2014 12:52:57
Revision:372443Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.1.2
2.1.1
19 Oct 2014 22:32:49
Revision:371215Original commit files touched by this commit
antoine search for other commits by this committer
- Update to 2.1.1
- Tighten CONFLICTS
2.0.5
29 Aug 2014 16:51:53
Revision:366531Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.0.5
2.0.4
27 Jun 2014 14:21:44
Revision:359537Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.0.4
2.0.3
30 May 2014 14:37:00
Revision:355852Original commit files touched by this commit
antoine search for other commits by this committer
Update to 2.0.3
2.0.2
19 May 2014 15:07:36
Revision:354543Original commit files touched by this commit
antoine search for other commits by this committer
Copy textproc/py-openpyxl to textproc/py-openpyxl1 and put version 1.8.6
in this port
py-pandas is not fully compatible with last version of py-openpyxl

PR:		ports/189930
Submitted by:	John W. O'Brien
2.0.2
15 May 2014 19:35:22
Revision:354170Original commit files touched by this commit
antoine search for other commits by this committer
- Add devel/py-jdcal:
  Module converting between Julian dates and calendar dates

- Update textproc/py-openpyxl to 2.0.2
1.8.6
09 May 2014 16:27:21
Revision:353473Original commit files touched by this commit
antoine search for other commits by this committer
Update to 1.8.6
1.8.5
26 Mar 2014 09:42:35
Revision:349238Original commit files touched by this commit
antoine search for other commits by this committer
Update to 1.8.5
1.8.4
27 Feb 2014 17:57:39
Revision:346381Original commit files touched by this commit
antoine search for other commits by this committer
Update to 1.8.4
1.8.3
10 Feb 2014 17:53:08
Revision:343665Original commit files touched by this commit
antoine search for other commits by this committer
- Update to 1.8.3
- Do not override DOCSDIR, mva@'s upcoming patch will do that better soon
1.8.2
25 Jan 2014 12:57:41
Revision:341018Original commit files touched by this commit
antoine search for other commits by this committer
- Update to 1.8.2
- Remove DOCS conditional
1.8.1
15 Jan 2014 18:59:47
Revision:339805Original commit files touched by this commit
antoine search for other commits by this committer
Update to 1.8.1
1.8.0
13 Jan 2014 21:34:50
Revision:339640Original commit files touched by this commit
antoine search for other commits by this committer
Update to 1.8.0
1.7.0
21 Dec 2013 21:34:19
Revision:337164Original commit files touched by this commit
antoine search for other commits by this committer
- Switch from easy_install to install
- Use PYDISTUTILS_AUTOPLIST
1.7.0
14 Nov 2013 20:22:06
Revision:333787Original commit files touched by this commit
antoine search for other commits by this committer
- Update to 1.7.0
- Stage support
1.6.2
20 Sep 2013 23:17:32
Revision:327773Original commit files touched by this commit
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
textproc)
1.6.2
06 Sep 2013 21:02:12
Revision:326547Original commit files touched by this commit
antoine search for other commits by this committer
New port: py-openpyxl
OpenPyxl is a Python library to read/write Excel 2007 xlsx/xlsm files.
WWW: http://openpyxl.readthedocs.org/

Number of commits found: 62