xlsx-xargs

类似xargs命令，遍历依据是excel表单中的每一行。命令参数，允许被string.format替换，替换内容为指定单元格值。

命令说明

    E:\xlsx-xargs>python xlsx_xargs.py --help
    Usage: xlsx_xargs.py [OPTIONS] [COMMANDS]...

    类似xargs命令，遍历依据是excel表单中的每一行。命令参数，允许被string.format替换，替换内容为指定单元格值。

    注意：

    COMMANDS前加两个减号，可表示减号后均为COMMANDS参数。 xlsx-xargs [OPTIONS] -- [COMMANDS]...

    Options:
    -f, --file TEXT   Excel文件路径。  [required]
    -s, --sheet TEXT  表单页名称。默认为当前页。
    -r, --rows TEXT   指定需要处理的行。默认为所有行。
    -t, --test TEXT   使用正则对行进行过滤，只处理匹配的行。允许使用多个表达式，多个表达式之间求与。
    --help            Show this message and exit.

注意事项

rows 要遵从rows规则。
tests 要遵从test规则。
COMMANDS 前加--，可以防止参数冲突问题。

rows规则

1 == [1]
1,2,3 == [1,2,3]
1-3 == [1,2,3]
1-3,5 == [1,2,3,5]
3- == [3,4,5,6....] # 从第3行开始，直到最后一行。

test规则

每个test都是由（列名+":"+正则）组成，如（A:\d+）。
可以由多个test组成。
多个test求“与”为最后结果。

Metadata

Release files for xlsx-xargs 0.1.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for xlsx-xargs 0.1.0
File	Size	Uploaded	Provenance	Actions
xlsx-xargs-0.1.0.tar.gz	3.1 kB	Jun 18, 2019	Without provenance	Details for xlsx-xargs-0.1.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for xlsx-xargs 0.1.0
File	Interpreter	ABI	Platform	Actions Reset
xlsx_xargs-0.1.0-py3-none-any.whl 4.4 kB Jun 18, 2019 Without provenance	Python 3	none	any	Details for xlsx_xargs-0.1.0-py3-none-any.whl

Total release size: 7.5 kB

Release files / xlsx-xargs-0.1.0.tar.gz

Download URL	xlsx-xargs-0.1.0.tar.gz
Size	3.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`0c5e9666964abba48e57afdc474afb49d8392b35933efeddc493ad23f4b0790a`
BLAKE2b-256 checksum How to use checksums	`b2408cc674785561c598b7126c707dc8738d2ec69eadced3ac1b26cc29a654e8`
Upload date	Jun 18, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.2`

Release files / xlsx_xargs-0.1.0-py3-none-any.whl

Download URL	xlsx_xargs-0.1.0-py3-none-any.whl
Size	4.4 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`ec6359bb54f3e14c41b65ae7c8e76734af141fbfc41b031de5106e57712f727d`
BLAKE2b-256 checksum How to use checksums	`a1ace10687d21edee50891f4e04858706f0c5b12aae7a990f829d0d348f6a6fb`
Upload date	Jun 18, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.2`

Security for xlsx-xargs 0.1.0

Report project as malware

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.1.0 This release

Jun 18, 2019 2 release files No provenance

xlsx-xargs 0.1.0