擅长:python、mysql、java
<pre><code># Make sure you include single quotes when you reference another sheet in a Workbook hyperlink.
# example code to link the same cell on two different worksheet
import win32com.client as win32com
output_filename = 'MyExcelWorkbook.xlsx'
excel = win32com.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(output_filename)
worksheet1name = wb.Worksheets(1).Name
worksheet2name = wb.Worksheets(2).Name
ws_out = wb.Worksheets.(worksheet1name)
for rowIndex in range(numRows):
rangeString = 'A' + str(rowIndex)
cell_destination = '\'' + sheet2name + '\'' + '!' + 'A' + str(rowIndex)
ws_out.Hyperlinks.Add(Anchor=ws_out.Range(rangeString), Address='', SubAddress=cell_destination)
</code></pre>