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] [-V] [-i] [-P] [-w] [-c] [-r] [-H] [-N] [-l] [-L] [-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
-V, --version display version information 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.
-c, --count print only a count of matches per file.
-r, --recursive search directories recursively.
-H, --with-filename print the file name for each match.
-N, --with-sheetname print the sheet name for each match.
-l, --files-with-match
print only names of FILEs with match pattern.
-L, --files-without-match
print only names of FILEs with no match pattern.
-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
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 Distribution
xlsxgrep-0.0.26.tar.gz
(5.0 kB
view hashes)
Built Distribution
Close
Hashes for xlsxgrep-0.0.26-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f8d9d3cbc8f16e1b55806ef6d6d13db7650d1a8a24e5f3bfec1ac4ac2a0bd927 |
|
MD5 | af12aaa78de4ea1469dc8e7e358af1eb |
|
BLAKE2b-256 | 272dc1a253bd0ddf659fe70bc1d72a8f799becf9ee79de168ea05c9d8b974464 |