sheet updaterow( ['pumpkin'' '' '' ']sheet getrow( ['pumpkin'' '' '' '''''columnone sheet getcolumn( for ivalue in enumerate(columnone)make the python list contain uppercase stringscolumnone[ivalue upper(sheet updatecolumn( columnoneupdate the entire column in one request the getrow(and getcolumn(functions retrieve the data from every cell in specific row or column as list of values note that empty cells become blank string values in the list you can pass getcolumn(either column number or letter to tell it to retrieve specific column' data the previous example shows that getcolumn( and getcolumn(' 'return the same list the updaterow(and updatecolumn(functions will overwrite all the data in the row or columnrespectivelywith the list of values passed to the function in this examplethe third row initially contains information about okrabut the updaterow(call replaces it with data about pumpkin call sheet getrow( again to view the new values in the third row nextlet' update the "producesalesspreadsheet updating cells one at time is slow if you have many cells to update getting column or row as listupdating the listand then updating the entire column or row with the list is much fastersince all the changes can be made in one request to get all of the rows at oncecall the getrows(method to return list of lists the inner lists inside the outer list each represent single row of the sheet you can modify the values in this data structure to change the produce namepounds soldand total cost of some of the rows then you pass it to the updaterows(method by entering the following into the interactive shellrows sheet getrows(get every row in the spreadsheet rows[ examine the values in the first row ['produce''cost per pound''pounds sold''total'''''rows[ ['potatoes'' '' '' '''''rows[ ][ 'pumpkinchange the produce name rows[ ['pumpkin'' '' '' '''''rows[ ['okra'' '' '' '''''rows[ ][ ' change the pounds sold rows[ ][ ' change the total rows[ ['okra'' '' '' '''''sheet updaterows(rowsupdate the online spreadsheet with the changes you can update the entire sheet in single request by passing updaterows(the list of lists returned from getrows()amended with the changes made to rows and