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

Amazing! The cell's value is not the only data we can obtain from it. There are also row, column, and coordinate data:

ws["A1"].row
ws["A1"].column
ws["A1"].coordinate

The row property returns an integer that indicates the row number of a given cell. The column property returns the number (not letter) of a column. The coordinate property returns the cell's complete location, in A1 notation.

Exercise

Run the code in the Code Editor. Observe the row, column, and coordinate properties for the B4 cell.