Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
data = self.spreadsheet.values_get(range_label)
start, end = name.split(':')
(row_offset, column_offset) = a1_to_rowcol(start)
(last_row, last_column) = a1_to_rowcol(end)
values = data.get('values', [])
rect_values = fill_gaps(
values,
rows=last_row - row_offset + 1,
cols=last_column - column_offset + 1
)
return [
Cell(row=i + row_offset, col=j + column_offset, value=value)
for i, row in enumerate(rect_values)
for j, value in enumerate(row)
]
"""
range_label = '%s!%s' % (self.title, rowcol_to_a1(row, col))
data = self.spreadsheet.values_get(
range_label,
params={'valueRenderOption': value_render_option}
)
try:
value = data['values'][0][0]
except KeyError:
value = ''
return Cell(row, col, value)
def _finder(self, func, query):
data = self.spreadsheet.values_get(self.title)
try:
values = fill_gaps(data['values'])
except KeyError:
values = []
cells = [
Cell(row=i + 1, col=j + 1, value=value)
for i, row in enumerate(values)
for j, value in enumerate(row)
]
if isinstance(query, basestring):
match = lambda x: x.value == query
else:
match = lambda x: query.search(x.value)
return func(match, cells)