Skip to content

Tools based on roo that perform actions on groups of spreadsheets

License

Notifications You must be signed in to change notification settings

hmcgowan/roo-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

= OOGrep

Search multiple spreadsheets using roo. This means that you can search across Excel, Excelx, OpenOffice and Google Spreadsheets.

sage: oogrep.rb [options] searchstring targets

Options:
    -l, --list-only                  List matching files only
    -i, --case-insensitive           Case insensitive search
    -e, --exact-match                Force exact match on cell contents
    -f, --font STYLE                 Filter results by cell font style
        --[no-]tabs                  Show/hide tabs in results
        --[no-]cells                 Show/hide cells in results
    -?, -h, --help                   Show this message.

== Options

* list-only

	Only show the names of files that have a match

* case-insensitive

	The searches are strict by default but you can make the search ignore case with this option

* exact-match

	This option will force the search to only show results if the cell's text matches the search string verbatim

* font-style

	You can filter the search results based on the font. Valid values include 'bold', 'italic', 'underline','normal' and 'ignore'. By default the results will ignore the font information. Also note
	that tabs will be filtered out unless the font is 'normal' or 'ignore'. 

Note that this feature requires the git version of roo if/until the patch to roo for fonts is integrated

* [no]-tabs

	Show or hide tabs from the results using --tabs or --no-tabs

* [no]-cells

	Show or hide cells from the results using --cells or --no-cells

About

Tools based on roo that perform actions on groups of spreadsheets

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages