SheetReader

Iterate through rows of Google Spreadsheet as if it were a Python CSV DictReader or DictWriter.

Getting Started

For a full example, see example.py or watch a quick Youtube demo

    reader = SheetReader(
        workbook_id = 'workbook_id_123', 
        sheet_name = 'Sheet1', 
        header_range=('A1', 'D1'
        data_range = ('A1','D10')
    )

    for row in reader:
        name = row["name"]
        print "Hello", name
        row["Reversed Name"] = name[::-1]