betterspread

Name	betterspread JSON
Version	0.2.2 JSON
	download
home_page	None
Summary	None
upload_time	2024-04-12 05:11:59
maintainer	None
docs_url	None
author	Md Shahriyar Alam
requires_python	<4.0,>=3.9
license	MIT
keywords
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # Better Spread
A wrapper around gspread with cell and row level functionalities

## Sheet

```python
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
```python
await tab.values() # returns a list of rows
```

### Row
row is a subclass of list, with functionalities like `update` and `clear`
```python
row = await tab.get_row(1) # returns a Row
print(row)
```

### update row
```python
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`
```python
cell = await tab.get_cell('A1') # returns a Cell
cell = row[0] # same as above
```

### update cell
```python
await cell.update('New cell value')
await cell.clear() # clear value of the cell
```
            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "betterspread",
    "maintainer": null,
    "docs_url": null,
    "requires_python": "<4.0,>=3.9",
    "maintainer_email": null,
    "keywords": null,
    "author": "Md Shahriyar Alam",
    "author_email": "contact@shahriyar.dev",
    "download_url": "https://files.pythonhosted.org/packages/11/5b/a6705cf0b34f865a0a24ea22215d5c51c79c60076efabe555ad03b6d2449/betterspread-0.2.2.tar.gz",
    "platform": null,
    "description": "# Better Spread\nA wrapper around gspread with cell and row level functionalities\n\n## Sheet\n\n```python\nfrom betterspread import Sheet, Connection\n\ncon = Connection(credentials_path=\"./credentials.json\")\nsheet = Sheet(connection=con, sheet_name=\"Better Sheet\")\ntab = await sheet.get_tab('Sheet1')\n```\n`Sheet` is a subclass of gsprad's `Spreadsheet`\n\n### get all values\n```python\nawait tab.values() # returns a list of rows\n```\n\n### Row\nrow is a subclass of list, with functionalities like `update` and `clear`\n```python\nrow = await tab.get_row(1) # returns a Row\nprint(row)\n```\n\n### update row\n```python\nawait row.update(['new', 'values'])\nawait row.clear() # clear all value of the row\n```\n### Cell\ncell is a subclass of string, with additional functionalities like `update` and `clear`\n```python\ncell = await tab.get_cell('A1') # returns a Cell\ncell = row[0] # same as above\n```\n\n### update cell\n```python\nawait cell.update('New cell value')\nawait cell.clear() # clear value of the cell\n```",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": null,
    "version": "0.2.2",
    "project_urls": {
        "Bug Tracker": "https://github.com/shahriyardx/betterspread/issues",
        "homepage": "https://github.com/shahriyardx/betterspread",
        "repository": "https://github.com/shahriyardx/betterspread"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "91c744db080ab4f44b36181e9b5d61918fcde3b0851bfa9960636a663588e685",
                "md5": "49ecd0c1ef17bfaf5f60cedf2ce690da",
                "sha256": "7c1705d41e4c71af68ad09478cced8b655dac19390556af3820562865555c655"
            },
            "downloads": -1,
            "filename": "betterspread-0.2.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "49ecd0c1ef17bfaf5f60cedf2ce690da",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": "<4.0,>=3.9",
            "size": 6590,
            "upload_time": "2024-04-12T05:11:57",
            "upload_time_iso_8601": "2024-04-12T05:11:57.705949Z",
            "url": "https://files.pythonhosted.org/packages/91/c7/44db080ab4f44b36181e9b5d61918fcde3b0851bfa9960636a663588e685/betterspread-0.2.2-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "115ba6705cf0b34f865a0a24ea22215d5c51c79c60076efabe555ad03b6d2449",
                "md5": "9d95da461bb5d222a67ae81ba4993605",
                "sha256": "b6de78d5bbffbf08ccb2ba3d6b214fbc8d3dbe855753d917d45f25891ffbfc01"
            },
            "downloads": -1,
            "filename": "betterspread-0.2.2.tar.gz",
            "has_sig": false,
            "md5_digest": "9d95da461bb5d222a67ae81ba4993605",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": "<4.0,>=3.9",
            "size": 4619,
            "upload_time": "2024-04-12T05:11:59",
            "upload_time_iso_8601": "2024-04-12T05:11:59.627369Z",
            "url": "https://files.pythonhosted.org/packages/11/5b/a6705cf0b34f865a0a24ea22215d5c51c79c60076efabe555ad03b6d2449/betterspread-0.2.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-04-12 05:11:59",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "shahriyardx",
    "github_project": "betterspread",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "lcname": "betterspread"
}