如何在Python3.6中使用单元格值获取gspread中单元格的坐标

pip install gspread

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 定义凭据文件路径
credentials_file = 'path/to/credentials.json'

# 定义要操作的Google Sheets文件名称
spreadsheet_name = 'Your Google Sheets Name'

# 定义要操作的工作表名称
worksheet_name = 'Your Worksheet Name'

# 定义要获取单元格值的值
cell_value = 'Your Cell Value'

# 使用凭据文件进行身份验证
credentials = ServiceAccountCredentials.from_json_keyfile_name(credentials_file)
client = gspread.authorize(credentials)

# 打开指定的Google Sheets文件
spreadsheet = client.open(spreadsheet_name)

# 选择指定的工作表
worksheet = spreadsheet.worksheet(worksheet_name)

# 获取所有单元格的值
all_values = worksheet.get_all_values()

# 遍历所有单元格，查找匹配的单元格坐标
for row_index, row in enumerate(all_values):
    for col_index, cell in enumerate(row):
        if cell == cell_value:
            # 找到匹配的单元格，输出坐标
            print(f"单元格'{cell_value}'的坐标为：({col_index+1}, {row_index+1})")