Skip to content

Instantly share code, notes, and snippets.

@elseagle
Last active August 15, 2022 20:48
Show Gist options
  • Save elseagle/1a51e414a8becb1d4c03f6967be3636e to your computer and use it in GitHub Desktop.
Save elseagle/1a51e414a8becb1d4c03f6967be3636e to your computer and use it in GitHub Desktop.
# get values in the first row
values_list = worksheet.row_values(1)
# get values in the first column
values_list = worksheet.col_values(1)
# get values as 2D list
all_values = worksheet.get_all_values()
# get values as list of key pair values
all_values = worksheet.get_all_records()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment