xlsxgrep 0.0.36

Owerview

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

• Format-aware spreadsheet output: XLSX/XLSM and XLS numeric cells are rendered using their spreadsheet number format. ODS cells use their stored display text. CSV and TSV values are printed exactly as stored in the source file.

• Regular expressions: Python regex and POSIX extended regular expressions (-E).

• Supported file types: csv, ods, tsv, xls, xlsx, xlsm.

• Works on all major platforms: Windows, macOS, BSD and Linux,

Usage:

usage: xlsxgrep [-h] [-V] [-P] [-E] [-F] [-i] [-w] [-c] [-r] [-H] [-N]
                [-l] [-L] [-S SEPARATOR] [-Z] [-j JOBS]
                [--row | --column] [-d] PATTTERN FILE [FILE ...]

positional arguments:
  PATTERN                    use PATTERN as the pattern to search for.
  FILE                       file or path to folder

options:
  -h, --help                 show this help message and exit.
  -V, --version              display version information and exit.
  -P, --python-regex         PATTERN is a Python regular expression.
  -E, --extended-regexp      PATTERN is a POSIX extended regular expression (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  define custom list separator for output, the default is TAB.
  -j, --jobs JOBS            number of CPU cores/processes to use for search (default: 1).
      --row                  search rows and print matching rows (default).
      --column               search columns and print whole matching columns vertically.

Examples:

xlsxgrep -i "foo" foobar.xlsx

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

For more details refer to the man page.

Installation

pip install xlsxgrep