Finds all cells matching the query. Returns a list of :class:`gspread.cell.Cell`. :param query: A literal string to match or compiled regular expression. :type query: str, :py:class:`re.RegexObject` :param int in_row: (optional) One-based row number to scope the sea
(
self,
query: Union[str, re.Pattern],
in_row: Optional[int] = None,
in_column: Optional[int] = None,
case_sensitive: bool = True,
)
| 2334 | return None |
| 2335 | |
| 2336 | def findall( |
| 2337 | self, |
| 2338 | query: Union[str, re.Pattern], |
| 2339 | in_row: Optional[int] = None, |
| 2340 | in_column: Optional[int] = None, |
| 2341 | case_sensitive: bool = True, |
| 2342 | ) -> List[Cell]: |
| 2343 | """Finds all cells matching the query. |
| 2344 | |
| 2345 | Returns a list of :class:`gspread.cell.Cell`. |
| 2346 | |
| 2347 | :param query: A literal string to match or compiled regular expression. |
| 2348 | :type query: str, :py:class:`re.RegexObject` |
| 2349 | :param int in_row: (optional) One-based row number to scope the search. |
| 2350 | :param int in_column: (optional) One-based column number to scope |
| 2351 | the search. |
| 2352 | :param bool case_sensitive: (optional) comparison is case sensitive if |
| 2353 | set to True, case insensitive otherwise. Default is True. |
| 2354 | Does not apply to regular expressions. |
| 2355 | :returns: the list of all matching cells or empty list otherwise |
| 2356 | :rtype: list |
| 2357 | """ |
| 2358 | |
| 2359 | return [ |
| 2360 | elem |
| 2361 | for elem in self._finder(filter, query, case_sensitive, in_row, in_column) |
| 2362 | ] |
| 2363 | |
| 2364 | def freeze( |
| 2365 | self, rows: Optional[int] = None, cols: Optional[int] = None |