Python实用之xlwt单元格中加超链接

<p style="line-height: 1.75em;"><span style="font-family: 微软雅黑, "Microsoft YaHei"; font-size: 14px;">base = xlwt.Workbook()

for k,v in MainDict.items():

    base.add_sheet(k)

    xlwt.add_palette_colour("custom_colour", 0x21)

    base.set_colour_RGB(0x21, 251, 228, 228)

    style = xlwt.easyxf('pattern: pattern solid, fore_colour custom_colour;font : bold on')

    style1 = xlwt.easyxf('font : underline single')

    index = MainDict.keys().index(k)

    ws = base.get_sheet(index)

    col=0

    for sk in MainDict[k].keys():

        ws.write(0,col,sk.upper(),style)

        col+=1

        row =1

        for mk in MainDict[k][sk].keys():

            for lk,lv in MainDict[k][sk][mk].items():

                for items in lv:

                    ws.write(row,col-1,(items + str(Formula('HYPERLINK("%s")'%mk))))

                    row+=1

base.save('project2.xls')<br></span></p>

<p style="line-height: 1.75em;"><span style="font-family: 微软雅黑, "Microsoft YaHei"; font-size: 14px;">import xlwt

wb = xlwt.Workbook()

ws = wb.add_sheet('test')

ws.write(0, 0, xlwt.Formula('"test " & HYPERLINK("http://google.com")'))

wb.save('test.xls')<br></span></p>