Python, a dynamic and versatile programming language, makes it simple to automate tasks. One of the most prevalent tasks that Python can automate is dealing with Excel spreadsheets. This tutorial will guide you through the steps on how to automatically interact with Excel using Python.
Step 1: Creating an Excel file.
Before running the code, create an Excel file called “example.xlsx” and put the following data inside.
Step 2: Importing openpyxl
After successfully installing the Openpyxl library, the next step is to import openpyxl into your Python script as follows:
|
1 |
import openpyxl |
Step 3: Opening and Reading Excel File
After importing openpyxl, you can start to interact with Excel. To read data from an Excel file, we first need to open the Excel file:
|
1 |
wb = openpyxl.load_workbook('example.xlsx') |
Step 4: Writing to Excel Files
Not only can you read from Excel files, but you can also write to them. Here is how to write ‘Hello’ to cell A1:
|
1 2 3 |
sheet = wb.active sheet['A1'] = 'Hello' wb.save('example.xlsx') |
Full Code
|
1 2 3 4 5 6 7 8 |
import openpyxl wb = openpyxl.load_workbook('example.xlsx') sheet = wb.active sheet['A1'] = 'Hello' wb.save('example.xlsx') |
Conclusion
Python provides a powerful and flexible approach to dealing with Excel files. With openpyxl and a few lines of code, you can automate the boring stuff, leaving you more time to focus on more important issues.
This tutorial has provided you with a brief introduction to using Python for Excel automation. The more you practice, the more you’ll understand and be capable of performing more complex tasks.