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.8.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.8.tar.gz.
File metadata
- Download URL: grepxl-0.1.8.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 |
13257851da09fcefd5794851a410fd27bef27c40315481974615586763d8226d
|
|
| MD5 |
e044eeea5f21d6ce7b4706cc31850d6f
|
|
| BLAKE2b-256 |
4bc5c6b158b0fc4196d0310712d68e56b8816b390473e8e261bc2ed6c56ec6b3
|
File details
Details for the file grepxl-0.1.8-py3-none-any.whl.
File metadata
- Download URL: grepxl-0.1.8-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 |
319e308fdcdea4dde9b6c9797ac35c56fcc4dd0c2a359cfed3878e01f5c01900
|
|
| MD5 |
c53a2a6f32d14bc2cfc8d2870823c99b
|
|
| BLAKE2b-256 |
8be3288eb467094f701c4ac4e91d0a21c173fb4fe7e3f93b60e2e43a153308d3
|
