openpyxl.worksheet package

Subpackages

• openpyxl.worksheet.tests package
  • Submodules
    • openpyxl.worksheet.tests.conftest module
      • datadir()
    • openpyxl.worksheet.tests.test_cell_range module
      • CellRange()
      • MultiCellRange()
      • TestCellRange
      • TestMultiCellRange
    • openpyxl.worksheet.tests.test_controls module
      • ControlProperty()
      • TestControlProperty
    • openpyxl.worksheet.tests.test_datavalidation module
      • DataValidation()
      • DataValidationList()
      • TestDataValidation
      • TestDataValidationList
      • test_collapse_cell_addresses()
      • test_expand_cell_ranges()
    • openpyxl.worksheet.tests.test_dimensions module
      • ColumnDimension()
      • DummyWorkbook
      • DummyWorksheet
      • RowDimension()
      • TestColDimension
      • TestGrouping
      • TestRowDimension
      • test_dimension_interface()
      • test_invalid_dimension_ctor()
    • openpyxl.worksheet.tests.test_filters module
      • AutoFilter()
      • ColorFilter()
      • CustomFilter()
      • CustomFilters()
      • DateGroupItem()
      • DynamicFilter()
      • FilterColumn()
      • Filters()
      • IconFilter()
      • SortCondition()
      • SortState()
      • TestAutoFilter
      • TestColorFilter
      • TestCustomFilter
      • TestCustomFilters
      • TestDateGroupItem
      • TestDynamicFilter
      • TestFilterColumn
      • TestFilters
      • TestIconFilter
      • TestSortCondition
      • TestSortState
      • TestTop10
      • Top10()
    • openpyxl.worksheet.tests.test_formula module
      • ArrayFormula()
      • TableFormula()
      • TestDataTable
    • openpyxl.worksheet.tests.test_header module
      • HeaderFooter()
      • HeaderFooterItem()
      • TestHeaderFooter
      • TestHeaderFooterItem
      • TestHeaderFooterPart
      • test_cannot_split()
      • test_multiline_string()
      • test_parse_format()
      • test_split_into_parts()
    • openpyxl.worksheet.tests.test_hyperlink module
      • Hyperlink()
      • HyperlinkList()
      • TestHyperlink
      • TestHyperlinkList
    • openpyxl.worksheet.tests.test_merge module
      • MergeCell()
      • MergedCellRange()
      • TestMergeCell
      • TestMergedCellRange
      • default_border()
      • double_border()
      • start_border()
      • thick_border()
      • thin_border()
    • openpyxl.worksheet.tests.test_ole module
      • ObjectAnchor()
      • TestObjectAnchor
    • openpyxl.worksheet.tests.test_page module
      • DummyWorksheet()
      • PageMargins()
      • PrintOptions()
      • PrintPageSetup()
      • TestPageMargins
      • TestPageSetup
      • TestPrintOptions
    • openpyxl.worksheet.tests.test_pagebreak module
      • Break()
      • ColBreak()
      • RowBreak()
      • TestBreak
      • TestColBreak
      • TestRowBreak
    • openpyxl.worksheet.tests.test_print_settings module
      • ColRange()
      • PrintArea()
      • PrintTitles()
      • RowRange()
      • TestColRange
      • TestPrintArea
      • TestPrintTitles
      • TestRowRange
    • openpyxl.worksheet.tests.test_properties module
      • SimpleTestProps()
      • test_ctor()
      • test_parse_properties()
      • test_write_properties()
    • openpyxl.worksheet.tests.test_protection module
      • SheetProtection()
      • TestSheetProtection
      • test_ctor_with_password()
      • test_explicit_password()
    • openpyxl.worksheet.tests.test_read_only module
      • DummyWorkbook()
      • ReadOnlyWorksheet()
      • TestReadOnlyWorksheet
      • test_implementation_compatbility()
    • openpyxl.worksheet.tests.test_reader module
      • PrimedWorksheetReader()
      • TestWorksheetParser
      • TestWorksheetReader
      • WorkSheetParser()
      • Workbook()
      • WorksheetReader()
      • test_number_convesion()
    • openpyxl.worksheet.tests.test_related module
      • test_related()
    • openpyxl.worksheet.tests.test_scenario module
      • InputCells()
      • Scenario()
      • ScenarioList()
      • TestInputCells
      • TestScenario
      • TestScenarios
    • openpyxl.worksheet.tests.test_table module
      • Table()
      • TableColumn()
      • TableFormula()
      • TableList()
      • TablePartList()
      • TableStyleInfo()
      • TestTable
      • TestTableColumn
      • TestTableFormula
      • TestTableInfo
      • TestTableList
      • TestTablePartList
      • TestXMLColumnPr
      • XMLColumnProps()
    • openpyxl.worksheet.tests.test_views module
      • SheetView()
      • SheetViewList()
      • TestSheetViews
      • test_parse()
      • test_serialise()
      • test_show_gridlines()
    • openpyxl.worksheet.tests.test_worksheet module
      • DummyWorkbook
      • TestEditableWorksheet
      • TestWorksheet
      • Worksheet()
      • dummy_worksheet()
      • test_add_chart()
      • test_add_image()
      • test_freeze_panes_both()
      • test_freeze_panes_horiz()
      • test_freeze_panes_vert()
      • test_max_column()
      • test_max_row()
      • test_min_column()
      • test_min_row()
    • openpyxl.worksheet.tests.test_worksheet_copy module
      • TestWorksheetCopy
      • WorksheetCopy()
      • compare_cells()
      • copier()
      • test_copy_worksheet()
    • openpyxl.worksheet.tests.test_write_only module
      • DummyWorkbook
      • WriteOnlyWorksheet()
      • test_append()
      • test_cannot_save_twice()
      • test_close()
      • test_hyperlink()
      • test_invalid_append()
      • test_path()
      • test_read_after_closing()
      • test_values_to_rows()
      • test_write_only_cell()
    • openpyxl.worksheet.tests.test_writer module
      • TestWorksheetWriter
      • writer()

