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)