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

4 votes243 views4 answers
Whatsapp api
Python
0 vote204 views1 answer
Phyton 2.7 convert timedelta to string
Python
3 votes230 views1 answer
Flask give port number
Python Flask
0 vote193 views1 answer
Print a commans in python
Python
0 vote192 views1 answer
If function has no argument python
Python
-1 vote181 views1 answer
Armstrong number function
Python
0 vote202 views1 answer
How to change canvas background color in python tkinter
Python
0 vote209 views1 answer
Set .discard(), .remove() & .pop() | Hackerrank Python Solution |
Python
0 vote196 views1 answer
Entry point to programming Spark with the Dataset and DataFrame API
Python
1 vote279 views1 answer
Could not locate a bind configured on mapper mapped class class->tablename, SQL expression or this Session.
Python