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¶