Cell

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

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

property address

Cell address in A1 notation.

Type

str

property col

Column number of the cell.

Type

int

classmethod from_address(label, value='')

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

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

Row number of the cell.

Type

int

value

Value of the cell.