import openpyxl wb = openpyxl.load_workbook('test.xlsx') ws = wb['Sheet1'] hl = ws.cell(row=2, column=1).hyperlink if hl: print(hl.target)
Cell in excel: [1]: https://i.stack.imgur.com/qPgQt.png
Expected output:
'example.com#para'
Actually output:
'example.com'
1.4m articles
1.4m replys
5 comments
56.9k users