获取Google Sheets中特定数字的最后一行索引

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 设置Google Sheets API的身份验证凭据
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(credentials)

# 打开Google Sheets文件并选择工作表
spreadsheet = client.open('你的Google Sheets文件名')
worksheet = spreadsheet.get_worksheet(0)  # 假设选择第一个工作表

# 获取工作表中的所有数据
data = worksheet.get_all_values()

# 查找特定数字的最后一行索引
target_number = 42  # 假设要查找的数字是42
last_row_index = None

for i, row in enumerate(data):
    if str(target_number) in row:
        last_row_index = i + 1  # 索引从1开始计数

if last_row_index is not None:
    print("特定数字的最后一行索引为:", last_row_index)
else:
    print("未找到特定数字")