Index

A

a1_range_to_grid_range() (in module gspread.utils) a1_to_rowcol() (in module gspread.utils) absolute_range_name() (in module gspread.utils) accept_ownership() (gspread.spreadsheet.Spreadsheet method) accepted_kwargs() (in module gspread.utils) acell() (gspread.worksheet.Worksheet method) add_cols() (gspread.worksheet.Worksheet method) add_dimension_group_columns() (gspread.worksheet.Worksheet method) add_dimension_group_rows() (gspread.worksheet.Worksheet method)

add_protected_range() (gspread.worksheet.Worksheet method) add_rows() (gspread.worksheet.Worksheet method) add_worksheet() (gspread.spreadsheet.Spreadsheet method) address (gspread.cell.Cell property) APIError append_row() (gspread.worksheet.Worksheet method) append_rows() (gspread.worksheet.Worksheet method) authorize() (in module gspread) (in module gspread.auth)

B

BackoffClient (class in gspread.client) batch_clear() (gspread.worksheet.Worksheet method) batch_format() (gspread.worksheet.Worksheet method)

batch_get() (gspread.worksheet.Worksheet method) batch_update() (gspread.spreadsheet.Spreadsheet method) (gspread.worksheet.Worksheet method)

C

cast_to_a1_notation() (in module gspread.utils) Cell (class in gspread.cell) cell() (gspread.worksheet.Worksheet method) cell_list_to_rect() (in module gspread.utils) CellNotFound clear() (gspread.worksheet.Worksheet method) clear_basic_filter() (gspread.worksheet.Worksheet method) clear_note() (gspread.worksheet.Worksheet method) clear_notes() (gspread.worksheet.Worksheet method) clear_tab_color() (gspread.worksheet.Worksheet method) Client (class in gspread) col (gspread.cell.Cell property)

col_count (gspread.worksheet.Worksheet property) col_values() (gspread.worksheet.Worksheet method) column_letter_to_index() (in module gspread.utils) columns_auto_resize() (gspread.worksheet.Worksheet method) combined_merge_values() (in module gspread.utils) console_flow() (in module gspread.auth) convert_credentials() (in module gspread.utils) copy() (gspread.Client method) copy_range() (gspread.worksheet.Worksheet method) copy_to() (gspread.worksheet.Worksheet method) create() (gspread.Client method) creationTime (gspread.spreadsheet.Spreadsheet property) cut_range() (gspread.worksheet.Worksheet method)

D

DateTimeOption (in module gspread.utils) define_named_range() (gspread.worksheet.Worksheet method) del_spreadsheet() (gspread.Client method) del_worksheet() (gspread.spreadsheet.Spreadsheet method) del_worksheet_by_id() (gspread.spreadsheet.Spreadsheet method) delete_columns() (gspread.worksheet.Worksheet method) delete_dimension() (gspread.worksheet.Worksheet method) delete_dimension_group_columns() (gspread.worksheet.Worksheet method)

delete_dimension_group_rows() (gspread.worksheet.Worksheet method) delete_named_range() (gspread.worksheet.Worksheet method) delete_protected_range() (gspread.worksheet.Worksheet method) delete_row() (gspread.worksheet.Worksheet method) delete_rows() (gspread.worksheet.Worksheet method) Dimension (in module gspread.utils) duplicate() (gspread.worksheet.Worksheet method) duplicate_sheet() (gspread.spreadsheet.Spreadsheet method)

E

export() (gspread.Client method) (gspread.spreadsheet.Spreadsheet method) (gspread.worksheet.Worksheet method)

ExportFormat (in module gspread.utils) extract_id_from_url() (in module gspread.utils)

F

fill_gaps() (in module gspread.utils) filter_dict_values() (in module gspread.utils) find() (gspread.worksheet.Worksheet method) findall() (gspread.worksheet.Worksheet method) finditem() (in module gspread.utils)

first() (gspread.worksheet.ValueRange method) format() (gspread.worksheet.Worksheet method) freeze() (gspread.worksheet.Worksheet method) from_address() (gspread.cell.Cell class method) frozen_col_count (gspread.worksheet.Worksheet property) frozen_row_count (gspread.worksheet.Worksheet property)

G

get() (gspread.worksheet.Worksheet method) get_all_cells() (gspread.worksheet.Worksheet method) get_all_records() (gspread.worksheet.Worksheet method) get_all_values() (gspread.worksheet.Worksheet method) get_config_dir() (in module gspread.auth) get_note() (gspread.worksheet.Worksheet method) get_values() (gspread.worksheet.Worksheet method) get_worksheet() (gspread.spreadsheet.Spreadsheet method)

get_worksheet_by_id() (gspread.spreadsheet.Spreadsheet method) gspread module gspread.auth module gspread.utils module GSpreadException

H

hide() (gspread.worksheet.Worksheet method) hide_columns() (gspread.worksheet.Worksheet method)

hide_gridlines() (gspread.worksheet.Worksheet method) hide_rows() (gspread.worksheet.Worksheet method)

I