Submodules

• openpyxl.worksheet.cell_range module
  • CellRange
    • CellRange.bottom
    • CellRange.bounds
    • CellRange.cells
    • CellRange.cols
    • CellRange.coord
    • CellRange.expand()
    • CellRange.intersection()
    • CellRange.isdisjoint()
    • CellRange.issubset()
    • CellRange.issuperset()
    • CellRange.left
    • CellRange.max_col
    • CellRange.max_row
    • CellRange.min_col
    • CellRange.min_row
    • CellRange.right
    • CellRange.rows
    • CellRange.shift()
    • CellRange.shrink()
    • CellRange.size
    • CellRange.top
    • CellRange.union()
  • MultiCellRange
    • MultiCellRange.add()
    • MultiCellRange.ranges
    • MultiCellRange.remove()
    • MultiCellRange.sorted()
• openpyxl.worksheet.cell_watch module
  • CellWatch
    • CellWatch.r
    • CellWatch.tagname
  • CellWatches
    • CellWatches.cellWatch
    • CellWatches.tagname
• openpyxl.worksheet.controls module
  • Control
    • Control.controlPr
    • Control.name
    • Control.shapeId
    • Control.tagname
  • ControlProperty
    • ControlProperty.altText
    • ControlProperty.anchor
    • ControlProperty.autoFill
    • ControlProperty.autoLine
    • ControlProperty.autoPict
    • ControlProperty.cf
    • ControlProperty.defaultSize
    • ControlProperty.disabled
    • ControlProperty.id
    • ControlProperty.linkedCell
    • ControlProperty.listFillRange
    • ControlProperty.locked
    • ControlProperty.macro
    • ControlProperty.recalcAlways
    • ControlProperty.tagname
    • ControlProperty.uiObject
  • Controls
    • Controls.control
    • Controls.tagname
• openpyxl.worksheet.copier module
  • WorksheetCopy
    • WorksheetCopy.copy_worksheet()
• openpyxl.worksheet.custom module
  • CustomProperties
    • CustomProperties.customPr
    • CustomProperties.tagname
  • CustomProperty
    • CustomProperty.name
    • CustomProperty.tagname
