如何在Google电子表格API中获取范围的超链接？

import os.path
from google.oauth2 import service_account
from googleapiclient.discovery import build

# 设置凭据文件路径
creds = service_account.Credentials.from_service_account_file(
    'path/to/your/credentials.json',
    scopes=['https://www.googleapis.com/auth/spreadsheets']
)

# 构建Google Sheets API客户端
service = build('sheets', 'v4', credentials=creds)

# 电子表格ID和范围
spreadsheet_id = 'your-spreadsheet-id'
range_name = 'Sheet1!A1:B2'

# 获取范围内的值和公式
result = service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id,
    range=range_name,
    fields='values,hyperlinks'
).execute()

# 打印结果
values = result.get('values', [])
hyperlinks = result.get('hyperlinks', [])

for i, row in enumerate(values):
    for j, cell in enumerate(row):
        print(f"Cell {i+1},{j+1}: {cell}")
        if j < len(hyperlinks[i]):
            print(f"  Hyperlink: {hyperlinks[i][j]}")