fastpyxl.worksheet.table module

class fastpyxl.worksheet.table.Table(id=1, displayName=None, ref=None, name=None, comment=None, tableType=None, headerRowCount=1, insertRow=None, insertRowShift=None, totalsRowCount=None, totalsRowShown=None, published=None, headerRowDxfId=None, dataDxfId=None, totalsRowDxfId=None, headerRowBorderDxfId=None, tableBorderDxfId=None, totalsRowBorderDxfId=None, headerRowCellStyle=None, dataCellStyle=None, totalsRowCellStyle=None, connectionId=None, autoFilter=None, sortState=None, tableColumns=(), tableStyleInfo=None, extLst=None)

Bases: Serialisable

autoFilter: AutoFilter | None

property column_names

comment: str | None

connectionId: int | None

dataCellStyle: str | None

dataDxfId: int | None

displayName: str | None

extLst: ExtensionList | None

headerRowBorderDxfId: int | None

headerRowCellStyle: str | None

headerRowCount: int | None

headerRowDxfId: int | None

id: int | None

insertRow: bool | None

insertRowShift: bool | None

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

name: str | None

property path

Return path within the archive

published: bool | None

ref: str | None

sortState: SortState | None

tableBorderDxfId: int | None

tableColumns: list[TableColumn]

tableStyleInfo: TableStyleInfo | None

tableType: str | None

tagname = 'table'

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

totalsRowBorderDxfId: int | None

totalsRowCellStyle: str | None

totalsRowCount: int | None

totalsRowDxfId: int | None

totalsRowShown: bool | None

xml_order = ('autoFilter', 'sortState', 'tableColumns', 'tableStyleInfo')

class fastpyxl.worksheet.table.TableColumn(id=None, uniqueName=None, name=None, totalsRowFunction=None, totalsRowLabel=None, queryTableFieldId=None, headerRowDxfId=None, dataDxfId=None, totalsRowDxfId=None, headerRowCellStyle=None, dataCellStyle=None, totalsRowCellStyle=None, calculatedColumnFormula=None, totalsRowFormula=None, xmlColumnPr=None, extLst=None)

Bases: Serialisable

calculatedColumnFormula: TableFormula | None

dataCellStyle: str | None

dataDxfId: int | None

extLst: ExtensionList | None

classmethod from_tree(node)

headerRowCellStyle: str | None

headerRowDxfId: int | None

id: int | None

name: str | None

queryTableFieldId: int | None

tagname = 'tableColumn'

totalsRowCellStyle: str | None

totalsRowDxfId: int | None

totalsRowFormula: TableFormula | None

totalsRowFunction: str | None

totalsRowLabel: str | None

uniqueName: str | None

xmlColumnPr: XMLColumnProps | None

xml_order = ('calculatedColumnFormula', 'totalsRowFormula', 'xmlColumnPr', 'extLst')

class fastpyxl.worksheet.table.TableFormula(array=None, attr_text=None)

Bases: Serialisable

array: bool | None

classmethod from_tree(node)

tagname = 'tableFormula'

property text

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

class fastpyxl.worksheet.table.TableList

Bases: dict

add(table)

get(name=None, table_range=None)

Return the value for key if key is in the dictionary, else default.

items() → a set-like object providing a view on D's items

class fastpyxl.worksheet.table.TablePartList(count=None, tablePart=())

Bases: Serialisable

append(part)

property count

tablePart: list[Related]

tagname = 'tableParts'

xml_order = ('tablePart',)

class fastpyxl.worksheet.table.TableStyleInfo(name=None, showFirstColumn=None, showLastColumn=None, showRowStripes=None, showColumnStripes=None)

Bases: Serialisable

name: str | None

showColumnStripes: bool | None

showFirstColumn: bool | None

showLastColumn: bool | None

showRowStripes: bool | None

tagname = 'tableStyleInfo'

class fastpyxl.worksheet.table.XMLColumnProps(mapId=None, xpath=None, denormalized=None, xmlDataType=None, extLst=None)

Bases: Serialisable

denormalized: bool | None

extLst: ExtensionList | None

mapId: int | None

tagname = 'xmlColumnPr'

xmlDataType: str | None

xpath: str | None