Skip to main content
Join the official 2020 Python Developers SurveyStart the survey!

CLI tool to search text in XLSX and XLS files. It works similarly to Unix\GNU Linux grep

Project description

Owerview

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

  • Regular expressions: Python regex.

Usage:


usage: xlsxgrep [-h] [-i] [-P] [-w] [-H] [-c] [-N] [-r] [-V] [-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
  -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.
  -V, --version         display version information and exit.
  -sep SEPARATOR, --separator SEPARATOR
                        define custom list separator for output, default is
                        TAB

Example:

     xlsxgrep "PATTERN" -H -N --sep=";" -r /path/to/folder

Installation


 pip install xlsxgrep

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for xlsxgrep, version 0.0.23
Filename, size File type Python version Upload date Hashes
Filename, size xlsxgrep-0.0.23-py3-none-any.whl (5.2 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size xlsxgrep-0.0.23.tar.gz (3.9 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page