MicroPython-GoogleSheet
=======================
Update or append the data to Google Sheet, or get the data on Google
Sheet. by using HTTP to execute the Google Apps Script API. Compatible
with ESP32.
Full Documentation
==================
Github: https://github.com/PerfecXX/MicroPython-GoogleSheet
Quick Example
=============
.. code:: python
# Import Library
from ggsheet import MicroGoogleSheet
from network import WLAN,STA_IF
# Network Creadential
ssid = "Change_SSID"
password = "Change_Password"
# Connect to Network
sta_if = WLAN(STA_IF)
sta_if.active(True)
if not sta_if.isconnected():
print("Connecting to wifi: ", ssid)
sta_if.connect(ssid, password)
while not sta_if.isconnected():
pass
print("Connection successful")
# Google Sheet Credential
google_sheet_url = "https://docs.google.com/spreadsheets/d/xxxxxxxxx/edit#gid=0"
google_sheet_name = "Sheet1"
google_app_deployment_id = "xxxxxxxx"
# Create Instance
ggsheet = MicroGoogleSheet(google_sheet_url,google_sheet_name)
ggsheet.set_DeploymentID(google_app_deployment_id)
# Update the data to a specific cell (Row,Column,Data)
ggsheet.updateCell(1,1,"Hello this is my first data")
# Get the data from a specific cell (Row,Column)
print(ggsheet.getCell(1,1))
# Delete the data from a specific cell (Row,Column)
ggsheet.deleteCell(1,1)
# Append the data to a specific row (Row, Data List)
ggsheet.appendRow(1,[1,2,3,"Row 1 Appended!"])
# Update the data in a specific row (Row, Data List)
ggsheet.updateRow(1,[3,2,1,"Row 1 Updated!"])
# Get all of the data from a specific row (Row)
ggsheet.getRow(1)
# Delete the data in a specific row (Row)
ggsheet.deleteRow(1)
# Append the data to a specific column (Column, Data List)
ggsheet.appendColumn(1,[1,2,3,"Column 1 Appended!"])
# Update the data to a specific column (Column, Data List)
ggsheet.updateColumn(1,[3,2,1,"Column 1 Updated!"])
# Get all of the data from a specific column (Column)
ggsheet.getColumn(1)
# Delete the data in a specific column (Column)
ggsheet.deleteColumn(1)
Raw data
{
"_id": null,
"home_page": "https://github.com/PerfecXX/MicroPython-GoogleSheet",
"name": "micropython-googlesheet",
"maintainer": "Teeraphat Kullanankanjana",
"docs_url": null,
"requires_python": null,
"maintainer_email": "ku.teeraphat@gmail.com",
"keywords": "googlesheet, esp32, micropython",
"author": "Teeraphat Kullanankanjana",
"author_email": "ku.teeraphat@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/a3/58/44a9df903730ef4a6e6f9143498d88b61368fd7e005b9225950cebb8e87f/micropython-googlesheet-0.0.5.tar.gz",
"platform": null,
"description": "MicroPython-GoogleSheet\r\n=======================\r\n\r\nUpdate or append the data to Google Sheet, or get the data on Google\r\nSheet. by using HTTP to execute the Google Apps Script API. Compatible\r\nwith ESP32.\r\n\r\nFull Documentation\r\n==================\r\n\r\nGithub: https://github.com/PerfecXX/MicroPython-GoogleSheet\r\n\r\nQuick Example\r\n=============\r\n\r\n.. code:: python\r\n\r\n # Import Library \r\n from ggsheet import MicroGoogleSheet\r\n from network import WLAN,STA_IF\r\n\r\n # Network Creadential \r\n ssid = \"Change_SSID\" \r\n password = \"Change_Password\"\r\n\r\n # Connect to Network\r\n sta_if = WLAN(STA_IF)\r\n sta_if.active(True)\r\n if not sta_if.isconnected():\r\n print(\"Connecting to wifi: \", ssid)\r\n sta_if.connect(ssid, password)\r\n while not sta_if.isconnected():\r\n pass\r\n print(\"Connection successful\")\r\n\r\n # Google Sheet Credential \r\n google_sheet_url = \"https://docs.google.com/spreadsheets/d/xxxxxxxxx/edit#gid=0\"\r\n google_sheet_name = \"Sheet1\"\r\n google_app_deployment_id = \"xxxxxxxx\"\r\n\r\n # Create Instance \r\n ggsheet = MicroGoogleSheet(google_sheet_url,google_sheet_name)\r\n ggsheet.set_DeploymentID(google_app_deployment_id)\r\n\r\n # Update the data to a specific cell (Row,Column,Data)\r\n ggsheet.updateCell(1,1,\"Hello this is my first data\")\r\n\r\n # Get the data from a specific cell (Row,Column)\r\n print(ggsheet.getCell(1,1))\r\n\r\n # Delete the data from a specific cell (Row,Column)\r\n ggsheet.deleteCell(1,1)\r\n\r\n # Append the data to a specific row (Row, Data List)\r\n ggsheet.appendRow(1,[1,2,3,\"Row 1 Appended!\"])\r\n\r\n # Update the data in a specific row (Row, Data List) \r\n ggsheet.updateRow(1,[3,2,1,\"Row 1 Updated!\"])\r\n\r\n # Get all of the data from a specific row (Row)\r\n ggsheet.getRow(1)\r\n\r\n # Delete the data in a specific row (Row)\r\n ggsheet.deleteRow(1)\r\n\r\n # Append the data to a specific column (Column, Data List)\r\n ggsheet.appendColumn(1,[1,2,3,\"Column 1 Appended!\"])\r\n\r\n # Update the data to a specific column (Column, Data List)\r\n ggsheet.updateColumn(1,[3,2,1,\"Column 1 Updated!\"])\r\n\r\n # Get all of the data from a specific column (Column)\r\n ggsheet.getColumn(1)\r\n\r\n # Delete the data in a specific column (Column)\r\n ggsheet.deleteColumn(1) \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Update or append the data to Google Sheet, or get the data on Google Sheet. by using HTTP to execute the Google Apps Script API compatible with ESP32.",
"version": "0.0.5",
"project_urls": {
"Homepage": "https://github.com/PerfecXX/MicroPython-GoogleSheet"
},
"split_keywords": [
"googlesheet",
" esp32",
" micropython"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "a35844a9df903730ef4a6e6f9143498d88b61368fd7e005b9225950cebb8e87f",
"md5": "118035c414168ab6cfdcd623e9ca475d",
"sha256": "044b5d820442814ad62059fc021868828cb408fc0102df5a0bf4cd373f66a75f"
},
"downloads": -1,
"filename": "micropython-googlesheet-0.0.5.tar.gz",
"has_sig": false,
"md5_digest": "118035c414168ab6cfdcd623e9ca475d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3972,
"upload_time": "2024-09-15T09:05:46",
"upload_time_iso_8601": "2024-09-15T09:05:46.846753Z",
"url": "https://files.pythonhosted.org/packages/a3/58/44a9df903730ef4a6e6f9143498d88b61368fd7e005b9225950cebb8e87f/micropython-googlesheet-0.0.5.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-15 09:05:46",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "PerfecXX",
"github_project": "MicroPython-GoogleSheet",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "micropython-googlesheet"
}
JSON
