import openpyxl
## Workbook wb = openpyxl.load_workbook('sample.xlsx') wb = openpyxl.Workbook() wb.save('sample.xlsx') wb.sheetnames
## Worksheet ws = wb['Sheet'] ws = wb.worksheets[0] ws.title
## Cell A1 c1 = ws['A1'] c1 = ws.cell(1, 1) c1.coordinate c1.row c1.column c1.value = 100 ## Cell A2 c2 = ws['A2'] c2 = ws.cell(2, 1) c2.value = "=SUM(A1:A1)"
## Region r1 = ws['A1:C3']