Python
Fonksiyonlar
Dosya işlemleri
Veri dönüştürme
Lisans: MIT
Python — iterating_over_cells_in_rows.py
Python — Fonksiyonlar, Dosya işlemleri, Veri dönüştürme. Fonksiyonlar: iterating_over_values.
# iterating_over_cells_in_rows.py
from openpyxl import load_workbook
def iterating_over_values(path, sheet_name):
workbook = load_workbook(filename=path)
if sheet_name not in workbook.sheetnames:
print(f"'{sheet_name}' not found. Quitting.")
return
sheet = workbook[sheet_name]
for value in sheet.iter_rows(
min_row=1, max_row=3, min_col=1, max_col=3,
values_only=False):
print(value)
if __name__ == "__main__":
iterating_over_values("books.xlsx", sheet_name="Sheet 1 - Books")