Method col_values

gspread/worksheet.py:696–731

Returns a list of all values in column `col`. Empty cells in this list will be rendered as :const:`None`. :param int col: Column number (one-based). :param str value_render_option: (optional) Determines how values should be rendered in the output. See `ValueRend

(
        self,
        col: int,
        value_render_option: ValueRenderOption = ValueRenderOption.formatted,
    )

            return []

    def col_values(
        self,
        col: int,
        value_render_option: ValueRenderOption = ValueRenderOption.formatted,
    ) -> List[Optional[Union[int, float, str]]]:
        """Returns a list of all values in column `col`.

        Empty cells in this list will be rendered as :const:`None`.

        :param int col: Column number (one-based).
        :param str value_render_option: (optional) Determines how values should
            be rendered in the output. See `ValueRenderOption`_ in
            the Sheets API.
        :type value_render_option: :class:`~gspread.utils.ValueRenderOption`

        .. _ValueRenderOption: https://developers.google.com/sheets/api/reference/rest/v4/ValueRenderOption
        """

        start_label = rowcol_to_a1(1, col)
        range_label = "{}:{}".format(start_label, start_label[:-1])

        range_name = absolute_range_name(self.title, range_label)

        data = self.client.values_get(
            self.spreadsheet_id,
            range_name,
            params={
                "valueRenderOption": value_render_option,
                "majorDimension": Dimension.cols,
            },
        )

        try:
            return data["values"][0]
        except KeyError:
            return []

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