grepxl 0.1.1

Add your description here

grepxl

A simple search tool for excel spreadsheets

Installation

$ pipx install grepxl

Usage

Given an excel file data.xlsx:

to print a row where any one cell matches a regex

$ grepxl '.*' MOCKDATA.xlsx
┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ id ┃ first_name ┃ last_name  ┃ email                      ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ 1  │ Eulalie    │ Jimeno     │ [e-mail]           │
│ 2  │ Liana      │ Mustoe     │ [e-mail]           │
│ 3  │ Leo        │ Fairholme  │ [e-mail]     │
│ 4  │ Emeline    │ Bracchi    │ [e-mail]  │
│ 5  │ Albina     │ Kibble     │ [e-mail]         │
│ 6  │ Andrea     │ Coles      │ [e-mail]          │
│ 7  │ Clayborne  │ Jeroch     │ [e-mail]        │
│ 8  │ Stevie     │ Careless   │ [e-mail]  │
│ 9  │ Nanci      │ Ledrane    │ [e-mail]       │
│ 10 │ Agustin    │ Cattermoul │ [e-mail] │
└────┴────────────┴────────────┴────────────────────────────┘
$ grepxl 'gov$' MOCKDATA.xlsx
┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┓
┃ id ┃ first_name ┃ last_name ┃ email              ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━┩
│ 1  │ Eulalie    │ Jimeno    │ [e-mail]   │
│ 2  │ Liana      │ Mustoe    │ [e-mail]   │
│ 5  │ Albina     │ Kibble    │ [e-mail] │
└────┴────────────┴───────────┴────────────────────┘
$ grepxl '^Le' MOCKDATA.xlsx
┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ id ┃ first_name ┃ last_name ┃ email                  ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━┩
│ 3  │ Leo        │ Fairholme │ [e-mail] │
│ 9  │ Nanci      │ Ledrane   │ [e-mail]   │
└────┴────────────┴───────────┴────────────────────────┘