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

That was a piece of cake! Now, we can also add whole rows of data in one loop:

row_list = [
  ["Time", "Event"],
  ["17:30", "Meeting with Jake"],
  ["20:00", "Cinema"] 
]
for row in row_list:
  ws.append(row)

As you can see, we've prepared a list of lists. Each list should be treated as a separate row that will be appended to a given worksheet, starting from column A and the first empty row.

Exercise

We've already selected the "Food" worksheet for you and given you a list of foods. Add them to the worksheet.

Save the modified workbook in the file budget.xlsx.