Get Hyperlinks in Range

To get hyperlinks in range, use the getHyperlinks() property of the Range class. The getHyperlinks() property gets all the hyperlinks in the selected range.

The following code snippet shows how to get all hyperlinks in the selected range.

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()))