DeveloperBreeze

Openpyxl Development Tutorials, Guides & Insights

Unlock 1+ expert-curated openpyxl tutorials, real-world code snippets, and modern dev strategies. From fundamentals to advanced topics, boost your openpyxl skills on DeveloperBreeze.

Tutorial
python

Automating Excel Reports with Python and OpenPyXL 

# Add a new sheet for the summary
summary = workbook.create_sheet('Summary')

# Calculate total sales for all products
total_sales = sum(sheet.cell(row=row, column=5).value for row in range(2, sheet.max_row + 1))

# Find the highest-selling product
highest_sales = max(sheet.cell(row=row, column=5).value for row in range(2, sheet.max_row + 1))
highest_product = None
for row in range(2, sheet.max_row + 1):
    if sheet.cell(row=row, column=5).value == highest_sales:
        highest_product = sheet.cell(row=row, column=1).value
        break

# Write summary data
summary.cell(row=1, column=1, value="Total Sales")
summary.cell(row=1, column=2, value=total_sales)
summary.cell(row=2, column=1, value="Highest-Selling Product")
summary.cell(row=2, column=2, value=highest_product)

# Save the updated workbook
workbook.save('sales_report_with_summary.xlsx')

After completing the above steps, you will have a fully automated Excel report with:

Dec 10, 2024
Read More