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) 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_validation() (gspread.worksheet.Worksheet method) add_worksheet() (gspread.spreadsheet.Spreadsheet method) address (gspread.cell.Cell property) api_key() (in module gspread.auth) APIError append_row() (gspread.worksheet.Worksheet method) append_rows() (gspread.worksheet.Worksheet method) authorize() (in module gspread) (in module gspread.auth)

B

BackOffHTTPClient (class in gspread) batch_clear() (gspread.worksheet.Worksheet method) batch_format() (gspread.worksheet.Worksheet method) batch_get() (gspread.worksheet.Worksheet method)

batch_update() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) (gspread.worksheet.Worksheet method) blank (gspread.utils.ValidationConditionType attribute) boolean (gspread.utils.ValidationConditionType attribute)

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) 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) cols (gspread.utils.Dimension attribute) column_count (gspread.worksheet.Worksheet property)

column_letter_to_index() (in module gspread.utils) columns_auto_resize() (gspread.worksheet.Worksheet method) combined_merge_values() (in module gspread.utils) conditional_formating (gspread.utils.PasteType attribute) convert_colors_to_hex_value() (in module gspread.utils) convert_credentials() (in module gspread.utils) convert_hex_to_colors_dict() (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) CSV (gspread.utils.ExportFormat attribute) csv (gspread.utils.MimeType attribute) custom_formula (gspread.utils.ValidationConditionType attribute) cut_range() (gspread.worksheet.Worksheet method)

D

data_validation (gspread.utils.PasteType attribute) date_after (gspread.utils.ValidationConditionType attribute) date_before (gspread.utils.ValidationConditionType attribute) date_between (gspread.utils.ValidationConditionType attribute) date_eq (gspread.utils.ValidationConditionType attribute) date_is_valid (gspread.utils.ValidationConditionType attribute) date_not_between (gspread.utils.ValidationConditionType attribute) date_not_eq (gspread.utils.ValidationConditionType attribute) date_on_or_after (gspread.utils.ValidationConditionType attribute) date_on_or_before (gspread.utils.ValidationConditionType attribute) DateTimeOption (class in 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_rows() (gspread.worksheet.Worksheet method) Dimension (class in gspread.utils) duplicate() (gspread.worksheet.Worksheet method) duplicate_sheet() (gspread.spreadsheet.Spreadsheet method)

E

EXCEL (gspread.utils.ExportFormat attribute) excel (gspread.utils.MimeType attribute) export() (gspread.Client method) (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method)

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

F

fetch_sheet_metadata() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) fill_gaps() (in module gspread.utils) filter_expression (gspread.utils.ValidationConditionType attribute) find() (gspread.worksheet.Worksheet method) findall() (gspread.worksheet.Worksheet method) finditem() (in module gspread.utils) first() (gspread.worksheet.ValueRange method) FlowCallable (class in gspread.auth)

format (gspread.utils.PasteType attribute) format() (gspread.worksheet.Worksheet method) formatted (gspread.utils.ValueRenderOption attribute) formatted_string (gspread.utils.DateTimeOption attribute) formula (gspread.utils.PasteType attribute) (gspread.utils.ValueRenderOption attribute) 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_a1_from_absolute_range() (in module gspread.utils) 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_file_drive_metadata() (gspread.Client method) (gspread.HTTPClient method) get_lastUpdateTime() (gspread.spreadsheet.Spreadsheet method) get_note() (gspread.worksheet.Worksheet method) get_notes() (gspread.worksheet.Worksheet method) get_tab_color() (gspread.worksheet.Worksheet method)

get_values() (gspread.worksheet.Worksheet method) get_worksheet() (gspread.spreadsheet.Spreadsheet method) get_worksheet_by_id() (gspread.spreadsheet.Spreadsheet method) google_sheets (gspread.utils.MimeType attribute) GridRangeType (class in gspread.utils) 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) HTTPClient (class in gspread)

I

id (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) import_csv() (gspread.Client method) (gspread.HTTPClient 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) (gspread.HTTPClient method)

insert_row() (gspread.worksheet.Worksheet method) insert_rows (gspread.utils.InsertDataOption attribute) insert_rows() (gspread.worksheet.Worksheet method) InsertDataOption (class in gspread.utils) InvalidInputValue is_full_a1_notation() (in module gspread.utils) 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.HTTPClient method) (gspread.spreadsheet.Spreadsheet method)

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

M

