擅长:python、mysql、java
<p>这是导致技巧:在</p>
<pre><code># Creates hyperlink in existing workbook...
def set_hyperlink():
from openpyxl import load_workbook
x = "hyperlink address"
wb = load_workbook("filename.xlsx")
ws = wb.get_sheet_by_name("sheet_name")
ws.cell(row = x?, column = y?).hyperlink = x
wb.save("filename.xlsx")
set_hyperlink()
</code></pre>
<p>按照建议再次尝试使用openpyxl。在</p>