pandas to_excel removes hyperlink in cells

Question

I created an excel file using openpyxl which has some hyperlinks using the following command:

=HYPERLINK("{}", "{}")'.format(link, "Link Name")

But when I use pandas to sort and then save the excel file. the hyperlinks are gone.

what am I doing wrong?

the type `object` which saves string in pandas is not the same as regular strings, and you don't have string formatting. — anand_v.singh, Apr 19 '19 at 09:21

score 0 · Answer 1 · answered Apr 18 '19 at 12:46

0

Jimmy

I think this could be useful for you

Cheers

answered Apr 18 '19 at 12:46

GabrielJGC

The problem is that I have a list that is appended as a row so I can't target specify cells as in ws.cell(row=2, column=1).hyperlink – jimmy_james Apr 19 '19 at 09:20

1 Answers1