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, XLSM, CSV, TSV and ODS files at once, even recursively in directories.
Regular expressions: Python regex.
Supported file types: csv, ods, tsv, xls, xlsx, xlsm.
Works on all major platforms: Windows, macOS, BSD and Linux,
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 locationoptional 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.