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
14. Exercise 2

Instruction

Great! How about this one?

Exercise

Add the prepared rows of data to the worksheets that have the same names as the variables (products and clients). Then add three rows to the orders worksheet:

  • ["client_id", "product_id"]
  • [2, 4]
  • [1, 2]

Save the workbook to the modified_orders.xlsx file.

We've already loaded a workbook for you and assigned it to the wb variable.