Metadata-Version: 2.4
Name: xlsxgrep
Version: 0.0.32
Summary: CLI tool to search text in XLSX, XLS, XLSM, CSV, TSV and ODS files. It works similarly to Unix\GNU Linux grep.
Home-page: https://github.com/zazuum/xlsxgrep
Author: Ivan Cvitic
Author-email: cviticivan@gmail.com
License: MIT
Classifier: Environment :: Console
Classifier: License :: OSI Approved :: MIT License
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Education
Classifier: Intended Audience :: System Administrators
Classifier: Intended Audience :: Science/Research
Classifier: Intended Audience :: End Users/Desktop
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Programming Language :: Python :: 3.14
Classifier: Topic :: Scientific/Engineering
Classifier: Topic :: Scientific/Engineering :: Information Analysis
Classifier: Topic :: Scientific/Engineering :: Bio-Informatics
Classifier: Topic :: Office/Business
Classifier: Topic :: Office/Business :: Financial
Classifier: Topic :: Office/Business :: Financial :: Spreadsheet
Classifier: Topic :: Utilities
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pyexcel
Requires-Dist: pyexcel-xls
Requires-Dist: pyexcel-xlsx
Requires-Dist: pyexcel-odsr
Dynamic: license-file

## 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.

- Regular expressions: Python regex.

- 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] [-F] [-i] [-w] [-c] [-r] [-H] [-N] [-l] [-L] [-S SEPARATOR]
                [-Z] [-d] PATTERN FILE [FILE ...]

positional arguments:
  PATTERN                   use PATTERN as the pattern to search for.
  FILE                      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:
```sh
xlsxgrep -i "foo" foobar.xlsx
```
```sh
xlsxgrep -c -H "(?i)foo|bar" /folder
```
## Installation

```sh
pip install xlsxgrep
```
