Metadata-Version: 2.1
Name: skittle-sheets
Version: 0.0.3
Summary: Lightweight design of plate-based experiments
Author: David Feldman
Project-URL: Homepage, https://github.com/feldman4/skittle-sheets
Project-URL: Bug Tracker, https://github.com/feldman4/skittle-sheets/issues
Keywords: lab,biology,plate,experimental design
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: fire
Requires-Dist: google-api-python-client
Requires-Dist: google-auth-httplib2
Requires-Dist: google-auth-oauthlib
Requires-Dist: pandas
Requires-Dist: pygsheets
Requires-Dist: pyyaml

# Install

```bash
pip install skittle-sheets
```

To access Google Sheets (recommended), generate service file following
https://cloud.google.com/iam/docs/creating-managing-service-account-keys

Place it in the working directory, a parent directory, or your home directory. Make sure the filename matches `*service*.json`

# Usage (Google Sheets)

Share your Google Sheets document with the service account generated above (read-only is fine). Then run:

```bash
skittle export "drive:<spreadsheet>/<worksheet>
``` 

# Usage (local)

```bash
skittle export test.csv
skittle export test.xlsx
```
