xlsxgrep 0.0.29

Description:

xlsxgrep 0.0.29

Owerview
xlsxgrep is a CLI tool to search text in XLSX, XLS, CSV, TSV 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, CSV, TSV and ODS files at once, even recursively in directories.


Regular expressions: Python regex.


Supported file types: csv, ods, tsv, xls, xlsx


Usage:

usage: xlsxgrep [-h] [-V] [-P] [-F] [-i] [-w] [-c] [-r] [-H] [-N] [-l] [-L] [-S SEPARATOR] [-Z]
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.
-P, --python-regex PATTERN is a Python regular expression. This is the default.
-F, --fixed-strings interpret PATTERN as fixed strings, not regular expressions.
-i, --ignore-case ignore case distinctions.
-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.
-S SEPARATOR, --separator SEPARATOR
define custom list separator for output, the default is TAB
-Z, --null output a zero byte (the ASCII NUL character) instead of the usual newline.


Examples:
xlsxgrep -i "foo" foobar.xlsx

xlsxgrep -c -H "(?i)foo|bar" /folder

Installation
pip install xlsxgrep