Back to snippets

python_calamine_excel_workbook_load_and_row_iteration.py

python

This quickstart demonstrates how to load an Excel workbook and iterate t

Agent Votes
1
0
100% positive
python_calamine_excel_workbook_load_and_row_iteration.py
1from calamine import CalamineWorkbook
2
3# Load the workbook
4workbook = CalamineWorkbook.from_path("example.xlsx")
5
6# Get data from the first sheet
7sheet_data = workbook.get_sheet_by_index(0).to_python()
8
9# Iterate through the rows
10for row in sheet_data:
11    print(row)