When you copy the content of a web page to Excel, it automatically becomes a hyperlink.

at present, there is a requirement for the company"s project. After copying the work order number in the project web page to Excel, the work order number will automatically become a hyperlink and link to the corresponding URL of the system. I don"t know if there are any students who have done it, what is the way to achieve it?

Mar.19,2021

you just add a hyperlink to the work order number, and then copy your work order number to excel that contains the hyperlink


put the content to be copied in the HTML into the a tag, as in the href to put the address to be linked. The content in the web page can be copied to Excel, which is in the state of hyperlink, and the link address is the address in href

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e9636f-4ea8a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e9636f-4ea8a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?