• openpyxl.worksheet.datavalidation module
  • DataValidation
    • DataValidation.add()
    • DataValidation.allowBlank
    • DataValidation.allow_blank
    • DataValidation.cells
    • DataValidation.error
    • DataValidation.errorStyle
    • DataValidation.errorTitle
    • DataValidation.formula1
    • DataValidation.formula2
    • DataValidation.hide_drop_down
    • DataValidation.imeMode
    • DataValidation.operator
    • DataValidation.prompt
    • DataValidation.promptTitle
    • DataValidation.ranges
    • DataValidation.showDropDown
    • DataValidation.showErrorMessage
    • DataValidation.showInputMessage
    • DataValidation.sqref
    • DataValidation.tagname
    • DataValidation.type
    • DataValidation.validation_type
  • DataValidationList
    • DataValidationList.append()
    • DataValidationList.count
    • DataValidationList.dataValidation
    • DataValidationList.disablePrompts
    • DataValidationList.tagname
    • DataValidationList.to_tree()
    • DataValidationList.xWindow
    • DataValidationList.yWindow
  • collapse_cell_addresses()
  • expand_cell_ranges()
• openpyxl.worksheet.dimensions module
  • ColumnDimension
    • ColumnDimension.auto_size
    • ColumnDimension.bestFit
    • ColumnDimension.collapsed
    • ColumnDimension.customWidth
    • ColumnDimension.index
    • ColumnDimension.max
    • ColumnDimension.min
    • ColumnDimension.parent
    • ColumnDimension.reindex()
    • ColumnDimension.to_tree()
    • ColumnDimension.width
  • Dimension
    • Dimension.collapsed
    • Dimension.hidden
    • Dimension.index
    • Dimension.outlineLevel
    • Dimension.outline_level
    • Dimension.parent
    • Dimension.style
  • DimensionHolder
    • DimensionHolder.group()
    • DimensionHolder.to_tree()
  • RowDimension
    • RowDimension.customFormat
    • RowDimension.customHeight
    • RowDimension.height
    • RowDimension.ht
    • RowDimension.parent
    • RowDimension.r
    • RowDimension.s
    • RowDimension.thickBot
    • RowDimension.thickTop
  • SheetDimension
    • SheetDimension.boundaries
    • SheetDimension.ref
    • SheetDimension.tagname
  • SheetFormatProperties
    • SheetFormatProperties.baseColWidth
    • SheetFormatProperties.customHeight
    • SheetFormatProperties.defaultColWidth
    • SheetFormatProperties.defaultRowHeight
    • SheetFormatProperties.outlineLevelCol
    • SheetFormatProperties.outlineLevelRow
    • SheetFormatProperties.tagname
    • SheetFormatProperties.thickBottom
    • SheetFormatProperties.thickTop
    • SheetFormatProperties.zeroHeight
• openpyxl.worksheet.drawing module
  • Drawing
    • Drawing.id
    • Drawing.tagname
• openpyxl.worksheet.errors module
  • Extension
    • Extension.tagname
    • Extension.uri
  • ExtensionList
    • ExtensionList.ext
    • ExtensionList.tagname
  • IgnoredError
    • IgnoredError.calculatedColumn
    • IgnoredError.emptyCellReference
    • IgnoredError.evalError
    • IgnoredError.formula
    • IgnoredError.formulaRange
    • IgnoredError.listDataValidation
    • IgnoredError.numberStoredAsText
    • IgnoredError.sqref
    • IgnoredError.tagname
    • IgnoredError.twoDigitTextYear
    • IgnoredError.unlockedFormula
  • IgnoredErrors
    • IgnoredErrors.extLst
    • IgnoredErrors.ignoredError
    • IgnoredErrors.tagname
