openpyxl_create_workbook_with_multiple_sheets_and_cell_data.py

1from openpyxl import Workbook
2from openpyxl.utils import get_column_letter
3
4wb = Workbook()
5
6dest_filename = 'empty_book.xlsx'
7
8ws1 = wb.active
9ws1.title = "range names"
10
11for row in range(1, 40):
12    ws1.append(range(600))
13
14ws2 = wb.create_sheet(title="Pi")
15
16ws2['F5'] = 3.14
17
18ws3 = wb.create_sheet(title="Data")
19for row in range(10, 20):
20    for col in range(27, 54):
21        _ = ws3.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))
22
23print(ws3['AA10'].value)
24wb.save(filename=dest_filename)