openpyxl.worksheet.hyperlink module

class openpyxl.worksheet.hyperlink.Hyperlink(ref=None, location=None, tooltip=None, display=None, id=None, target=None)

基类：openpyxl.descriptors.serialisable.Serialisable

display

Values must be of type <class ‘str’>

id

Values must be of type <class ‘str’>

location

Values must be of type <class ‘str’>

ref

Values must be of type <class ‘str’>

tagname = 'hyperlink'

target

Values must be of type <class ‘str’>

tooltip

Values must be of type <class ‘str’>

class openpyxl.worksheet.hyperlink.HyperlinkList(hyperlink=())

基类：openpyxl.descriptors.serialisable.Serialisable

append(value)

hyperlink

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'hyperlinks'