使用 Python 从 Excel (.xlsx) 中提取超链接 [英] Extracting Hyperlinks From Excel (.xlsx) with Python

问题描述

我主要关注的是用于 Excel 文件操作的 xlrd 和 openpyxl 库.但是，xlrd 目前不支持 .xlsx 文件的 formatting_info=True，所以我不能使用 xlrd hyperlink_map 功能.所以我转向openpyxl，但也没有运气从excel文件中提取超链接.下面的测试代码(测试文件包含一个简单的 google 超链接，超链接文本设置为test"):

I have been looking at mostly the xlrd and openpyxl libraries for Excel file manipulation. However, xlrd currently does not support formatting_info=True for .xlsx files, so I can not use the xlrd hyperlink_map function. So I turned to openpyxl, but have also had no luck extracting a hyperlink from an excel file with it. Test code below (the test file contains a simple hyperlink to google with hyperlink text set to "test"):

import openpyxl

wb = openpyxl.load_workbook('testFile.xlsx')

ws = wb.get_sheet_by_name('Sheet1')

r = 0
c = 0

print ws.cell(row = r, column = c). value
print ws.cell(row = r, column = c). hyperlink
print ws.cell(row = r, column = c). hyperlink_rel_id

输出:

test

None

我猜 openpyxl 目前也不完全支持格式化?是否有其他库可用于从 Excel (.xlsx) 文件中提取超链接信息?

I guess openpyxl does not currently support formatting completely either? Is there some other library I can use to extract hyperlink information from Excel (.xlsx) files?

推荐答案

根据我的经验，获得良好的 .xlsx 交互需要迁移到 IronPython.这使您可以使用公共语言运行时 (clr) 并直接与 excel 交互'

In my experience getting good .xlsx interaction requires moving to IronPython. This lets you work with the Common Language Runtime (clr) and interact directly with excel'

http://ironpython.net/

import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel
excel = Excel.ApplicationClass()

wb = excel.Workbooks.Open('testFile.xlsx')
ws = wb.Worksheets['Sheet1']

address = ws.Cells(row, col).Hyperlinks.Item(1).Address

这篇关于使用 Python 从 Excel (.xlsx) 中提取超链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！