openpyxl code example


A complete example that exposes prometheus metrics endpoint under /metrics/ path in starlette.

from openpyxl import Workbook
wb = Workbook()

# grab the active worksheet
ws =

# Data can be assigned directly to cells
ws['A1'] = 42

# Rows can also be appended
ws.append([1, 2, 3])

# Python types will automatically be converted
import datetime
ws['A2'] =

# Save the file"sample.xlsx")

Code example provided by the project.

About openpyxl

openpyxl - a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.