condad
diff --git a/‎README.md
Copy file name to clipboardExpand all lines: README.md
+3-3Lines changed: 3 additions & 3 deletions b/‎README.md
Copy file name to clipboardExpand all lines: README.md
+3-3Lines changed: 3 additions & 3 deletions
diff --git a/‎google_objects/sheets.py
Copy file name to clipboardExpand all lines: google_objects/sheets.py
+39-11Lines changed: 39 additions & 11 deletions b/‎google_objects/sheets.py
Copy file name to clipboardExpand all lines: google_objects/sheets.py
+39-11Lines changed: 39 additions & 11 deletions
diff --git a/‎google_objects/slides.py
Copy file name to clipboardExpand all lines: google_objects/slides.py
-8Lines changed: 0 additions & 8 deletions b/‎google_objects/slides.py
Copy file name to clipboardExpand all lines: google_objects/slides.py
-8Lines changed: 0 additions & 8 deletions
diff --git a/‎tests/test_drive.py
Copy file name to clipboardExpand all lines: tests/test_drive.py
-4Lines changed: 0 additions & 4 deletions b/‎tests/test_drive.py
Copy file name to clipboardExpand all lines: tests/test_drive.py
-4Lines changed: 0 additions & 4 deletions
@@ -10,7 +10,7 @@ Currently supports Python 2.7 :snake::snake::snake:
 ## Usage
 Requires a valid Google API Credentials object from Google's excellent oauth2lib library. For more information, visit [here](https://developers.google.com/identity/protocols/OAuth2).
 
-### Google Drive
+### Google Drive v3
 
 - [x] Retrieve drive 'About' information:
 
@@ -62,7 +62,7 @@ Requires a valid Google API Credentials object from Google's excellent oauth2lib
 	print permission.role, permission.type, permission.email
 ```
 
-### Google Slides
+### Google Slides v1
 
 - [x] Retrieve presentation and loop through elements:
 
@@ -105,7 +105,7 @@ Requires a valid Google API Credentials object from Google's excellent oauth2lib
 
 ```
 
-### Google Sheets
+### Google Sheets v4
 
 - [x] Retrieve spreadsheet and loop through sheets:
 
 
@@ -22,6 +22,7 @@
     # ii/ page title and descriptor need to be found and initialized
     # iii/ change .from_existing to .from_raw
 
+def grid_to_a1():
 
 class SheetsAPI(GoogleAPI):
 
@@ -78,14 +79,10 @@ def append_values(self, spreadsheet_id, rng, values):
     def push_updates(self, spreadsheet_id, updates):
         spreadsheets = self._resource.spreadsheets()
         spreadsheets.batchUpdate(
-            presentationId=spreadsheet_id,
+            spreadsheetId=spreadsheet_id,
             body={'requests': updates}
-        )
-        spreadsheets.execute()
-
-
-
-# objects
+        ).execute()
+        # spreadsheets.execute()
 
 
 class Spreadsheet(GoogleObject):
@@ -133,7 +130,7 @@ def title(self, value):
         self._properties['title'] = value
 
     def sheets(self):
-        return [ sheet for sheet in self.yield_sheets() ]
+        return [sheet for sheet in self.yield_sheets()]
 
     def yield_sheets(self):
         for sheet in self._sheets:
@@ -329,13 +326,18 @@ def yield_cells(self):
             for val in row:
                 yield self.Cell(self, val)
 
+    @property
     def cells(self):
         return [cell for cell in self.yield_cells()]
 
-    def rows(self):
+    def yield_rows(self):
         for row in self._values:
             yield [self.Cell(self, val) for val in row]
 
+    @property
+    def rows(self):
+        return [row for row in self.yield_rows()]
+
     def map(self, func):
         """Returns <Decimal> of block sum"""
         for row in self._rows:
@@ -389,5 +391,31 @@ def match(self, regex):
                 return True
             return False
 
-        def __str__(self):
-            return self.value
+
+class SheetsUpdate(object):
+
+    """creates google-api-wrapper ready batchUpdate
+    request dictionaries
+    """
+
+    @staticmethod
+    def format_row(sheet_id, start, end, red=0, green=0, blue=0):
+        return {
+            "repeatCell": {
+                "range": {
+                    "sheetId": sheet_id,
+                    "startRowIndex": start,
+                    "endRowIndex": end
+                },
+                "cell": {
+                    "userEnteredFormat": {
+                        "backgroundColor": {
+                            "red": red,
+                            "green": green,
+                            "blue": blue
+                        }
+                    }
+                },
+                "fields": "userEnteredFormat(backgroundColor)"
+            }
+        }
@@ -9,7 +9,6 @@
 
 import re
 import logging
-import httplib2
 
 from apiclient.errors import HttpError
 
@@ -84,10 +83,6 @@ def push_updates(self, presentation_id, updates):
         ).execute()
 
 
-
-# objects
-
-
 class Presentation(GoogleObject):
 
     """Google Presentation Object,
@@ -526,9 +521,6 @@ def __str__(self):
             print self.text
 
 
-# update requests
-
-
 class SlidesUpdate(object):
 
     """creates google-api-wrapper ready batchUpdate
 
@@ -42,10 +42,6 @@ def test_permissions(drive_file):
         type='user',
     )
 
-    # test properties
-    print 'as dict:'
-    print permission.__dict__
-
     assert hasattr(permission, 'id')
     assert hasattr(permission, 'email')
     assert hasattr(permission, 'role')