• openpyxl.worksheet.filters module
  • AutoFilter
    • AutoFilter.add_filter_column()
    • AutoFilter.add_sort_condition()
    • AutoFilter.extLst
    • AutoFilter.filterColumn
    • AutoFilter.ref
    • AutoFilter.sortState
    • AutoFilter.tagname
  • ColorFilter
    • ColorFilter.cellColor
    • ColorFilter.dxfId
    • ColorFilter.tagname
  • CustomFilter
    • CustomFilter.operator
    • CustomFilter.tagname
    • CustomFilter.val
  • CustomFilterValueDescriptor
    • CustomFilterValueDescriptor.expected_type
    • CustomFilterValueDescriptor.pattern
  • CustomFilters
    • CustomFilters.customFilter
    • CustomFilters.tagname
  • DateGroupItem
    • DateGroupItem.dateTimeGrouping
    • DateGroupItem.day
    • DateGroupItem.hour
    • DateGroupItem.minute
    • DateGroupItem.month
    • DateGroupItem.second
    • DateGroupItem.tagname
    • DateGroupItem.year
  • DynamicFilter
    • DynamicFilter.maxVal
    • DynamicFilter.maxValIso
    • DynamicFilter.tagname
    • DynamicFilter.type
    • DynamicFilter.val
    • DynamicFilter.valIso
  • FilterColumn
    • FilterColumn.colId
    • FilterColumn.col_id
    • FilterColumn.colorFilter
    • FilterColumn.customFilters
    • FilterColumn.dynamicFilter
    • FilterColumn.extLst
    • FilterColumn.filters
    • FilterColumn.hiddenButton
    • FilterColumn.iconFilter
    • FilterColumn.showButton
    • FilterColumn.tagname
    • FilterColumn.top10
  • Filters
    • Filters.blank
    • Filters.calendarType
    • Filters.dateGroupItem
    • Filters.filter
    • Filters.tagname
  • IconFilter
    • IconFilter.iconId
    • IconFilter.iconSet
    • IconFilter.tagname
  • SortCondition
    • SortCondition.customList
    • SortCondition.descending
    • SortCondition.dxfId
    • SortCondition.iconId
    • SortCondition.iconSet
    • SortCondition.ref
    • SortCondition.sortBy
    • SortCondition.tagname
  • SortState
    • SortState.caseSensitive
    • SortState.columnSort
    • SortState.extLst
    • SortState.ref
    • SortState.sortCondition
    • SortState.sortMethod
    • SortState.tagname
  • Top10
    • Top10.filterVal
    • Top10.percent
    • Top10.tagname
    • Top10.top
    • Top10.val
• openpyxl.worksheet.formula module
  • ArrayFormula
    • ArrayFormula.t
  • DataTableFormula
    • DataTableFormula.t
• openpyxl.worksheet.header_footer module
  • HeaderFooter
    • HeaderFooter.alignWithMargins
    • HeaderFooter.differentFirst
    • HeaderFooter.differentOddEven
    • HeaderFooter.evenFooter
    • HeaderFooter.evenHeader
    • HeaderFooter.firstFooter
    • HeaderFooter.firstHeader
    • HeaderFooter.oddFooter
    • HeaderFooter.oddHeader
    • HeaderFooter.scaleWithDoc
    • HeaderFooter.tagname
  • HeaderFooterItem
    • HeaderFooterItem.center
    • HeaderFooterItem.centre
    • HeaderFooterItem.from_tree()
    • HeaderFooterItem.left
    • HeaderFooterItem.right
    • HeaderFooterItem.to_tree()
• openpyxl.worksheet.hyperlink module
  • Hyperlink
    • Hyperlink.display
    • Hyperlink.id
    • Hyperlink.location
    • Hyperlink.ref
    • Hyperlink.tagname
    • Hyperlink.target
    • Hyperlink.tooltip
  • HyperlinkList
    • HyperlinkList.append()
    • HyperlinkList.hyperlink
    • HyperlinkList.tagname
• openpyxl.worksheet.merge module
  • MergeCell
    • MergeCell.ref
    • MergeCell.tagname
  • MergeCells
    • MergeCells.count
    • MergeCells.mergeCell
    • MergeCells.tagname
  • MergedCellRange
    • MergedCellRange.format()
• openpyxl.worksheet.ole module
  • ObjectAnchor
    • ObjectAnchor.moveWithCells
    • ObjectAnchor.sizeWithCells
    • ObjectAnchor.tagname
    • ObjectAnchor.to
    • ObjectAnchor.z_order
  • ObjectPr
    • ObjectPr.altText
    • ObjectPr.anchor
    • ObjectPr.autoFill
    • ObjectPr.autoLine
    • ObjectPr.autoPict
    • ObjectPr.dde
    • ObjectPr.defaultSize
    • ObjectPr.disabled
    • ObjectPr.locked
    • ObjectPr.macro
    • ObjectPr.tagname
    • ObjectPr.uiObject
  • OleObject
    • OleObject.autoLoad
    • OleObject.dvAspect
    • OleObject.link
    • OleObject.objectPr
    • OleObject.oleUpdate
    • OleObject.progId
    • OleObject.shapeId
    • OleObject.tagname
  • OleObjects
    • OleObjects.oleObject
    • OleObjects.tagname
