From nobody Sat Aug 27 10:30:48 2022 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4MFCf04RVkz4b4l7; Sat, 27 Aug 2022 10:30:48 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4MFCf03Wjlz3x2x; Sat, 27 Aug 2022 10:30:48 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1661596248; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=FAwuFqqUyMaRGQGG0MN9Oj4oT8+HzEPG84xnUug61oA=; b=JCCbeii78MYYeZsF2oG1ESKbunteGqZPRal6YT5OVsHzMJU3mUkJ2Y34ROFmw1aBf74OFj OMvHNd2JANxLoEn/e4yjuotQDJm/hmsW7sZNKlETGpXeZlBzaolw1nvNVvcyAhH1aDifbc Cxdd8cmbXZYHiMekCMSoBuQM+b2qDIwVsfiwZhWhdmfLT2xtEFD6UPdJ6TqhRT5jLpEaKc XQiTPFJYeyO6hpyFZeA3soaltePGvUAdq+S3Md/YlxS96qlFX9pAYH40K4jZ8S0KiiJdmg mJgQzk3k006FGGd9QZEorBdWCF783mYlFxVPlYHaaYfXsdq1YkWNZC8LZxAVLw== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4MFCf02dLVzjyf; Sat, 27 Aug 2022 10:30:48 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 27RAUm4d047247; Sat, 27 Aug 2022 10:30:48 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 27RAUmfX047246; Sat, 27 Aug 2022 10:30:48 GMT (envelope-from git) Date: Sat, 27 Aug 2022 10:30:48 GMT Message-Id: <202208271030.27RAUmfX047246@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Po-Chuan Hsieh Subject: git: ed2846c0431a - main - textproc/py-pyxlsb2: Add py-pyxlsb2 0.0.9 List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: sunpoet X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: ed2846c0431aa13b41dfe67f78c47988591b0350 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1661596248; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=FAwuFqqUyMaRGQGG0MN9Oj4oT8+HzEPG84xnUug61oA=; b=fy33eKWFJIEX9mqZ0ld1EW79lLHYQF3BQRSGEmO45X9Sd/UglV0RVVj8szEksoN/O6293b fKjAwuIvtjtzyFkO9D53s0Ap3CQyzARQTeCjD3QSScF3fvPysbaxQ35l9m/lJrybG6Nm8B xjo9Zl38JhFJ+JROJmqEQ2l/iI1OMu+YBRTpGtz/7wWn6cDf07MA1lWye3BgJxHFGkuinx ptLgDpp/RVeu1om7barpPX4tMYfA5r74qIB2gY4vNOCEbhntYIGoVUjtJJMEbZdQjbBSOf FjYi3roYGZWKBFQZNHHrDGbNso8lD+RFfDNjg4wukoV3N3ZWr7qbWc0onJELeA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1661596248; a=rsa-sha256; cv=none; b=GPUYtjoNWxrhmc+rxzzpYOvFyGcDepKdVc+xEA5NqwuxNprgXcb+tmHA6pylJ0racL06Mf 77ap1B0uFiBoOmCLdCJUgqdALiDpr/3wJ++rZ3aAtny5lMyd5lyzAzferCVXzhhnTjSraY He8jfQg3K5Nfk9Dwka4IIfw4oGK0d3cOBOG9SseTttZhGc8TSobr0i2oXMw9Xz/0Vfl7Rd 8jIyEL99/Tk8tFCrsRzrvIpNSa+ICp//IxHQIil+mA+OOZf7ziCd6hFBUftYYZiSLka1ad cLibo2gagdxXfsRduNhHV4oA1aiqeqm0NgJF0+hOd5UZyd7YOMp++IH/sS3kIA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by sunpoet: URL: https://cgit.FreeBSD.org/ports/commit/?id=ed2846c0431aa13b41dfe67f78c47988591b0350 commit ed2846c0431aa13b41dfe67f78c47988591b0350 Author: Po-Chuan Hsieh AuthorDate: 2022-08-27 10:10:33 +0000 Commit: Po-Chuan Hsieh CommitDate: 2022-08-27 10:10:33 +0000 textproc/py-pyxlsb2: Add py-pyxlsb2 0.0.9 pyxlsb2 (a variant of pyxlsb) is an Excel 2007+ Binary Workbook (xlsb) parser written in Python. pyxslb2 offers the following improvements/changes in comparison to pyxlsb: - By default, keeps all data in memory instead of creating temporary files. This is mainly to speed up the processing and also not changing the local file system during the processing. - relies on both "xl\workbook.bin" and "xl\_rels\workbook.bin.rels" to load locate boundsheets. As a result, it can load all worksheets as well as all macrosheets. - extracts macro formulas: - accurately shows the formulas - supports A1 addressing - supports external addressing (partially implemented)) - extracts defined names such as auto_open WWW: https://github.com/DissectMalware/pyxlsb2 --- textproc/Makefile | 1 + textproc/py-pyxlsb2/Makefile | 18 ++++++++++++++++++ textproc/py-pyxlsb2/distinfo | 3 +++ textproc/py-pyxlsb2/pkg-descr | 17 +++++++++++++++++ 4 files changed, 39 insertions(+) diff --git a/textproc/Makefile b/textproc/Makefile index b94469e3d373..84007e05cff9 100644 --- a/textproc/Makefile +++ b/textproc/Makefile @@ -1465,6 +1465,7 @@ SUBDIR += py-pytkdocs SUBDIR += py-pytoml SUBDIR += py-pyx12 + SUBDIR += py-pyxlsb2 SUBDIR += py-qrcode SUBDIR += py-rdflib SUBDIR += py-readchar diff --git a/textproc/py-pyxlsb2/Makefile b/textproc/py-pyxlsb2/Makefile new file mode 100644 index 000000000000..7ed313007e34 --- /dev/null +++ b/textproc/py-pyxlsb2/Makefile @@ -0,0 +1,18 @@ +PORTNAME= pyxlsb2 +PORTVERSION= 0.0.9 +CATEGORIES= textproc python +MASTER_SITES= CHEESESHOP +PKGNAMEPREFIX= ${PYTHON_PKGNAMEPREFIX} + +MAINTAINER= sunpoet@FreeBSD.org +COMMENT= Excel 2007+ Binary Workbook (xlsb) parser + +LICENSE= APACHE20 +LICENSE_FILE= ${WRKSRC}/LICENSE + +USES= python:3.5+ +USE_PYTHON= autoplist concurrent distutils + +NO_ARCH= yes + +.include diff --git a/textproc/py-pyxlsb2/distinfo b/textproc/py-pyxlsb2/distinfo new file mode 100644 index 000000000000..d105646928e9 --- /dev/null +++ b/textproc/py-pyxlsb2/distinfo @@ -0,0 +1,3 @@ +TIMESTAMP = 1660576694 +SHA256 (pyxlsb2-0.0.9.tar.gz) = 7746c4ce999714957409fd6a446499fee7a1528ea6e0f40f8ca4aed90c4cd488 +SIZE (pyxlsb2-0.0.9.tar.gz) = 37003 diff --git a/textproc/py-pyxlsb2/pkg-descr b/textproc/py-pyxlsb2/pkg-descr new file mode 100644 index 000000000000..6c56703ad1d8 --- /dev/null +++ b/textproc/py-pyxlsb2/pkg-descr @@ -0,0 +1,17 @@ +pyxlsb2 (a variant of pyxlsb) is an Excel 2007+ Binary Workbook (xlsb) parser +written in Python. + +pyxslb2 offers the following improvements/changes in comparison to pyxlsb: +- By default, keeps all data in memory instead of creating temporary files. This + is mainly to speed up the processing and also not changing the local file + system during the processing. +- relies on both "xl\workbook.bin" and "xl\_rels\workbook.bin.rels" to load + locate boundsheets. As a result, it can load all worksheets as well as all + macrosheets. +- extracts macro formulas: + - accurately shows the formulas + - supports A1 addressing + - supports external addressing (partially implemented)) +- extracts defined names such as auto_open + +WWW: https://github.com/DissectMalware/pyxlsb2