Schlagwort: WorkBook

# pip install openpyxl
from openpyxl import load_workbook, Workbook

# Workbook erzeugen
wb = Workbook()
# Worksheet
ws = wb.active
ws.title = 'Test1'

# Workbook speichern
wb.save('test1.xlsx')

# Workbook laden
wb2 = load_workbook(filename = 'test2.xlsx')

Links

• https://www.pluralsight.com/guides/importing-data-from-excel-with-python
• https://www.askpython.com/python/modulenotfounderror-no-module-named-openpyxl