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
Cells
Summary

Instruction

Great! Once we know how to access a given worksheet, it would also be nice to be able to access particular cells.

We can retrieve a given cell from the sweets_ws worksheet by using the cell method:

sweets_ws.cell(row=1, column=1)

The cell method accepts two arguments: row and column, which together point to the exact position of a cell. As you can see, we have to specify the row and column using integers.

Exercise

Access the summary worksheet and the cell from the 5th row, 3rd column. (We've already loaded the file for you.) Assign the cell to the selected_cell variable and print the variable.