从CSV中的超链接单元格中提取数据

import re

def extract_data_from_csv(csv_file):
    with open(csv_file, 'r') as file:
        lines = file.readlines()
        for line in lines:
            cells = line.split(',')
            for cell in cells:
                match = re.search('<a href="(.+?)">(.+?)</a>', cell)
                if match:
                    link = match.group(1)
                    text = match.group(2)
                    print("链接地址：", link)
                    print("链接文本：", text)

# 调用函数并传入CSV文件路径
extract_data_from_csv('example.csv')