Amaze your friends by painting images on Google Sheets using Python
Shashi Jeevan M. P. (~shashi3) |
Description:
Have you ever wondered how you could paint images in a Google spreadsheet?
Can you paint existing images in the Google sheet with accurate colors?
Can you do this by simply running a command and painting ANY pictures?
Google spreadsheet is popular as a data storage tool. Many open-source libraries are available for manipulating the data in Google Spreadsheets. These include
- gsheets
- pygsheets
- gspread
But, these have limitations when using Google Spreadsheet as a canvas, which I will describe in the session.
I had to build a custom library on top of the Python library provided by Google.
In this session, I will describe how to use Python for
- Setting up Google Sheets as Canvas,
- Reading image data and
- Using raw Google Spread Sheets API to generate requests and update the sheet with Image pixel data.
I will share the learning from using Python DataClasses to reduce code complexity and handle large images.
This work can be extended further to generate custom graphics and render on Google Sheets.
Prerequisites:
Basic knowledge of
- Python language
- Google Sheets
- JSON
Video URL:
https://youtu.be/H2J7bXMvqL4
Content URLs:
Presentation Link
https://docs.google.com/presentation/d/1MxHmHFKf3bpcK8ellfRt1naehDsdDjWOglKi91oiiH8/edit?usp=sharing
Source Code Link
Speaker Info:
Shashi Jeevan has over 25 years of experience in the software industry. He is a Certified Ethical Hacker (Practical). He is an Inventor of the US Patent (Number: 6,609,084, Issue Date: August 19, 2003). He is Vice President of Delivery and Deployment at Tekfriday Processing Solutions Pvt. Ltd. Where he is responsible for DevOps, Cloud, and Security. He is the founder of the Hyderabad Software Architects meetup group. He likes to tinker with technology and share his learnings. He has experience in presenting in multiple technical talks with large audiences. He has been using Python for various projects for more than 15 years.
Speaker Links:
My Previous presentations
Global Azure Bootcamp 2018
Topic: Introduction to Deep Learning on Azure Description: I have presented the fundamentals of Machine Learning and Deep Learning. Then demonstrated the training of the MNIST model using Keras with Jupyter Notebook on Azure VM. Later, I used a Flask App to detect the live hand-drawn digits using the trained model. I blogged about my experience of presenting.
Event Link: https://themugh.github.io/gabc2018
Slides: https://www.slideshare.net/shashijeevan/introduction-to-deep-learning-on-azure-global-azure-bootcamp-2018-95267374Global Azure Bootcamp 2019
Topic: Azure Kubernetes Service Description: I have presented the fundamentals of Docker and the need for Kubernetes. Then demonstrated the setup of managed Kubernetes using Azure Kubernetes Service. Later demonstrated scaling the cluster using kubctl.
Event Link: https://themugh.github.io/gabc2019/
Slides Not Available.
My Meetup group
Hyderabad Software Architects (https://www.meetup.com/Hyderabad-Software-Architects/)
I am the founder and organizer of this meetup. I have also presented sessions on Microservices, Cloud, Python, Machine Learning etc.
I have also got experts in the field to give sessions to improve collaboration among the Software Architects in Hyderabad.