• openpyxl.worksheet.page module
  • PageMargins
    • PageMargins.bottom
    • PageMargins.footer
    • PageMargins.header
    • PageMargins.left
    • PageMargins.right
    • PageMargins.tagname
    • PageMargins.top
  • PrintOptions
    • PrintOptions.gridLines
    • PrintOptions.gridLinesSet
    • PrintOptions.headings
    • PrintOptions.horizontalCentered
    • PrintOptions.tagname
    • PrintOptions.verticalCentered
  • PrintPageSetup
    • PrintPageSetup.autoPageBreaks
    • PrintPageSetup.blackAndWhite
    • PrintPageSetup.cellComments
    • PrintPageSetup.copies
    • PrintPageSetup.draft
    • PrintPageSetup.errors
    • PrintPageSetup.firstPageNumber
    • PrintPageSetup.fitToHeight
    • PrintPageSetup.fitToPage
    • PrintPageSetup.fitToWidth
    • PrintPageSetup.from_tree()
    • PrintPageSetup.horizontalDpi
    • PrintPageSetup.id
    • PrintPageSetup.orientation
    • PrintPageSetup.pageOrder
    • PrintPageSetup.paperHeight
    • PrintPageSetup.paperSize
    • PrintPageSetup.paperWidth
    • PrintPageSetup.scale
    • PrintPageSetup.sheet_properties
    • PrintPageSetup.tagname
    • PrintPageSetup.useFirstPageNumber
    • PrintPageSetup.usePrinterDefaults
    • PrintPageSetup.verticalDpi
• openpyxl.worksheet.pagebreak module
  • Break
    • Break.id
    • Break.man
    • Break.max
    • Break.min
    • Break.pt
    • Break.tagname
  • ColBreak
    • ColBreak.brk
    • ColBreak.count
    • ColBreak.manualBreakCount
    • ColBreak.tagname
  • PageBreak
  • RowBreak
    • RowBreak.append()
    • RowBreak.brk
    • RowBreak.count
    • RowBreak.manualBreakCount
    • RowBreak.tagname
• openpyxl.worksheet.picture module
  • SheetBackgroundPicture
    • SheetBackgroundPicture.tagname
• openpyxl.worksheet.print_settings module
  • ColRange
    • ColRange.max_col
    • ColRange.min_col
  • PrintArea
    • PrintArea.from_string()
  • PrintTitles
    • PrintTitles.cols
    • PrintTitles.from_string()
    • PrintTitles.rows
    • PrintTitles.title
  • RowRange
    • RowRange.max_row
    • RowRange.min_row
• openpyxl.worksheet.properties module
  • Outline
    • Outline.applyStyles
    • Outline.showOutlineSymbols
    • Outline.summaryBelow
    • Outline.summaryRight
    • Outline.tagname
  • PageSetupProperties
    • PageSetupProperties.autoPageBreaks
    • PageSetupProperties.fitToPage
    • PageSetupProperties.tagname
  • WorksheetProperties
    • WorksheetProperties.codeName
    • WorksheetProperties.enableFormatConditionsCalculation
    • WorksheetProperties.filterMode
    • WorksheetProperties.outlinePr
    • WorksheetProperties.pageSetUpPr
    • WorksheetProperties.published
    • WorksheetProperties.syncHorizontal
    • WorksheetProperties.syncRef
    • WorksheetProperties.syncVertical
    • WorksheetProperties.tabColor
    • WorksheetProperties.tagname
    • WorksheetProperties.transitionEntry
    • WorksheetProperties.transitionEvaluation
