No project description provided
Project description
Better Spread
A wrapper around gspread with cell and row level functionalities
Sheet
from betterspread import Sheet, Connection
con = Connection(credentials_path="./credentials.json")
sheet = Sheet(connection=con, sheet_name="Better Sheet")
tab = await sheet.get_tab('Sheet1')
Sheet
is a subclass of gsprad's Spreadsheet
get all values
await tab.values() # returns a list of rows
Row
row is a subclass of list, with functionalities like update
and clear
row = await tab.get_row(1) # returns a Row
print(row)
update row
await row.update(['new', 'values'])
await row.clear() # clear all value of the row
Cell
cell is a subclass of string, with additional functionalities like update
and clear
cell = await tab.get_cell('A1') # returns a Cell
cell = row[0] # same as above
update cell
await cell.update('New cell value')
await cell.clear() # clear value of the cell
Project details
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
betterspread-0.1.9.tar.gz
(4.6 kB
view hashes)
Built Distribution
Close
Hashes for betterspread-0.1.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fe5ebd58201e4ef44b5c6fe0eebb4195387b6522555e96a724fc1d7c161718e6 |
|
MD5 | 5c1c99a81447f2b6e343648e37616158 |
|
BLAKE2b-256 | 4dbd03cbf9752ce04e6f123d38c80cf238163f8f452f00dc78a36664ad2f439c |