spreadsheet_api.md

Spreadsheet Api

Auto-generated documentation for ocs_ci.utility.spreadsheet.spreadsheet_api module.

API module to interact with Google spreadsheets In order to create a new spreadsheet, share the spreadsheet with the 'client_email' in your credentials json file with write permissions.

• Ocs-ci / Modules / Ocs Ci / Utility / Spreadsheet / Spreadsheet Api
  • GoogleSpreadSheetAPI
    • GoogleSpreadSheetAPI().get_cell_value
    • GoogleSpreadSheetAPI().insert_row
    • GoogleSpreadSheetAPI().print_sheet
    • GoogleSpreadSheetAPI().update_sheet

GoogleSpreadSheetAPI

[find in source code]

class GoogleSpreadSheetAPI(object):
    def __init__(sheet_name, sheet_index):

A class to interact with Google Spreadsheet

GoogleSpreadSheetAPI().get_cell_value

[find in source code]

def get_cell_value(row, col):

GoogleSpreadSheetAPI().insert_row

[find in source code]

def insert_row(value, row_index=2):

GoogleSpreadSheetAPI().print_sheet

[find in source code]

def print_sheet():

GoogleSpreadSheetAPI().update_sheet

[find in source code]

def update_sheet(row, col, value):

Updates a row:col in a given spreadsheet