• openpyxl.worksheet.protection module
  • SheetProtection
    • SheetProtection.algorithmName
    • SheetProtection.autoFilter
    • SheetProtection.deleteColumns
    • SheetProtection.deleteRows
    • SheetProtection.disable()
    • SheetProtection.enable()
    • SheetProtection.enabled
    • SheetProtection.formatCells
    • SheetProtection.formatColumns
    • SheetProtection.formatRows
    • SheetProtection.hashValue
    • SheetProtection.insertColumns
    • SheetProtection.insertHyperlinks
    • SheetProtection.insertRows
    • SheetProtection.objects
    • SheetProtection.pivotTables
    • SheetProtection.saltValue
    • SheetProtection.scenarios
    • SheetProtection.selectLockedCells
    • SheetProtection.selectUnlockedCells
    • SheetProtection.set_password()
    • SheetProtection.sheet
    • SheetProtection.sort
    • SheetProtection.spinCount
    • SheetProtection.tagname
• openpyxl.worksheet.related module
  • Related
    • Related.id
    • Related.to_tree()
• openpyxl.worksheet.scenario module
  • InputCells
    • InputCells.deleted
    • InputCells.numFmtId
    • InputCells.r
    • InputCells.tagname
    • InputCells.undone
    • InputCells.val
  • Scenario
    • Scenario.comment
    • Scenario.count
    • Scenario.hidden
    • Scenario.inputCells
    • Scenario.locked
    • Scenario.name
    • Scenario.tagname
    • Scenario.user
  • ScenarioList
    • ScenarioList.append()
    • ScenarioList.current
    • ScenarioList.scenario
    • ScenarioList.show
    • ScenarioList.sqref
    • ScenarioList.tagname
• openpyxl.worksheet.smart_tag module
  • CellSmartTag
    • CellSmartTag.cellSmartTagPr
    • CellSmartTag.deleted
    • CellSmartTag.tagname
    • CellSmartTag.type
    • CellSmartTag.xmlBased
  • CellSmartTagPr
    • CellSmartTagPr.key
    • CellSmartTagPr.tagname
    • CellSmartTagPr.val
  • CellSmartTags
    • CellSmartTags.cellSmartTag
    • CellSmartTags.r
    • CellSmartTags.tagname
  • SmartTags
    • SmartTags.cellSmartTags
    • SmartTags.tagname
• openpyxl.worksheet.table module
  • Table
    • Table.autoFilter
    • Table.column_names
    • Table.comment
    • Table.connectionId
    • Table.dataCellStyle
    • Table.dataDxfId
    • Table.displayName
    • Table.extLst
    • Table.headerRowBorderDxfId
    • Table.headerRowCellStyle
    • Table.headerRowCount
    • Table.headerRowDxfId
    • Table.id
    • Table.insertRow
    • Table.insertRowShift
    • Table.mime_type
    • Table.name
    • Table.path
    • Table.published
    • Table.ref
    • Table.sortState
    • Table.tableBorderDxfId
    • Table.tableColumns
    • Table.tableStyleInfo
    • Table.tableType
    • Table.tagname
    • Table.to_tree()
    • Table.totalsRowBorderDxfId
    • Table.totalsRowCellStyle
    • Table.totalsRowCount
    • Table.totalsRowDxfId
    • Table.totalsRowShown
  • TableColumn
    • TableColumn.calculatedColumnFormula
    • TableColumn.dataCellStyle
    • TableColumn.dataDxfId
    • TableColumn.extLst
    • TableColumn.from_tree()
    • TableColumn.headerRowCellStyle
    • TableColumn.headerRowDxfId
    • TableColumn.id
    • TableColumn.name
    • TableColumn.queryTableFieldId
    • TableColumn.tagname
    • TableColumn.totalsRowCellStyle
    • TableColumn.totalsRowDxfId
    • TableColumn.totalsRowFormula
    • TableColumn.totalsRowFunction
    • TableColumn.totalsRowLabel
    • TableColumn.uniqueName
    • TableColumn.xmlColumnPr
  • TableFormula
    • TableFormula.array
    • TableFormula.attr_text
    • TableFormula.tagname
    • TableFormula.text
  • TableList
    • TableList.add()
    • TableList.get()
    • TableList.items()
  • TableNameDescriptor
  • TablePartList
    • TablePartList.append()
    • TablePartList.count
    • TablePartList.tablePart
    • TablePartList.tagname
  • TableStyleInfo
    • TableStyleInfo.name
    • TableStyleInfo.showColumnStripes
    • TableStyleInfo.showFirstColumn
    • TableStyleInfo.showLastColumn
    • TableStyleInfo.showRowStripes
    • TableStyleInfo.tagname
  • XMLColumnProps
    • XMLColumnProps.denormalized
    • XMLColumnProps.extLst
    • XMLColumnProps.mapId
    • XMLColumnProps.tagname
    • XMLColumnProps.xmlDataType
    • XMLColumnProps.xpath
