multiple users can update sheet simultaneously to refresh the local data in the sheet objectcall its refresh(methodsheet refresh(all of the data in the sheet object is loaded when the spreadsheet object is first loadedso the data is read instantly howeverwriting values to the online spreadsheet requires network connection and can take about second if you have thousands of cells to updateupdating them one at time might be quite slow column and row addressing cell addressing works in google sheets just like in excel the only difference is thatunlike python' -based list indexesgoogle sheets have -based columns and rowsthe first column or row is at index not you can convert the ' string-style address to the (columnrowtuplestyle address (and vice versawith the convertaddress(function the getcolumnletterof(and getcolumnnumberof(functions will also convert column address between letters and numbers enter the following into the interactive shellimport ezsheets ezsheets convertaddress(' 'converts addresses ( ezsheets convertaddress( and converts them backtoo ' ezsheets getcolumnletterof( 'bezsheets getcolumnnumberof(' ' ezsheets getcolumnletterof( 'alk