python给excel添加超链接,在Python中创建Excel超链接

I am using win32com to modify an Excel spreadsheet (Both read and edit at the same time) I know there are other modules out there that can do one or the other but for the application I am doing I need it read and processed at the same time.

The final step is to create some hyperlinks off of a path name. Here is an Example of what I have so far:

import win32com.client

excel = r'I:\Custom_Scripts\Personal\Hyperlinks\HyperlinkTest.xlsx'

xlApp = win32com.client.Dispatch("Excel.Application")

workbook = xlApp.Workbooks.Open(excel)

worksheet = workbook.Worksheets("Sheet1")

for xlRow in xrange(1, 10, 1):

a = worksheet.Range("A%s"%(xlRow)).Value

if a == None:

break

print a

workbook.Close()

I found some code for reading Hyperlinks using win32