google_sheet_writer
google_sheet_writer is an object-oriented wrapper around (amazing!) gspread and gspread_formatting that allows to programmatically create Google Sheets tables in an easy way.
On top of being convenient, it strives to minimize the amount of requests to save API quota.
Install in development mode: pip install -e .
See examples in examples folder.
The examples assume United Kingdom spreadsheet locale (can be changed in File → Settings prior to launching generation script). Other locales (e.g. Russia) might not work.
Version history
v0.0.8
- Batch API calls for dramatically faster spreadsheet generation (especially 10+ sheets)
- Worksheet creation/deletion batched into a single API call instead of one per sheet
- Cell values for all sheets written in one
values_batch_updatecall - Sheet resizing via
updateSheetPropertiesinstead of writing empty cells - Formatting and structural requests merged into a single
batch_updatecall - Worksheet hiding folded into the formatting batch
v0.0.7
- After successfully finishing table generation, a link to the table is printed to the console
v0.0.6
- Raise exception if users tries to set cursor's x/y attributes to floats
v0.0.5
- Added support for older pythons (3.9 and newer)
Metadata
Release files for google_sheet_writer 0.0.8
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| google_sheet_writer-0.0.8.tar.gz | 11.4 kB | Without provenance | Details for google_sheet_writer-0.0.8.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| google_sheet_writer-0.0.8-py3-none-any.whl | Python 3 | none | any | Details for google_sheet_writer-0.0.8-py3-none-any.whl |
Total release size: 22.3 kB
Release files / google_sheet_writer-0.0.8.tar.gz
| Download URL | google_sheet_writer-0.0.8.tar.gz |
|---|---|
| Size | 11.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
92cf5926f48c005a2c8a45d528a5b9df3d9df0d3cc2c7e48736fc8365d952d6d
|
|
BLAKE2b-256 checksum How to use checksums |
719523ef4f5358811fed1cbbebeddc21ffaffdaaceda589b99118258cf9c6b7e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.5
|
Release files / google_sheet_writer-0.0.8-py3-none-any.whl
| Download URL | google_sheet_writer-0.0.8-py3-none-any.whl |
|---|---|
| Size | 10.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
661072d79b78fd4b9276b1dd3935468fd934e4e16d99789ff4055188b2b0a22f
|
|
BLAKE2b-256 checksum How to use checksums |
4c8b8a4472466a8e909476f43b341c1295d4a3811f8598a817de6e39411ff669
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.9.5
|
Security for google_sheet_writer 0.0.8
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.