Answers for "google sheet in python"

4

google sheet python read

# google sheet package
from gsheets import Sheets

# Authorizing the api
#create oath credentials and generate a json file and paste here
sheets = Sheets.from_files('FD4GS.json', 'FD4GS_cache.json')



vi1 = sheets.get('#Paste your sheet id')

vi1_form1_ws = vi1.sheets[0] #Sheet range

entries1 = vi1_form1_ws.values()[1:] #Here I'm traversing from 2nd columns

entries1 = [(i[2], i[6], i[1]) for i in entries1] # This represent, in my spread sheet I have 6 columns
Posted by: Guest on August-09-2021
1

python to google sheets

# see the source first and follow the instuctions on it before running this script
# 

import pygsheets
import pandas as pd
#authorization
gc = pygsheets.authorize(service_file='/Users/erikrood/desktop/QS_Model/creds.json')

# Create empty dataframe
df = pd.DataFrame()

# Create a column
df['name'] = ['John', 'Steve', 'Sarah']

#open the google spreadsheet (where 'PY to Gsheet Test' is the name of my sheet)
sh = gc.open('PY to Gsheet Test')

#select the first sheet 
wks = sh[0]

#update the first sheet with df, starting at cell B2. 
wks.set_dataframe(df,(1,1))
Posted by: Guest on July-23-2021

Python Answers by Framework

Browse Popular Code Answers by Language