CLI utility to search text in XLSX and XLS files. It works similary to grep
xlsxgrep is a tool to search text in XLSX and XLS files. It works similary to grep or pdfgrep.
This is a very early development version. While it technically works, much work needs to be done to better organize the code and implement additional features. See "To-do" below.
Grep compatible: xlsxgrep tries to be compatible with GNU grep, where it makes sense. Some of your favorite grep options are supported (such as
Search many XLSX and XLS files at once, even recursively in directories.
Regular expressions: Python regex.
usage: xlsxgrep [-h] [-i] [-P] [-w] [-H] [-c] [-N] [-r] 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.
$ xlsxgrep --with-filename --with-sheetname pattern Document.xlsx Document.xlsx: Sheet1: Line that match your pattern.
- Rewrite the whole thing from the scratch. :-D
- Extend with additional options.
- Add colors to output.
- Replace lxrd library with pandas.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size xlsxgrep-0.0.2-py3-none-any.whl (4.9 kB)||File type Wheel||Python version py3||Upload date||Hashes View hashes|