import
gspread
from
oauth2client.service_account
import
ServiceAccountCredentials
from
pprint
import
pprint
creds
=
ServiceAccountCredentials.from_json_keyfile_name(
"creds.json"
, scope)
client
=
gspread.authorize(creds)
sheet
=
client.
open
(
"Google Sheets API Tutorial"
).sheet1
data
=
sheet.get_all_records()
row4
=
sheet.row_values(
4
)
col2
=
sheet.col_values(
2
)
cell
=
sheet.cell(
5
,
2
).value
print
(
"Column 2 Data : "
)
pprint(col2)
print
(
"\nRow 4 Data : "
)
pprint(row4)
print
(
"\nCell (5,2) Data : "
)
pprint(cell)
print
(
"\nAll Records : "
)
pprint(data)
insertRow
=
[
6
,
"Soumodeep Naskar"
,
"Purple"
]
sheet.insert_row(insertRow,
4
)
print
(
"\nAll Records after inserting new row : "
)
pprint(data)
sheet.delete_row(
7
)
print
(
"\nAll Records after deleting row 7 : "
)
pprint(data)
sheet.update_cell(
5
,
2
,
"Nitin Das"
)
print
(
"\nAll Records after updating cell (5,2) : "
)
pprint(data)
numRows
=
sheet.row_count
numCol
=
sheet.col_count
print
(
"Number of Rows : "
, numRows)
print
(
"Number of Columns : "
, numCol)
print
(
"Number of Rows having content : "
,
len
(data))