[Solved] Read Excel file which has one of the column as Hyperlink through python


Pandas library does not have the functionality to parse hyperlink as of yet. You could preprocess the excel using libraries such as xlrd or openpxyl to get hyperlinks then use it in pandas.

Source: https://stackoverflow.com/a/45446810/7570485

There is also a feature request for this functionality.

https://github.com/pandas-dev/pandas/issues/13439

1

solved Read Excel file which has one of the column as Hyperlink through python