Add your description here
Project description
grepxl
A simple command-line search tool for excel spreadsheets
Installation
$ uv tool 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 │ ejimeno0@cdc.gov │
│ 2 │ Liana │ Mustoe │ lmustoe1@nps.gov │
│ 3 │ Leo │ Fairholme │ lfairholme2@cpanel.net │
│ 4 │ Emeline │ Bracchi │ ebracchi3@theatlantic.com │
│ 5 │ Albina │ Kibble │ akibble4@house.gov │
│ 6 │ Andrea │ Coles │ acoles5@skype.com │
│ 7 │ Clayborne │ Jeroch │ cjeroch6@rambler.ru │
│ 8 │ Stevie │ Careless │ scareless7@wikispaces.com │
│ 9 │ Nanci │ Ledrane │ nledrane8@devhub.com │
│ 10 │ Agustin │ Cattermoul │ acattermoul9@google.com.au │
└────┴────────────┴────────────┴────────────────────────────┘
$ grepxl 'gov$' MOCKDATA.xlsx
┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┓
┃ id ┃ first_name ┃ last_name ┃ email ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━┩
│ 1 │ Eulalie │ Jimeno │ ejimeno0@cdc.gov │
│ 2 │ Liana │ Mustoe │ lmustoe1@nps.gov │
│ 5 │ Albina │ Kibble │ akibble4@house.gov │
└────┴────────────┴───────────┴────────────────────┘
$ grepxl '^Le' MOCKDATA.xlsx
┏━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ id ┃ first_name ┃ last_name ┃ email ┃
┡━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━┩
│ 3 │ Leo │ Fairholme │ lfairholme2@cpanel.net │
│ 9 │ Nanci │ Ledrane │ nledrane8@devhub.com │
└────┴────────────┴───────────┴────────────────────────┘
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
grepxl-0.1.9.tar.gz
(2.8 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file grepxl-0.1.9.tar.gz.
File metadata
- Download URL: grepxl-0.1.9.tar.gz
- Upload date:
- Size: 2.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.9 {"installer":{"name":"uv","version":"0.9.9"},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9d84db1e9c499bd3b467d75afcf2c72256941200a6ad561448fe3d254682ef60
|
|
| MD5 |
ab646df22a293c9a06f92ebc476e7df9
|
|
| BLAKE2b-256 |
da1efc9e0c273c9857d39ecdaa126cfa26d3a4f51b3e5684fc819140c08ff07d
|
File details
Details for the file grepxl-0.1.9-py3-none-any.whl.
File metadata
- Download URL: grepxl-0.1.9-py3-none-any.whl
- Upload date:
- Size: 2.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.9 {"installer":{"name":"uv","version":"0.9.9"},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d833b3d4b075eb0095c37ab89b6d82eafe0625ef2bc2f1ebbed4c91cf58c0250
|
|
| MD5 |
e2ea80bc7916f9e9e1818c6467a04965
|
|
| BLAKE2b-256 |
d6c1f6017a8aebb48847a2cb506f518c8a4768f6306a814dfbe4c182823d0c86
|