major_dimension (gspread.worksheet.ValueRange property) merge_all (gspread.utils.MergeType attribute) merge_cells() (gspread.worksheet.Worksheet method) merge_columns (gspread.utils.MergeType attribute) merge_rows (gspread.utils.MergeType attribute)

MergeType (class in gspread.utils) MimeType (class in gspread.utils) module gspread gspread.auth gspread.utils

N

named_range() (gspread.spreadsheet.Spreadsheet method) no_borders (gspread.utils.PasteType attribute) normal (gspread.utils.PasteOrientation attribute) (gspread.utils.PasteType attribute) not_blank (gspread.utils.ValidationConditionType attribute) NoValidUrlKeyFound number_between (gspread.utils.ValidationConditionType attribute) number_eq (gspread.utils.ValidationConditionType attribute)

number_greater (gspread.utils.ValidationConditionType attribute) number_greater_than_eq (gspread.utils.ValidationConditionType attribute) number_less (gspread.utils.ValidationConditionType attribute) number_less_than_eq (gspread.utils.ValidationConditionType attribute) number_not_between (gspread.utils.ValidationConditionType attribute) number_not_eq (gspread.utils.ValidationConditionType attribute) 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) one_of_list (gspread.utils.ValidationConditionType attribute) one_of_range (gspread.utils.ValidationConditionType attribute) open() (gspread.Client method)

open_by_key() (gspread.Client method) open_by_url() (gspread.Client method) OPEN_OFFICE_SHEET (gspread.utils.ExportFormat attribute) open_office_sheet (gspread.utils.MimeType attribute) openall() (gspread.Client method) overwrite (gspread.utils.InsertDataOption attribute)

P

PasteOrientation (class in gspread.utils) PasteType (class in gspread.utils)

PDF (gspread.utils.ExportFormat attribute) pdf (gspread.utils.MimeType attribute)

Q

quote() (in module gspread.utils)

R

range (gspread.worksheet.ValueRange property) range() (gspread.worksheet.Worksheet method) raw (gspread.utils.ValueInputOption attribute) remove_permission() (gspread.Client method) (gspread.HTTPClient 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 (gspread.utils.Dimension attribute) rows_auto_resize() (gspread.worksheet.Worksheet method)

S

serial_number (gspread.utils.DateTimeOption attribute) 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) (gspread.HTTPClient 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) spreadsheet (gspread.worksheet.Worksheet property) SpreadsheetNotFound spreadsheets_get() (gspread.HTTPClient method) spreadsheets_sheets_copy_to() (gspread.HTTPClient method) StrEnum (class in gspread.utils)

T

tab_color (gspread.worksheet.Worksheet property) text_contains (gspread.utils.ValidationConditionType attribute) text_ends_with (gspread.utils.ValidationConditionType attribute) text_eq (gspread.utils.ValidationConditionType attribute) text_is_email (gspread.utils.ValidationConditionType attribute) text_is_url (gspread.utils.ValidationConditionType attribute) text_not_contains (gspread.utils.ValidationConditionType attribute) text_not_eq (gspread.utils.ValidationConditionType attribute)

text_starts_with (gspread.utils.ValidationConditionType attribute) timezone (gspread.spreadsheet.Spreadsheet property) title (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) to_records() (in module gspread.utils) transfer_ownership() (gspread.spreadsheet.Spreadsheet method) transpose (gspread.utils.PasteOrientation attribute) TSV (gspread.utils.ExportFormat attribute) tsv (gspread.utils.MimeType attribute)

U

unformatted (gspread.utils.ValueRenderOption attribute) 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_drive_metadata() (gspread.spreadsheet.Spreadsheet 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) url (gspread.spreadsheet.Spreadsheet property) (gspread.worksheet.Worksheet property) user_entered (gspread.utils.ValueInputOption attribute)

V

ValidationConditionType (class in gspread.utils) value (gspread.cell.Cell attribute) ValueInputOption (class in gspread.utils) ValueRange (class in gspread.worksheet) (gspread.utils.GridRangeType attribute) ValueRenderOption (class in gspread.utils) values (gspread.utils.PasteType attribute) values_append() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) values_batch_clear() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method)

values_batch_get() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) values_batch_update() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) values_clear() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) values_get() (gspread.HTTPClient method) (gspread.spreadsheet.Spreadsheet method) values_update() (gspread.HTTPClient method) (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)

Z

zip (gspread.utils.MimeType attribute)

ZIPPED_HTML (gspread.utils.ExportFormat attribute)