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