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.10.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.10.tar.gz.
File metadata
- Download URL: grepxl-0.1.10.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 |
74bf81d2e9b1ba479122ebf621571d53414318045ee2f7fae6fdfe82fcf94196
|
|
| MD5 |
2394cbd7b808df6b0d9037633a4660a0
|
|
| BLAKE2b-256 |
3532b32f426d998d52cfeff35b22163652ee59c4d06557f9e7ffaf7ac598746d
|
File details
Details for the file grepxl-0.1.10-py3-none-any.whl.
File metadata
- Download URL: grepxl-0.1.10-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 |
1b795789cb6d698cfeb4a337c36873d9942f1a8eb9d1fa2361def69013ff041b
|
|
| MD5 |
8595f16f7a44b0d234489d810c2b2bed
|
|
| BLAKE2b-256 |
c9e64e87dd0ca3bd2d11a73f6938f79414b830447952b789e98bf2ff6d29e462
|
