fastpyxl.worksheet.views module

class fastpyxl.worksheet.views.Pane(xSplit=None, ySplit=None, topLeftCell=None, activePane='topLeft', state='split')

Bases: Serialisable

activePane: str | None

state: str | None

topLeftCell: str | None

xSplit: float | None

ySplit: float | None

class fastpyxl.worksheet.views.Selection(pane=None, activeCell='A1', activeCellId=None, sqref='A1')

Bases: Serialisable

activeCell: str | None

activeCellId: int | None

pane: str | None

sqref: str | None

class fastpyxl.worksheet.views.SheetView(windowProtection=None, showFormulas=None, showGridLines=None, showRowColHeaders=None, showZeros=None, rightToLeft=None, tabSelected=None, showRuler=None, showOutlineSymbols=None, defaultGridColor=None, showWhiteSpace=None, view=None, topLeftCell=None, colorId=None, zoomScale=None, zoomScaleNormal=None, zoomScaleSheetLayoutView=None, zoomScalePageLayoutView=None, zoomToFit=None, workbookViewId=0, selection=None, pane=None)

Bases: Serialisable

Information about the visible portions of this sheet.

colorId: int | None

defaultGridColor: bool | None

pane: Pane | None

rightToLeft: bool | None

selection: list[Selection]

showFormulas: bool | None

showGridLines: bool | None

showOutlineSymbols: bool | None

showRowColHeaders: bool | None

showRuler: bool | None

showWhiteSpace: bool | None

showZeros: bool | None

tabSelected: bool | None

tagname = 'sheetView'

topLeftCell: str | None

view: str | None

windowProtection: bool | None

workbookViewId: int | None

xml_order = ('pane', 'selection')

zoomScale: int | None

zoomScaleNormal: int | None

zoomScalePageLayoutView: int | None

zoomScaleSheetLayoutView: int | None

zoomToFit: bool | None

class fastpyxl.worksheet.views.SheetViewList(sheetView=None, extLst=None)

Bases: Serialisable

property active

Returns the first sheet view which is assumed to be active

extLst: ExtensionList | None

sheetView: list[SheetView]

tagname = 'sheetViews'

xml_order = ('sheetView',)