How to write data to an Excel file using Python

A guide on how to use Python to write data into an Excel file using the openpyxl library, making it easy to manage and handle Excel data in your projects.

In this article, we will explore how to use the openpyxl library in Python to write data into an Excel file. This is particularly useful when you need to handle and export data in a spreadsheet format, making data analysis more straightforward and flexible.

from openpyxl import Workbook

# Initialize a new Workbook
workbook = Workbook()

# Access the active worksheet
sheet = workbook.active

# Write data into the cells
sheet["A1"] = "Name"
sheet["B1"] = "Age"
sheet["A2"] = "John Doe"
sheet["B2"] = 28
sheet["A3"] = "Jane Smith"
sheet["B3"] = 24

# Save the Excel file with the name 'data.xlsx'
workbook.save("data.xlsx")

Detailed Explanation

1. from openpyxl import Workbook: Import Workbook from the openpyxl library to handle Excel files.
2. workbook = Workbook(): Create a new workbook.
3. sheet = workbook.active: Access the active sheet within the workbook.
4. sheet["A1"] = "Name" and sheet["B1"] = "Age": Write data into cells A1 and B1.
5. workbook.save("data.xlsx"): Save the workbook into a file named data.xlsx.

System Requirements

• Python: Version 3.6 or higher
• Library: openpyxl

How to install the required library

Install openpyxl using the following command:

pip install openpyxl

Tips

• Make sure you have installed the openpyxl library before running the code.
• Choose a clear and memorable file name to avoid confusion when saving.