Add Hyperlink to Excel csv file in python

Question

Hello i am making a software which gets data from an API and puts it in excel in csv format using pandas.

df2 = pd.DataFrame(data, columns=["Certificate #", "Lab", "Shape", "Size", "Color", "Clarity", "Min", "Max", "Hgt", "Cut", "Depth", "Table", "Pol", "Sym", "Flour", "Key to Symbols", "Comments", "Type", "Rep. Date", "Stock #", "$/ct", "Rap", "Company"])
df2.to_csv(os.path.join(os.getcwd(), "OUTPUTS", "GiaOut_" + strftime("%d-%m-%Y") + "_" + sys.argv[1]))

data is a list of lists where each item is a string. i want the second column "Lab" to be a hyperlink. it should display the text "LAB" underlined in blue and a link behind it.

thanks

You can't save a hyperlink in a csv. It would have to be an Excel file format. — BigBen
– BigBen, Commented Sep 10, 2020 at 1:51

Shrey · Accepted Answer · 2020-09-10 02:45:07Z

1

You have to create a styled data frame and then only you can save it as an Excel format.
If you try to save it through df.to_excel, all your formatting will not be gonna save. Instead of this, you have to create/open an excel spreadsheet through ExcelWriter and have to save according to this code snippet.

answered Sep 10, 2020 at 2:45

Shrey

4367 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add Hyperlink to Excel csv file in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related