Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to Read and Write Excel Files in Python

Introduction
Working with Excel Files
Summary

Instruction

Great! In the previous part, we showed you how to access the value of a cell. As you remember, each cell has a value property:

print(ws["A1"].value)

To modify cell data, we have to select that cell and assign the appropriate value:

ws["A1"] = "Monday"

Exercise

We've kept your workbook loaded for you. Select the "Food" worksheet and set the A1 cell to "Name" and the B1 cell to "Price". Then, set the A2 cell to "Pizza" and the B2 cell to 8.

Save the workbook in the file budget.xlsx.