使用Python从Excel（.xlsx）提取超链接

使用Python从Excel（.xlsx）提取超链接

以我的经验，要获得良好的.xlsx交互，需要转向IronPython。这使您可以使用公共语言运行时（clr）并直接与excel’进行交互

http://ironpython.net/

import clrclr.AddReference("Microsoft.Office.Interop.Excel")import Microsoft.Office.Interop.Excel as Excelexcel = Excel.ApplicationClass()wb = excel.Workbooks.Open('testFile.xlsx')ws = wb.Worksheets['Sheet1']address = ws.Cells(row, col).Hyperlinks.Item(1).Address