id (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) import_csv() (gspread.Client method) IncorrectCellLabel index (gspread.worksheet.Worksheet property) insert_cols() (gspread.worksheet.Worksheet method) insert_note() (gspread.worksheet.Worksheet method)

insert_notes() (gspread.worksheet.Worksheet method) insert_permission() (gspread.Client method) insert_row() (gspread.worksheet.Worksheet method) insert_rows() (gspread.worksheet.Worksheet method) InvalidInputValue is_gridlines_hidden (gspread.worksheet.Worksheet property) is_scalar() (in module gspread.utils) isSheetHidden (gspread.worksheet.Worksheet property)

L

lastUpdateTime (gspread.spreadsheet.Spreadsheet property) list_dimension_group_columns() (gspread.worksheet.Worksheet method) list_dimension_group_rows() (gspread.worksheet.Worksheet method) list_named_ranges() (gspread.spreadsheet.Spreadsheet method) list_permissions() (gspread.Client method) (gspread.spreadsheet.Spreadsheet method)

list_protected_ranges() (gspread.spreadsheet.Spreadsheet method) list_spreadsheet_files() (gspread.Client method) local_server_flow() (in module gspread.auth) locale (gspread.spreadsheet.Spreadsheet property)

M

major_dimension (gspread.worksheet.ValueRange property) merge_cells() (gspread.worksheet.Worksheet method) MimeType (in module gspread.utils)

module gspread gspread.auth gspread.utils

N

named_range() (gspread.spreadsheet.Spreadsheet method) NoValidUrlKeyFound

numeric_value (gspread.cell.Cell property) numericise() (in module gspread.utils) numericise_all() (in module gspread.utils)

O

oauth() (in module gspread) (in module gspread.auth) oauth_from_dict() (in module gspread.auth)

open() (gspread.Client method) open_by_key() (gspread.Client method) open_by_url() (gspread.Client method) openall() (gspread.Client method)

P

PasteOrientation (in module gspread.utils)

PasteType (in module gspread.utils)

Q

quote() (in module gspread.utils)

R

range (gspread.worksheet.ValueRange property) range() (gspread.worksheet.Worksheet method) refresh_lastUpdateTime() (gspread.spreadsheet.Spreadsheet method) remove_permission() (gspread.Client method) remove_permissions() (gspread.spreadsheet.Spreadsheet method) reorder_worksheets() (gspread.spreadsheet.Spreadsheet method)

resize() (gspread.worksheet.Worksheet method) rightpad() (in module gspread.utils) row (gspread.cell.Cell property) row_count (gspread.worksheet.Worksheet property) row_values() (gspread.worksheet.Worksheet method) rowcol_to_a1() (in module gspread.utils) rows_auto_resize() (gspread.worksheet.Worksheet method)

S

service_account() (in module gspread) (in module gspread.auth) service_account_from_dict() (in module gspread.auth) set_basic_filter() (gspread.worksheet.Worksheet method) set_timeout() (gspread.Client method) share() (gspread.spreadsheet.Spreadsheet method)

sheet1 (gspread.spreadsheet.Spreadsheet property) show() (gspread.worksheet.Worksheet method) show_gridlines() (gspread.worksheet.Worksheet method) sort() (gspread.worksheet.Worksheet method) Spreadsheet (class in gspread.spreadsheet) SpreadsheetNotFound

T

tab_color (gspread.worksheet.Worksheet property) timezone (gspread.spreadsheet.Spreadsheet property)

title (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) transfer_ownership() (gspread.spreadsheet.Spreadsheet method)

U

unhide_columns() (gspread.worksheet.Worksheet method) unhide_rows() (gspread.worksheet.Worksheet method) unmerge_cells() (gspread.worksheet.Worksheet method) UnSupportedExportFormat update() (gspread.worksheet.Worksheet method) update_acell() (gspread.worksheet.Worksheet method) update_cell() (gspread.worksheet.Worksheet method) update_cells() (gspread.worksheet.Worksheet method) update_index() (gspread.worksheet.Worksheet method) update_locale() (gspread.spreadsheet.Spreadsheet method)

update_note() (gspread.worksheet.Worksheet method) update_notes() (gspread.worksheet.Worksheet method) update_tab_color() (gspread.worksheet.Worksheet method) update_timezone() (gspread.spreadsheet.Spreadsheet method) update_title() (gspread.spreadsheet.Spreadsheet method) (gspread.worksheet.Worksheet method) updated (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) url (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property)

V

value (gspread.cell.Cell attribute) ValueInputOption (in module gspread.utils) ValueRange (class in gspread.worksheet) ValueRenderOption (in module gspread.utils)

values_append() (gspread.spreadsheet.Spreadsheet method) values_batch_get() (gspread.spreadsheet.Spreadsheet method) values_clear() (gspread.spreadsheet.Spreadsheet method) values_get() (gspread.spreadsheet.Spreadsheet method) values_update() (gspread.spreadsheet.Spreadsheet method)

W

wid_to_gid() (in module gspread.utils) Worksheet (class in gspread.worksheet)

worksheet() (gspread.spreadsheet.Spreadsheet method) WorksheetNotFound worksheets() (gspread.spreadsheet.Spreadsheet method)