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.11.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.11.tar.gz.
File metadata
- Download URL: grepxl-0.1.11.tar.gz
- Upload date:
- Size: 2.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.25 {"installer":{"name":"uv","version":"0.9.25","subcommand":["publish"]},"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 |
93412406abac6bfcc767d663f6fb98d84218e95535cd4d9a6198f04514c8a64a
|
|
| MD5 |
f0c3c163de3e07e27a090d1b21836b9d
|
|
| BLAKE2b-256 |
ec01a1580e88d1e47c01a9c476241506caf5cdff3696f8352074d0967a3973da
|
File details
Details for the file grepxl-0.1.11-py3-none-any.whl.
File metadata
- Download URL: grepxl-0.1.11-py3-none-any.whl
- Upload date:
- Size: 2.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.9.25 {"installer":{"name":"uv","version":"0.9.25","subcommand":["publish"]},"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 |
c783a17cf2e7bf6562c227df6104d4a2faaa6d52615699a40eacf1c9a5b22edb
|
|
| MD5 |
9fbe5852837aa0c1c889e5cc3a240d53
|
|
| BLAKE2b-256 |
370ffe93738a0c5f43ecc374f41ca0259b9e0770a2cd3da444795c25bbd2236b
|
