Spreadsheet worksheet counter

import gspread
from oauth2client.service_account import ServiceAccountCredentials as sac

scope = ['https://spreadsheets.google.com/feeds',
         'https://www.googleapis.com/auth/drive']

creds = sac.from_json_keyfile_name('client_secrets.json', scope)
client = gspread.authorize(creds)
sheet = client.open_by_url(url) 

flag = True
i = 0

while flag:
    try:
        ith = sheet.get_worksheet(i)
        i += 1
        print(ith)
    except Exception as e:
        print(e)
        flag = False

print(f'Total worksheet = {i}')

# Output: 
# ---------------------------
# <Worksheet 'Form Responses 1' id:30127793>
# <Worksheet 'Sheet2' id:1033101728>
# index 2 not found
# Total worksheet = 2

Source: stackoverflow.com

Similar codes

0 vote134 views1 answer
Count no of nan in a 2d array python
Python
0 vote176 views1 answer
Day 19: interfaces hackerrank solution in python
Python
0 vote177 views3 answers
OpenCV(3.4.11) Error: Assertion failed (_img.rows * _img.cols == vecSize) in CvCascadeImageReader::PosReader::get
Python
2 votes162 views2 answers
Get title attribute beautiful soup
Python
2 votes175 views1 answer
Python argument parser default value
Python
0 vote187 views1 answer
How to read comment before the root element of xml python
Python
0 vote168 views1 answer
Python close database connection
Python
3 votes165 views3 answers
Python - find specific name in a df
Python
11 votes157 views3 answers
Import RandomForestClassifier
Python
0 vote184 views1 answer
Label default text value python
Python