ocs_ci.utility.spreadsheet package

Submodules

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.

class ocs_ci.utility.spreadsheet.spreadsheet_api.GoogleSpreadSheetAPI(sheet_name, sheet_index)

Bases: object

A class to interact with Google Spreadsheet

get_cell_value(row, col)

insert_row(value, row_index=2)

print_sheet()

update_sheet(row, col, value)

Updates a row:col in a given spreadsheet

Module contents