python超链接格式_Openpyxl中的超链接样式

4 个答案:

答案 0 :(得分：1)

import openpyxl

from openpyxl.styles import Font, Color, colors

#...

# alternative 1: set hyperlink property to cell

def link_1(cell, link, display=None):

cell.hyperlink = link

cell.font = Font(u='single', color=colors.BLUE)

if display is not None:

cell.value = display

# alternative 2: use Excel formula HYPERLINK

def link_2(cell, link, display='link'):

cell.value = '=HYPERLINK("%s", "%s")' % (link, display)

cell.font = Font(u='single', color=colors.BLUE)

# examples

link_1(ws['B2'], '#sheet3!A1', 'link_text') # internal link

link_2(ws['B3'], '#sheet3!A1', 'link_text') # internal link

link_1(ws['B4'], 'https://www.