How to Read and Write Excel Files in Python

14/16 Exercise 2

1. Introduction

2. Creating and saving a workbook

3. Default worksheet

4. Adding new worksheets

5. Removing a worksheet

6. Copying a worksheet

7. Modifying cell data

8. Adding a row of data

9. Adding multiple rows of data

10. Modifying data in columns

11. Deleting rows and columns

Great! How about this one?

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.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Select your platform

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Need assistance?