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 vote307 views1 answer
How to open cmd and run code using python
Python
0 vote356 views1 answer
Cannot access modules from neighbouring directories jupyter notebook
Python
1 vote331 views1 answer
Gimp python
Python
1 vote324 views2 answers
Check if user has manage messages discord.py
Python
0 vote357 views1 answer
ImportError: cannot import name 'config' from 'decouple' (C:\Users\Yemi\AppData\Local\Programs\Python\Python310\lib\site-packages\decouple\__init__.py)
Python
1 vote312 views1 answer
Plt.savefig cutting off labels
Python
0 vote318 views1 answer
Yml anaconda
Python
7 votes306 views2 answers
Cv2 load image
Python
0 vote326 views1 answer
Python close browser
Python
0 vote306 views1 answer
Pandas df.index.values
Python