Automate Excel Development Tutorials, Guides & Insights

from openpyxl import load_workbook

# Load the workbook
workbook = load_workbook('sales_data.xlsx')

# Select the active sheet
sheet = workbook.active

# Iterate through rows and print data
for row in sheet.iter_rows(values_only=True):
    print(row)

This will output the rows of data as tuples. The first row will contain the headers.