Skip to content

Latest commit

 

History

History
22 lines (11 loc) · 464 Bytes

tips.rst

File metadata and controls

22 lines (11 loc) · 464 Bytes

Some Tips

Note that in this article, wks means worksheet, ss means spreadsheet, gc means google client

easier way to acess sheet values:

for row in wks:
    print row[0]

Access sheets by id:

wks1 = ss[0]

Conversion of sheet data

usually all the values are converted to string while using get_* functions. But if you want then to retain their type, the change the value_render option to ValueRenderOption.UNFORMATTED_VALUE.