获取范围内的超链接

获取范围内的超链接

要获取范围内的超链接,请使用Range类的getHyperlinks()属性。getHyperlinks()属性获取所选范围的所有超链接。

以下代码段显示了如何获取所选范围内的所有超链接。

source_directory = "Examples/SampleFiles/SourceDirectory/"
# Load Source Excel file
workbook = Workbook(source_directory + "HyperlinksSample.xlsx")
# Access first worksheet
worksheet = workbook.getWorksheets().get(0)
# Create a range A2:B3
range = worksheet.getCells().createRange("A2", "B3")
# Get Hyperlinks in range
hyperlinks = range.getHyperlinks()
for link in hyperlinks:
print(str(link.getArea()) + " : " + str(link.getAddress()))