def iter_sheet(service: discovery.Resource,
sheet: Sheet) -> Generator[List[str], None, None]:
"Iterate over the contents of a particular sheet."
size = get_sheet_size(service, sheet)
resp = service.spreadsheets().values().batchGet(
spreadsheetId=sheet.docid,
ranges=sheets_upload.sheet_range(size[0], size[1],
sheet.name)).execute()
for row in resp['valueRanges'][0]['values']:
yield row
def test_sheet_range(self):
self.assertEqual('Balances!A1:T100',
sheets_upload.sheet_range(100, 20, 'Balances'))
self.assertEqual('A1:T100', sheets_upload.sheet_range(100, 20))