Cell

class gspread.cell.Cell(row: int, col: int, value: str = '')

An instance of this class represents a single cell in a Worksheet.

property address: str

Cell address in A1 notation.

Type:

str

property col: int

Column number of the cell.

Type:

int

classmethod from_address(label: str, value: str = '') → Cell

Instantiate a new Cell from an A1 notation address and a value

Parameters:

• label (string) – the A1 label of the returned cell

• value (string) – the value for the returned cell

Return type:

Cell

property numeric_value: int | float | None

Numeric value of this cell.

Will try to numericise this cell value, upon success will return its numeric value with the appropriate type.

Type:

int or float

property row: int

Row number of the cell.

Type:

int

value: str

Value of the cell.