Fix bugs in sample code.

Eric Koleda · web-flow · commit 60e2e421b03d · 2019-06-03T09:28:00.000-04:00
diff --git a/sheets/snippets/spreadsheet_snippets.py b/sheets/snippets/spreadsheet_snippets.py
@@ -72,7 +72,7 @@ def get_values(self, spreadsheet_id, range_name):
         # [START sheets_get_values]
         result = service.spreadsheets().values().get(
             spreadsheetId=spreadsheet_id, range=range_name).execute()
-        numRows = result.get('values') if result.get('values')is not None else 0
+        numRows = len(result.get('values')) if result.get('values') is not None else 0
         print('{0} rows retrieved.'.format(numRows))
         # [END sheets_get_values]
         return result
@@ -88,7 +88,8 @@ def batch_get_values(self, spreadsheet_id, _range_names):
         # [END_EXCLUDE]
         result = service.spreadsheets().values().batchGet(
             spreadsheetId=spreadsheet_id, ranges=range_names).execute()
-        print('{0} ranges retrieved.'.format(result.get('valueRanges')))
+        numRanges = len(result.get('valueRanges')) if result.get('valueRanges') is not None else 0
+        print('{0} ranges retrieved.'.format(numRanges)
         # [END sheets_batch_get_values]
         return result
 
@@ -141,7 +142,7 @@ def batch_update_values(self, spreadsheet_id, range_name,
         }
         result = service.spreadsheets().values().batchUpdate(
             spreadsheetId=spreadsheet_id, body=body).execute()
-        print('{0} cells updated.'.format(result.get('updatedCells')))
+        print('{0} cells updated.'.format(result.get('totalUpdatedCells')))
         # [END sheets_batch_update_values]
         return result
 
