logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

ssgrep - search spreadsheets for strings

Author

ssgrep's primary author is Jody Goldberg <jody@gnome.org>; ssgrep builds on the gnumeric codebase.

       The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <jdassen@debian.org>.

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.

Example

       To search for the string "SUM" in the file foo.gnumeric :

       ssgrepSUMfoo.gnumeric

       To search for the strings from the file keywords in the spreadsheet foo.xls :

       ssgrep--keyword-file=keywordsfoo.xls

License

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 GNU project page ⟨http://
       www.gnu.org⟩.

Name

       ssgrep - search spreadsheets for strings

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

   Optionscontrollinginputfilehandling--recalc
              Recalculate all cells

   Optionscontrollingpatternsandpatternmatching-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

   Optionscontrollingoutputingeneral-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

   Helpoptions-V,--version
              Display ssgrep's version

       -?,--help
              Display the supported options

       --usage
              Display a brief usage message

See Also

beagled(1), gnumeric(1), ssconvert(1), ssdiff(1) ssindex(1)

       The Gnumeric Homepage ⟨http://www.gnome.org/projects/gnumeric/⟩.

       The GNOME project page ⟨http://www.gnome.org/⟩.

gnumeric                                           2009-02-08                                          SSGREP(1)

Synopsis

ssgrep  [OPTIONS] [FILES]

See Also