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

1. gsheets
2. pygsheets
3. 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

1. Setting up Google Sheets as Canvas,
2. Reading image data and
3. 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

1. Python language
2. Google Sheets
3. JSON

Video URL:

https://youtu.be/H2J7bXMvqL4

Content URLs:

Presentation Link

https://docs.google.com/presentation/d/1MxHmHFKf3bpcK8ellfRt1naehDsdDjWOglKi91oiiH8/edit?usp=sharing

Source Code Link

https://github.com/shashijeevan/ImageToGoogleSheet

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 Blog on the topic

My Personal Blog

My LinkedIn Profile

My Previous presentations

1. 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-95267374

2. Global 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.