Open Google Sheet By Name
# 1. Authorizing google colab
from google.colab import auth
auth.authenticate_user()
# 2. credentials for google sheets
import gspread
from google.auth import default
creds, _ = default()
# 3. authotizing the connection
gc = gspread.authorize(creds)
#4. Connecting
worksheet = gc.open('gsht-sample').sheet1
#5. Exporting data to get_all_values gives a list of rows.
rows = worksheet.get_all_values()
# 6. Using pandas to convert to a DataFrame and render.
import pandas as pd
df = pd.DataFrame.from_records(rows)
#creating columns name
df.columns = df.iloc[0]
df = df.iloc[1:]
df
Open Google Sheet By ID
# 1. Authorizing
from google.colab import auth
auth.authenticate_user()
# 2. Credentials
import gspread
from google.auth import default
creds, _ = default()
# 3. Authorizing Credentials
gc = gspread.authorize(creds)
# 4. Importing Google Sheet using google sheet key
gsht= gc.open_by_key('1Nm1B8zl9j2w-kAo8-_PmUKNdwuBRj1kPbv-G4QJdueU')
# 5. Bring the tab you want to update
wsht = gsht.worksheet('Sheet1')
Update Cell
cell_list=wsht.range('E1:E2')
for cell in cell_list:
cell.value="test"
wsht.update_cells(cell_list)
cell_list
0 Comments