Method update_cell

gspread/worksheet.py:745–767

Updates the value of a cell. :param int row: Row number. :param int col: Column number. :param value: New value. Example:: worksheet.update_cell(1, 1, '42')

(
        self, row: int, col: int, value: Union[int, float, str]
    )

        return self.update_cell(*(a1_to_rowcol(label)), value=value)

    def update_cell(
        self, row: int, col: int, value: Union[int, float, str]
    ) -> JSONResponse:
        """Updates the value of a cell.

        :param int row: Row number.
        :param int col: Column number.
        :param value: New value.

        Example::

            worksheet.update_cell(1, 1, '42')
        """
        range_name = absolute_range_name(self.title, rowcol_to_a1(row, col))

        data = self.client.values_update(
            self.spreadsheet_id,
            range_name,
            params={"valueInputOption": ValueInputOption.user_entered},
            body={"values": [[value]]},
        )

        return data

    def update_cells(
        self,