def test_insert_cols_rows(self):
cols = self.worksheet.cols
self.worksheet.insert_cols(1, 2)
assert self.worksheet.cols == (cols+2)
rows = self.worksheet.rows
self.worksheet.insert_rows(1, 2)
assert self.worksheet.rows == (rows + 2)
with pytest.raises(pygsheets.InvalidArgumentValue):
pygsheets.format_addr([1, 1])
def test_insert_cols_rows(self):
cols = self.worksheet.cols
self.worksheet.insert_cols(1, 2)
assert self.worksheet.cols == (cols + 2)
rows = self.worksheet.rows
self.worksheet.insert_rows(1, 2)
assert self.worksheet.rows == (rows + 2)
with pytest.raises(pygsheets.InvalidArgumentValue):
pygsheets.format_addr([1, 1])
def get_values(self,
start,
end,
returnas='matrix',
majdim='ROWS',
include_empty=True,
value_render=ValueRenderOption.UNFORMATTED):
values = self.client.get_range(self.spreadsheet.id,
self._get_range(start, end),
majdim.upper(),
value_render=value_render)
start = format_addr(start, 'tuple')
if not include_empty:
matrix = values
else:
max_cols = len(max(values, key=len))
matrix = [list(x + [''] * (max_cols - len(x))) for x in values]
if returnas == 'matrix':
return matrix
else:
cells = []
for k in range(len(matrix)):
row = []
for i in range(len(matrix[k])):
if majdim == 'COLUMNS':
row.append(
Cell((start[0] + i, start[1] + k), matrix[k][i],
self))
elif majdim == 'ROWS':
row.append(
Cell((start[0] + k, start[1] + i), matrix[k][i],
self))
else:
raise InvalidArgumentValue('majdim')
cells.append(row)
return cells
def test_addr_reformat(self):
addr = pygsheets.format_addr((1, 1))
assert addr == 'A1'
addr = pygsheets.format_addr('A1')
assert addr == (1, 1)
def test_addr_reformat(self):
addr = pygsheets.format_addr((1, 1))
assert addr == 'A1'
addr = pygsheets.format_addr('A1')
assert addr == (1, 1)