Search spreadsheets for strings
ssgrep [OPTIONS] [FILES]
This manual page briefly documents the ssgrep command.
ssgrep is a command line utility to search for strings in spreadsheets of any format supported by gnumeric. Without any output modifying options, ssgrep prints one line for each match. A match consists of the matching content of a cell or, if the -R option is given, the matching expression result of a cell.
This program follows the usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options starting with two dashes (`--').
--recalc
Recalculate all cells
-f, --keyword-file=FILE
The path to a text file containing one key per line
-i, --ignore-case
Ignore differences in letter case
-w, --word-regexp
Match only whole words
-F, --fixed-strings
Pattern is a set of fixed strings
-R, --search-results
Search results of expressions too
-v, --invert-match
Search for cells that do not match
-c, --count
Only print a count of matches per file
-L, --files-without-matches
Print filenames without matches
-l, --files-with-matches
Print filenames with matches
-q, --quiet
Suppress all normal output
-H, --with-filename
Print the filename for each match
-h, --without-filename
Do not print the filename for each match
-n, --print-locus
Print the location of each match
-T, --print-type
Print the location type of each match
-V, --version
Display ssgrep's version
-?, --help
Display the supported options
--usage
Display a brief usage message
To search for the string "SUM" in the file foo.gnumeric :
ssgrep SUM foo.gnumeric
To search for the strings from the file keywords in the spreadsheet foo.xls :
ssgrep --keyword-file=keywords foo.xls
ssgrep is licensed under the terms of the General Public License (GPL), version 2 or 3. For information on this license look at the source code that came with the software or see the \$2 \(laURL: \$1 \(ra\$3
The copyright on ssgrep and the gnumeric software and source code is held by the individual authors as is documented in the source code.
ssgrep's primary author is Jody Goldberg <[email protected]>; ssgrep builds on the gnumeric codebase.
The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <[email protected]>.
beagled(1), gnumeric(1), ssconvert(1), ssdiff(1) ssindex(1)