Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up

xlsxgrep is a CLI tool to search text in XLSX, XLS, CSV, TSV and ODS files. It works similarly to Unix/GNU Linux grep.

License

NotificationsYou must be signed in to change notification settings

zazuum/xlsxgrep

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xlsxgrep is a CLI tool to search text in XLSX, XLS, CSV, TSV and ODS files. It works similarly to Unix/GNU Linuxgrep.

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, CSV, TSV and ODS files at once, even recursively in directories.

  • Regular expressions: Python regex.

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

Usage:

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.

Examples:

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

Installation

     pip install xlsxgrep

[8]ページ先頭

©2009-2025 Movatter.jp