fastpyxl.comments.comment_sheet module

class fastpyxl.comments.comment_sheet.CommentRecord(ref='', authorId=0, guid=None, shapeId=0, text=None, commentPr=None, author=None, height=79, width=144)

Bases: Serialisable

authorId: int

commentPr: Properties | None

property content

Remove all inline formatting and stuff

classmethod from_cell(cell)

Class method to convert cell comment

guid: str | None

ref: str

shapeId: int | None

tagname = 'comment'

text: Text

xml_order = ('text', 'commentPr')

class fastpyxl.comments.comment_sheet.CommentSheet(authors=None, commentList=None, extLst=None)

Bases: Serialisable

authors: AuthorList

commentList: list[CommentRecord]

property comments

Return a dictionary of comments keyed by coord

extLst: ExtensionList | None

classmethod from_comments(comments)

Create a comment sheet from a list of comments for a particular worksheet

mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml'

property path

Return path within the archive

tagname = 'comments'

to_tree(tagname=None, idx=None, namespace=None)

write_shapes(vml=None)

Create the VML for comments

xml_order = ('authors', 'commentList')

class fastpyxl.comments.comment_sheet.Properties(locked=None, defaultSize=None, _print=None, disabled=None, uiObject=None, autoFill=None, autoLine=None, altText=None, textHAlign=None, textVAlign=None, lockText=None, justLastX=None, autoScale=None, rowHidden=None, colHidden=None, anchor=None)

Bases: Serialisable

altText: str | None

autoFill: bool | None

autoLine: bool | None

autoScale: bool | None

colHidden: bool | None

defaultSize: bool | None

disabled: bool | None

justLastX: bool | None

lockText: bool | None

locked: bool | None

rowHidden: bool | None

tagname = 'commentPr'

textHAlign: str | None

textVAlign: str | None

uiObject: bool | None