gspread
v6.0.0
Authentication
Examples of gspread Usage
Advanced Usage
API Reference
gspread
Index
Edit on GitHub
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
Z
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_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
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)
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)
cut_range() (gspread.worksheet.Worksheet method)
D
data_validation (gspread.utils.PasteType 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.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)
find() (gspread.worksheet.Worksheet method)
findall() (gspread.worksheet.Worksheet method)
finditem() (in module gspread.utils)
first() (gspread.worksheet.ValueRange method)
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_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)
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.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.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)
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)
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)
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.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)
SpreadsheetNotFound
spreadsheets_get() (gspread.HTTPClient method)
spreadsheets_sheets_copy_to() (gspread.HTTPClient method)
T
tab_color (gspread.worksheet.Worksheet property)
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
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)
Read the Docs
v: v6.0.0
Versions
master
latest
v6.0.0
v5.12.4
v5.12.3
v5.12.2
v5.12.1
v5.12.0
v5.11.3
v5.11.2
v5.11.1
v5.11.0
v5.10.0
v5.9.0
v5.8.1
v5.8.0
v5.7.2
v5.7.1
v5.7.0
v5.6.2
v5.6.1
v5.6.0
v5.5.0
v5.4.0
v5.3.2
v5.3.1
v5.3.0
v5.2.0
v5.1.1
v5.1.0
v5.0.0
v4.0.1
v4.0.0
v3.7.0
Downloads
On Read the Docs
Project Home
Builds