CLI tool to search text in XLSX, XLS and ODS files. It works similarly to Unix\GNU Linux grep
Project description
Owerview
xlsxgrep is a CLI tool to search text in XLSX, XLS and ODS files. It works similarly to Unix/GNU Linux grep.
Features
-
Grep compatible: xlsxgrep tries to be compatible with Unix/Linux grep, where it makes sense. Some of grep options are supported (such as
-r
,-i
or-c
). -
Search many XLSX, XLS and ODS files at once, even recursively in directories.
-
Regular expressions: Python regex.
Usage:
usage: xlsxgrep [-h] [-i] [-P] [-w] [-H] [-c] [-N] [-r] [-V] [-sep SEPARATOR]
pattern path [path ...]
positional arguments:
pattern use PATTERN as the pattern to search for.
path file or folder location
optional arguments:
-h, --help show this help message and exit
-i, --ignore-case ignore case distinctions.
-P, --python-regex PATTERN is a Python regular expression.
-w, --word-regexp force PATTERN to match only whole words.
-H, --with-filename print the file name for each match.
-c, --count print only a count of matches per file
-N, --with-sheetname print the sheet name for each match.
-r, --recursive search directories recursively.
-V, --version display version information and exit.
-sep SEPARATOR, --separator SEPARATOR
define custom list separator for output, default is
TAB
Example:
xlsxgrep "PATTERN" -H -N --sep=";" -r /path/to/file_or_folder
Installation
pip install xlsxgrep
Windows compiled download:
https://github.com/zazuum/pool/tree/master/xlsxgrep-compiled-exe
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for xlsxgrep-0.0.24-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 14f569c331103bdf4818d2e1027bed4a1ca95e2465baaa9e275ecf14d0015b6a |
|
MD5 | 6b99d1e59df97fbd7d441d508fa95988 |
|
BLAKE2b-256 | c782d40b096a9e70cd2b739d87e99ccae825a88f60b85f6eb110057027c26e1b |