Read Excel file which has one of the column as Hyp

Question

I have to read an Excel file Using python. By the time I use

xl = pd.ExcelFile("abc.xlsx")

The column values which had hyperlink assigned to it becomes a simple number without any hyperlink.

Is there any way that I can retain the Hyperlink?

Details below.

Answer 1

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