chiboyap · October 20, 2021 00:26
diff --git a/cell.py b/cell.py
 # get the total number of columns
 sheet_instance.col_count
 ## >> 26


 # get the value at the specific cell
 sheet_instance.cell(col=3,row=2)
 ## >> <Cell R2C3 '63881'>
diff --git a/client.py b/client.py
 # get the instance of the Spreadsheetsheet_instance = sheet.get_worksheet(0)
 sheet = client.open('commentary data')
diff --git a/get_records.py b/get_records.py
 # get all the records of the data
 records_data = sheet_instance.get_all_records()

 # view the data
 records_data
diff --git a/instance.py b/instance.py
 sheet_instance = sheet.get_worksheet(0)
diff --git a/libraries.py b/libraries.py
 # importing the required libraries
 import gspread
 import pandas as pd
 from oauth2client.service_account import ServiceAccountCredentials
diff --git a/scope.py b/scope.py
 # define the scope
 scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']

 # add credentials to the account
 creds = ServiceAccountCredentials.from_json_keyfile_name('My Sample Project-61da96a5184b.json', scope)

 # authorize the clientsheet = client.open('commentary data')
 client = gspread.authorize(creds)
	# get the total number of columns
	sheet_instance.col_count
	## >> 26


	# get the value at the specific cell
	sheet_instance.cell(col=3,row=2)
	## >> <Cell R2C3 '63881'>
	# get the instance of the Spreadsheetsheet_instance = sheet.get_worksheet(0)
	sheet = client.open('commentary data')
	# get all the records of the data
	records_data = sheet_instance.get_all_records()

	# view the data
	records_data
	# importing the required libraries
	import gspread
	import pandas as pd
	from oauth2client.service_account import ServiceAccountCredentials
	# define the scope
	scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']

	# add credentials to the account
	creds = ServiceAccountCredentials.from_json_keyfile_name('My Sample Project-61da96a5184b.json', scope)

	# authorize the clientsheet = client.open('commentary data')
	client = gspread.authorize(creds)