openpyxl_create_excel_workbook_add_data_and_save.py

1from openpyxl import Workbook
2import datetime
3
4# Create a new workbook and select the active worksheet
5wb = Workbook()
6ws = wb.active
7
8# Data can be assigned directly to cells
9ws['A1'] = 42
10
11# Rows can also be appended
12ws.append([1, 2, 3])
13
14# Python types will automatically be converted
15ws['A2'] = datetime.datetime.now()
16
17# Save the file
18wb.save("sample.xlsx")