Excel/XLSX Manipulation

Working with Excel files programmatically.

Python (openpyxl)

Reading Excel

from openpyxl import load_workbook

wb = load_workbook('data.xlsx')
ws = wb.active  # Get active sheet

# Read cell
value = ws['A1'].value

# Iterate rows
for row in ws.iter_rows(min_row=2, values_only=True):
    print(row)