• Szerző: Sallai András
• Copyright © 2021, Sallai András
• Licenc: CC BY-SA 4.0
• Web: https://szit.hu

pip install openpyxl

main.py

from openpyxl import Workbook
 
wb = Workbook()
ws = wb.active
ws['B2'] = 25
path = 'valami.xlsx'
wb.save(path)

main.py

from openpyxl import load_workbook
 
path = 'valami.xlsx'
wb = load_workbook(path)
 
print(wb.sheetnames)
 
wb.save(path)

main.py

from openpyxl import load_workbook
 
path = 'valami.xlsx'
wb = load_workbook(path)
sheet = wb.worksheets[0]
sheet.cell(row = 1, column = 1).value = 35
sheet.cell(row = 2, column = 1).value = 42
sheet.cell(row = 3, column = 1).value = 16
sheet.cell(row = 4, column = 1).value = '=sum(a1:a3)'
 
wb.save(path)

main.py

from openpyxl import load_workbook
 
path = 'valami.xlsx'
wb = load_workbook(path)
sheet = wb.worksheets[0]
sheet['a1'] = 25
sheet['a2'] = 42
sheet['a3'] = 15
 
sheet['a4'] = '=sum(a1:a3)'
 
wb.save(path)

main.py

from openpyxl import load_workbook
 
path = 'valami.xlsx'
wb = load_workbook(path)
sheet = wb.active
cell = sheet.cell(row = 2, column = 2)
print(cell.value)

main.py

from openpyxl import load_workbook
 
path = 'valami.xlsx'
wb = load_workbook(path)
sheet = wb.worksheets[0]
cell = sheet.cell(row = 2, column = 2)
print(cell.value)

• https://openpyxl.readthedocs.io/en/stable/ (2021)
• https://www.geeksforgeeks.org/python-reading-excel-file-using-openpyxl-module/ (2021)