从Google Sheet API V4中的单元格获取超链接 [英] Get hyperlink from a cell in google Sheet api V4

问题描述

我想获取Python中单元格(例如A1)的超链接.到目前为止，我已经有了这段代码.谢谢

I want to get the hyperlink of a cell (A1, for example) in Python. I have this code so far. Thanks

properties = {
    "requests": [
    {
        "cell": {
            "HyperlinkDisplayType": "LINKED"
        },
        "fields": "userEnteredFormat.HyperlinkDisplayType"
    }

    ]
    }

result = service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id, range=rangeName, body=properties).execute()
values = result.get('values', [])

推荐答案

如何使用 sheets.spreadsheets.get ?此示例脚本假定您脚本的service已经能够用于spreadsheets().values().get().

How about using sheets.spreadsheets.get? This sample script supposes that service of your script has already been able to be used for spreadsheets().values().get().

spreadsheetId = '### Spreadsheet ID ###'
range = ['sheet1!A1:A1'] # This is a sample.
result = service.spreadsheets().get(
    spreadsheetId=spreadsheetId,
    ranges=range,
    fields="sheets/data/rowData/values/hyperlink"
).execute()

如果这对您没有用，很抱歉.

If this was not useful for you, I'm sorry.

这篇关于从Google Sheet API V4中的单元格获取超链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！