• openpyxl.worksheet.views module
  • Pane
    • Pane.activePane
    • Pane.state
    • Pane.topLeftCell
    • Pane.xSplit
    • Pane.ySplit
  • Selection
    • Selection.activeCell
    • Selection.activeCellId
    • Selection.pane
    • Selection.sqref
  • SheetView
    • SheetView.colorId
    • SheetView.defaultGridColor
    • SheetView.pane
    • SheetView.rightToLeft
    • SheetView.selection
    • SheetView.showFormulas
    • SheetView.showGridLines
    • SheetView.showOutlineSymbols
    • SheetView.showRowColHeaders
    • SheetView.showRuler
    • SheetView.showWhiteSpace
    • SheetView.showZeros
    • SheetView.tabSelected
    • SheetView.tagname
    • SheetView.topLeftCell
    • SheetView.view
    • SheetView.windowProtection
    • SheetView.workbookViewId
    • SheetView.zoomScale
    • SheetView.zoomScaleNormal
    • SheetView.zoomScalePageLayoutView
    • SheetView.zoomScaleSheetLayoutView
    • SheetView.zoomToFit
  • SheetViewList
    • SheetViewList.extLst
    • SheetViewList.sheetView
    • SheetViewList.tagname
• openpyxl.worksheet.worksheet module
  • Worksheet
    • Worksheet.BREAK_COLUMN
    • Worksheet.BREAK_NONE
    • Worksheet.BREAK_ROW
    • Worksheet.ORIENTATION_LANDSCAPE
    • Worksheet.ORIENTATION_PORTRAIT
    • Worksheet.PAPERSIZE_A3
    • Worksheet.PAPERSIZE_A4
    • Worksheet.PAPERSIZE_A4_SMALL
    • Worksheet.PAPERSIZE_A5
    • Worksheet.PAPERSIZE_EXECUTIVE
    • Worksheet.PAPERSIZE_LEDGER
    • Worksheet.PAPERSIZE_LEGAL
    • Worksheet.PAPERSIZE_LETTER
    • Worksheet.PAPERSIZE_LETTER_SMALL
    • Worksheet.PAPERSIZE_STATEMENT
    • Worksheet.PAPERSIZE_TABLOID
    • Worksheet.SHEETSTATE_HIDDEN
    • Worksheet.SHEETSTATE_VERYHIDDEN
    • Worksheet.SHEETSTATE_VISIBLE
    • Worksheet.active_cell
    • Worksheet.add_chart()
    • Worksheet.add_data_validation()
    • Worksheet.add_image()
    • Worksheet.add_pivot()
    • Worksheet.add_table()
    • Worksheet.append()
    • Worksheet.array_formulae
    • Worksheet.calculate_dimension()
    • Worksheet.cell()
    • Worksheet.columns
    • Worksheet.delete_cols()
    • Worksheet.delete_rows()
    • Worksheet.dimensions
    • Worksheet.freeze_panes
    • Worksheet.insert_cols()
    • Worksheet.insert_rows()
    • Worksheet.iter_cols()
    • Worksheet.iter_rows()
    • Worksheet.max_column
    • Worksheet.max_row
    • Worksheet.merge_cells()
    • Worksheet.merged_cell_ranges
    • Worksheet.mime_type
    • Worksheet.min_column
    • Worksheet.min_row
    • Worksheet.move_range()
    • Worksheet.print_area
    • Worksheet.print_title_cols
    • Worksheet.print_title_rows
    • Worksheet.print_titles
    • Worksheet.rows
    • Worksheet.selected_cell
    • Worksheet.set_printer_settings()
    • Worksheet.sheet_view
    • Worksheet.show_gridlines
    • Worksheet.tables
    • Worksheet.unmerge_cells()
    • Worksheet.values
  • isgenerator()