sheet.cell(row=1, column=2).value
# get values of 'animals' sheet
for i in range(1, 4):
print(i, sheet.cell(row=i, column=2).value)
import openpyxl
wb = load_workbook(filename='xxxx.xlsx')
ws = wb.worksheets[0]
ws['A1'] = 1
ws.cell(row=2, column=2).value = 2
ws.cell(coordinate="C3").value = 3 # 'coordinate=' is optional here