ssgrep - Online in the Cloud

PROGRAM:

NAME

ssgrep - search spreadsheets for strings

SYNOPSIS

ssgrep [OPTIONS] [FILES]

DESCRIPTION

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.

OPTIONS

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 (`--').

Options controlling input file handling
--recalc
Recalculate all cells

Options controlling patterns and pattern matching
-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

Options controlling output in general
-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

Help options
-V, --version
Display ssgrep's version

-?, --help
Display the supported options

--usage
Display a brief usage message

EXAMPLE

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

Use ssgrep online using onworks.net services