Index

A

above_average() (pyopenxlsx.XLCfRule method) AboveAverage (pyopenxlsx.XLCfType attribute) Absolute (pyopenxlsx.XLImagePositioning attribute) active (pyopenxlsx.Workbook property) add() (pyopenxlsx.XLSlicerCollection method) (pyopenxlsx.XLTables method) add_author() (pyopenxlsx.XLComments method) add_bubble_series() (pyopenxlsx.XLChart method) add_cell() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) add_chart() (in module pyopenxlsx) (pyopenxlsx.XLWorksheet method) add_chart_anchor() (pyopenxlsx.XLWorksheet method) add_chartsheet() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) add_column_field() (pyopenxlsx.XLPivotTableOptions method) add_comment() (pyopenxlsx.XLCell method) (pyopenxlsx.XLThreadedComments method) (pyopenxlsx.XLWorksheet method) add_conditional_formatting() (pyopenxlsx.XLWorksheet method) add_conditional_formatting_dxf() (pyopenxlsx.XLWorksheet method) add_data_field() (pyopenxlsx.XLPivotTableOptions method) add_error_bars() (pyopenxlsx.XLChartSeries method) add_filter() (pyopenxlsx.XLFilterColumn method) add_filter_field() (pyopenxlsx.XLPivotTableOptions method) add_formula() (pyopenxlsx.XLCfRule method) add_heading_pair() (pyopenxlsx.XLAppProperties method) add_hyperlink() (pyopenxlsx.XLWorksheet method) add_image() (pyopenxlsx.XLDocument method) (pyopenxlsx.XLDrawing method) (pyopenxlsx.XLWorksheet method) add_internal_hyperlink() (pyopenxlsx.XLWorksheet method) add_note() (pyopenxlsx.XLCell method) (pyopenxlsx.XLWorksheet method) add_override() (pyopenxlsx.XLContentTypes method) add_person() (pyopenxlsx.XLPersons method) add_pivot() (pyopenxlsx.XLSlicerCollection method) add_pivot_slicer() (pyopenxlsx.XLWorksheet method) add_pivot_table() (pyopenxlsx.XLWorksheet method) add_range() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) (pyopenxlsx.XLTables method) add_relationship() (pyopenxlsx.XLRelationships method) add_reply() (pyopenxlsx.XLThreadedComments method) (pyopenxlsx.XLWorksheet method) add_row_field() (pyopenxlsx.XLPivotTableOptions method) add_run() (pyopenxlsx.XLRichText method) add_scaled_image() (pyopenxlsx.XLDrawing method) (pyopenxlsx.XLWorksheet method) add_series() (pyopenxlsx.XLChart method) add_series_ref() (pyopenxlsx.XLChart method) add_shape() (pyopenxlsx.XLDrawing method) (pyopenxlsx.XLWorksheet method) add_sheet_name() (pyopenxlsx.XLAppProperties method) add_sort_condition() (pyopenxlsx.XLWorksheet method) add_sparkline() (pyopenxlsx.XLWorksheet method) add_style() (pyopenxlsx.Workbook method) add_style_async() (pyopenxlsx.Workbook method) add_table_slicer() (pyopenxlsx.XLWorksheet method) add_threaded_comment() (pyopenxlsx.XLWorksheet method) add_threaded_reply() (pyopenxlsx.XLWorksheet method) add_to() (pyopenxlsx.PivotTableBuilder method) add_trendline() (pyopenxlsx.XLChartSeries method) add_validation() (pyopenxlsx.DataValidations method) (pyopenxlsx.XLDataValidations method) add_worksheet() (pyopenxlsx.XLWorkbook method) address (pyopenxlsx.Range property) address() (pyopenxlsx.XLCellKey method) (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLCellReference method) align_with_margins() (pyopenxlsx.XLHeaderFooter method)

align_worksheets() (pyopenxlsx.XLAppProperties method) Alignment (class in pyopenxlsx) alignment (pyopenxlsx.Cell property) (pyopenxlsx.XLStyle property) alignment() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLDxf method) all() (pyopenxlsx.DefinedNames method) (pyopenxlsx.XLDefinedNames method) allow_blank (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) allow_blank() (pyopenxlsx.XLDataValidation method) allow_in_cell() (pyopenxlsx.XLShape method) alpha() (pyopenxlsx.XLColor method) anchor() (pyopenxlsx.XLShapeClientData method) And (pyopenxlsx.XLFilterLogic attribute) app_properties() (pyopenxlsx.XLDocument method) append() (pyopenxlsx.DataValidations method) (pyopenxlsx.DefinedNames method) (pyopenxlsx.Worksheet method) (pyopenxlsx.XLDataValidations method) (pyopenxlsx.XLDefinedNames method) append_async() (pyopenxlsx.Worksheet method) append_column() (pyopenxlsx.Table method) (pyopenxlsx.XLTable method) append_merge() (pyopenxlsx.XLMergeCells method) append_row() (pyopenxlsx.StreamWriter method) (pyopenxlsx.XLStreamWriter method) (pyopenxlsx.XLWorksheet method) append_rows() (pyopenxlsx.XLStreamWriter method) append_sheet_name() (pyopenxlsx.XLAppProperties method) Application (pyopenxlsx.XLProperty attribute) apply_alignment() (pyopenxlsx.XLCellFormat method) apply_auto_filter() (pyopenxlsx.XLWorksheet method) apply_border() (pyopenxlsx.XLCellFormat method) apply_config() (pyopenxlsx.XLDataValidation method) apply_fill() (pyopenxlsx.XLCellFormat method) apply_font() (pyopenxlsx.XLCellFormat method) apply_number_format() (pyopenxlsx.XLCellFormat method) apply_number_formats (pyopenxlsx.XLStreamReadOptions property) apply_protection() (pyopenxlsx.XLCellFormat method) apply_style() (pyopenxlsx.XLCellRange method) AppVersion (pyopenxlsx.XLProperty attribute) Area (pyopenxlsx.XLChartType attribute) Area3D (pyopenxlsx.XLChartType attribute) Area3DPercentStacked (pyopenxlsx.XLChartType attribute) Area3DStacked (pyopenxlsx.XLChartType attribute) AreaPercentStacked (pyopenxlsx.XLChartType attribute) AreaStacked (pyopenxlsx.XLChartType attribute) Arrow (pyopenxlsx.XLVectorShapeType attribute) arrow_end (pyopenxlsx.XLVectorShapeOptions property) arrow_start (pyopenxlsx.XLVectorShapeOptions property) as_chartsheet() (pyopenxlsx.XLSheet method) as_datetime() (pyopenxlsx.XLDateTime method) as_worksheet() (pyopenxlsx.XLSheet method) at() (pyopenxlsx.XLDataValidations method) author() (pyopenxlsx.XLComments method) author_count() (pyopenxlsx.XLComments method) author_id() (pyopenxlsx.XLComment method) auto_fill() (pyopenxlsx.XLShapeClientData method) auto_filter (pyopenxlsx.XLSheetProtectionOptions property) auto_filter() (pyopenxlsx.XLWorksheet method) auto_filter_allowed() (pyopenxlsx.XLWorksheet method) auto_fit_column() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) auto_track_changes (pyopenxlsx.XLCalculationOptions property) autofilter_object() (pyopenxlsx.XLWorksheet method) automatic() (pyopenxlsx.XLDataBarColor method) AutoZero (pyopenxlsx.XLAxisCrosses attribute) Average (pyopenxlsx.XLPivotSubtotal attribute) (pyopenxlsx.XLTotalsRowFunction attribute) average() (pyopenxlsx.FormulaEngine method) axis() (pyopenxlsx.XLChart method)

B

background_color() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) Bar (pyopenxlsx.XLChartType attribute) Bar3D (pyopenxlsx.XLChartType attribute) Bar3DPercentStacked (pyopenxlsx.XLChartType attribute) Bar3DStacked (pyopenxlsx.XLChartType attribute) BarPercentStacked (pyopenxlsx.XLChartType attribute) BarStacked (pyopenxlsx.XLChartType attribute) Baseline (pyopenxlsx.XLVerticalAlignRunStyle attribute) BeginsWith (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLCfType attribute) Between (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) bg_color (pyopenxlsx.XLStyle.Fill property) black_and_white (pyopenxlsx.PageSetup property) black_and_white() (pyopenxlsx.XLPageSetup method) blue() (pyopenxlsx.XLColor method) bold (pyopenxlsx.XLRichTextRun property) (pyopenxlsx.XLStyle.Font property) bold() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) Border (class in pyopenxlsx)

border (pyopenxlsx.Cell property) (pyopenxlsx.XLStyle property) border() (pyopenxlsx.XLDxf method) border_by_index() (pyopenxlsx.XLBorders method) border_index() (pyopenxlsx.XLCellFormat method) borders() (pyopenxlsx.XLStyles method) Both (pyopenxlsx.XLErrorBarType attribute) bottom (pyopenxlsx.PageMargins property) Bottom (pyopenxlsx.XLAlignmentStyle attribute) (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLShapeTextVAlign attribute) bottom (pyopenxlsx.XLStyle.Border property) bottom() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLPageMargins method) bottom_right() (pyopenxlsx.XLCellRange method) bottom_right_cell (pyopenxlsx.XLImageOptions property) BottomLeft (pyopenxlsx.XLPane attribute) BottomRight (pyopenxlsx.XLPane attribute) Bubble (pyopenxlsx.XLChartType attribute) bubble_series() (pyopenxlsx.Chart method) build() (pyopenxlsx.XLSlicerBuilder method)

C

cache (pyopenxlsx.XLSlicer property) calc_cell_value() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) calculated_column_formula() (pyopenxlsx.XLTableColumn method) calculation_options() (in module pyopenxlsx) CalculationChain (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) CalculationEngine (class in pyopenxlsx) caption (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLSlicerOptions property) caption() (pyopenxlsx.XLSlicerBuilder method) Category (pyopenxlsx.XLProperty attribute) Cell (class in pyopenxlsx) cell() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) cell_count() (pyopenxlsx.XLRow method) cell_format() (pyopenxlsx.XLCell method) cell_format_by_index() (pyopenxlsx.XLCellFormats method) cell_formats() (pyopenxlsx.XLStyles method) cell_ref (pyopenxlsx.XLSlicer property) cell_reference() (pyopenxlsx.XLCell method) CellIs (pyopenxlsx.XLCfType attribute) Center (pyopenxlsx.XLAlignmentStyle attribute) (pyopenxlsx.XLShapeTextHAlign attribute) (pyopenxlsx.XLShapeTextVAlign attribute) CenterContinuous (pyopenxlsx.XLAlignmentStyle attribute) cf_rule_by_index() (pyopenxlsx.XLCfRules method) cf_rules() (pyopenxlsx.XLConditionalFormat method) Chart (class in pyopenxlsx) (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) chart_area_color() (pyopenxlsx.Chart method) chart_type() (in module pyopenxlsx) ChartColorStyle (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) Chartsheet (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) (pyopenxlsx.XLSheetType attribute) chartsheet() (pyopenxlsx.XLWorkbook method) chartsheet_count() (pyopenxlsx.XLWorkbook method) chartsheet_exists() (pyopenxlsx.XLWorkbook method) chartsheet_names() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) ChartStyle (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) Circle (pyopenxlsx.XLMarkerStyle attribute) Circular (pyopenxlsx.XLCalcStatus attribute) circular_error_token (pyopenxlsx.XLCalculationOptions property) cleanup_shared_strings() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) clear() (pyopenxlsx.DataValidations method) (pyopenxlsx.Formula method) (pyopenxlsx.Range method) (pyopenxlsx.XLCell method) (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLDataValidations method) (pyopenxlsx.XLFormula method) (pyopenxlsx.XLFormulaDiagnosticReporter method) (pyopenxlsx.XLRichText method) clear_active_tab() (pyopenxlsx.XLWorkbook method) clear_all_conditional_formatting() (pyopenxlsx.XLWorksheet method) clear_async() (pyopenxlsx.Range method) clear_auto_filter() (pyopenxlsx.XLWorksheet method) clear_cache() (pyopenxlsx.XLCalculationEngine method) clear_filters() (pyopenxlsx.XLFilterColumn method) clear_formula() (pyopenxlsx.XLCell method) clear_formulas() (pyopenxlsx.XLCfRule method) clear_max_bounds() (pyopenxlsx.XLAxis method) clear_min_bounds() (pyopenxlsx.XLAxis method) clear_panes() (pyopenxlsx.XLWorksheet method) clear_password() (pyopenxlsx.XLWorksheet method) clear_sheet_protection() (pyopenxlsx.XLWorksheet method) client_data() (pyopenxlsx.XLShape method) clone_sheet() (pyopenxlsx.XLWorkbook method) close() (pyopenxlsx.StreamWriter method) (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLStreamReader method) (pyopenxlsx.XLStreamWriter method) close_async() (pyopenxlsx.Workbook method) Cloud (pyopenxlsx.XLVectorShapeType attribute) col (pyopenxlsx.XLCellKey property) (pyopenxlsx.XLChartAnchor property) col() (pyopenxlsx.XLDrawingItem method) col_id() (pyopenxlsx.XLFilterColumn method) color (pyopenxlsx.XLStyle.BorderElement property) (pyopenxlsx.XLStyle.Font property) color() (pyopenxlsx.Fill method) (pyopenxlsx.Font method) (pyopenxlsx.Side method) (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLFill method) (pyopenxlsx.XLFont method) (pyopenxlsx.XLLine method) (pyopenxlsx.XLSheet method)

ColorScale (pyopenxlsx.XLCfType attribute) Column (class in pyopenxlsx) (pyopenxlsx.XLChartType attribute) (pyopenxlsx.XLSparklineType attribute) column() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLShapeClientData method) (pyopenxlsx.XLTable method) (pyopenxlsx.XLWorksheet method) Column3D (pyopenxlsx.XLChartType attribute) Column3DPercentStacked (pyopenxlsx.XLChartType attribute) Column3DStacked (pyopenxlsx.XLChartType attribute) column_count (pyopenxlsx.XLSlicer property) column_count() (pyopenxlsx.XLSlicerBuilder method) (pyopenxlsx.XLWorksheet method) column_format() (pyopenxlsx.XLWorksheet method) ColumnPercentStacked (pyopenxlsx.XLChartType attribute) columns (pyopenxlsx.XLPivotTableOptions property) columns() (pyopenxlsx.PivotTableBuilder method) ColumnStacked (pyopenxlsx.XLChartType attribute) comment (pyopenxlsx.Cell property) comment() (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLTable method) (pyopenxlsx.XLThreadedComments method) Comments (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) comments() (pyopenxlsx.XLWorksheet method) compact() (pyopenxlsx.PivotTableBuilder method) Company (pyopenxlsx.XLProperty attribute) compression_level() (pyopenxlsx.XLDocument method) conditional_formats() (pyopenxlsx.XLWorksheet method) config() (pyopenxlsx.XLDataValidation method) configure() (pyopenxlsx.PivotTableBuilder method) contains() (pyopenxlsx.XLSlicerCollection method) ContainsBlanks (pyopenxlsx.XLCfType attribute) ContainsErrors (pyopenxlsx.XLCfType attribute) ContainsText (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLCfType attribute) content_item() (pyopenxlsx.XLContentTypes method) content_types() (pyopenxlsx.XLDocument method) ControlProperties (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) copy_from() (pyopenxlsx.XLCell method) copy_worksheet() (pyopenxlsx.Workbook method) copy_worksheet_async() (pyopenxlsx.Workbook method) core_properties() (pyopenxlsx.XLDocument method) CoreProperties (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) Count (pyopenxlsx.XLPivotSubtotal attribute) count (pyopenxlsx.XLSlicerCollection property) Count (pyopenxlsx.XLTotalsRowFunction attribute) count() (pyopenxlsx.DefinedNames method) (pyopenxlsx.FormulaEngine method) (pyopenxlsx.XLBorders method) (pyopenxlsx.XLCellFormats method) (pyopenxlsx.XLCfRules method) (pyopenxlsx.XLComments method) (pyopenxlsx.XLConditionalFormats method) (pyopenxlsx.XLDataValidations method) (pyopenxlsx.XLDefinedNames method) (pyopenxlsx.XLFills method) (pyopenxlsx.XLFonts method) (pyopenxlsx.XLMergeCells method) (pyopenxlsx.XLNumberFormats method) (pyopenxlsx.XLTables method) CountNums (pyopenxlsx.XLTotalsRowFunction attribute) create() (pyopenxlsx.XLBorders method) (pyopenxlsx.XLCellFormats method) (pyopenxlsx.XLCfRules method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLFills method) (pyopenxlsx.XLFonts method) (pyopenxlsx.XLNumberFormats method) create_chart() (pyopenxlsx.XLDocument method) create_drawing() (pyopenxlsx.XLDocument method) create_pivot_table() (pyopenxlsx.XLDocument method) create_shape() (pyopenxlsx.XLVmlDrawing method) create_sheet() (pyopenxlsx.Workbook method) create_sheet_async() (pyopenxlsx.Workbook method) CreationDate (pyopenxlsx.XLProperty attribute) Creator (pyopenxlsx.XLProperty attribute) current_col (pyopenxlsx.XLEvalSession property) current_row (pyopenxlsx.XLEvalSession property) current_row() (pyopenxlsx.XLStreamReader method) current_row_index (pyopenxlsx.XLStreamReader property) current_row_opts() (pyopenxlsx.XLStreamReader method) current_sheet (pyopenxlsx.XLEvalSession property) Custom (pyopenxlsx.XLDataValidationType attribute) (pyopenxlsx.XLErrorBarValueType attribute) (pyopenxlsx.XLSlicerStyle attribute) (pyopenxlsx.XLTotalsRowFunction attribute) custom_name (pyopenxlsx.XLPivotField property) custom_properties (pyopenxlsx.Workbook property) custom_property() (pyopenxlsx.XLDocument method) CustomProperties (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute)

D

Dark1 (pyopenxlsx.XLSlicerStyle attribute) Dark2 (pyopenxlsx.XLSlicerStyle attribute) Dark3 (pyopenxlsx.XLSlicerStyle attribute) Dark4 (pyopenxlsx.XLSlicerStyle attribute) Dark5 (pyopenxlsx.XLSlicerStyle attribute) Dark6 (pyopenxlsx.XLSlicerStyle attribute) DarkDown (pyopenxlsx.XLPatternType attribute) DarkGray (pyopenxlsx.XLPatternType attribute) DarkGrid (pyopenxlsx.XLPatternType attribute) DarkHorizontal (pyopenxlsx.XLPatternType attribute) DarkTrellis (pyopenxlsx.XLPatternType attribute) DarkUp (pyopenxlsx.XLPatternType attribute) DarkVertical (pyopenxlsx.XLPatternType attribute) Dash (pyopenxlsx.XLLineDashType attribute) (pyopenxlsx.XLMarkerStyle attribute) DashDot (pyopenxlsx.XLLineDashType attribute) (pyopenxlsx.XLLineStyle attribute) DashDotDot (pyopenxlsx.XLLineStyle attribute) Dashed (pyopenxlsx.XLLineStyle attribute) data (pyopenxlsx.XLPivotTableOptions property) data() (pyopenxlsx.PivotTableBuilder method) data_labels() (pyopenxlsx.Chart method) data_on_rows() (pyopenxlsx.PivotTableBuilder method) data_table() (pyopenxlsx.Chart method) data_validations() (pyopenxlsx.XLWorksheet method) DataBar (pyopenxlsx.XLCfType attribute) DataValidation (class in pyopenxlsx) DataValidations (class in pyopenxlsx) Date (pyopenxlsx.XLDataValidationType attribute) Decimal (pyopenxlsx.XLDataValidationType attribute) Default (pyopenxlsx.XLMarkerStyle attribute) (pyopenxlsx.XLPageOrientation attribute) default_author() (pyopenxlsx.XLDocument method) define() (pyopenxlsx.DefinedNames method) defined_names (pyopenxlsx.Workbook property) defined_names() (pyopenxlsx.XLWorkbook method) DefinedName (class in pyopenxlsx) DefinedNames (class in pyopenxlsx) delete_column() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) delete_columns (pyopenxlsx.XLSheetProtectionOptions property) delete_columns_allowed() (pyopenxlsx.XLWorksheet method) delete_comment() (pyopenxlsx.XLComments method) (pyopenxlsx.XLThreadedComments method) (pyopenxlsx.XLWorksheet method) delete_custom_property() (pyopenxlsx.XLDocument method) delete_heading_pair() (pyopenxlsx.XLAppProperties method) delete_macro() (pyopenxlsx.XLDocument method) delete_merge() (pyopenxlsx.XLMergeCells method) delete_named_ranges() (pyopenxlsx.XLWorkbook method) delete_note() (pyopenxlsx.XLWorksheet method) delete_override() (pyopenxlsx.XLContentTypes method) delete_pivot_table() (pyopenxlsx.XLWorksheet method) delete_property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method)

delete_relationship() (pyopenxlsx.XLRelationships method) delete_relationship_item() (pyopenxlsx.XLRelationships method) delete_row() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) delete_rows (pyopenxlsx.XLSheetProtectionOptions property) delete_rows_allowed() (pyopenxlsx.XLWorksheet method) delete_shape() (pyopenxlsx.XLVmlDrawing method) delete_shape_by_ref() (pyopenxlsx.XLVmlDrawing method) delete_sheet() (pyopenxlsx.XLWorkbook method) delete_sheet_name() (pyopenxlsx.XLAppProperties method) delete_slicer() (pyopenxlsx.XLWorksheet method) dependencies() (pyopenxlsx.XLCalculationEngine method) dependents() (pyopenxlsx.XLCalculationEngine method) descent() (pyopenxlsx.XLRow method) Description (pyopenxlsx.XLProperty attribute) description() (pyopenxlsx.XLDrawingItem method) diagnostics() (pyopenxlsx.XLFormulaDiagnosticReporter method) diagonal (pyopenxlsx.XLStyle.Border property) diagonal() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) diagonal_down (pyopenxlsx.XLStyle.Border property) diagonal_down() (pyopenxlsx.XLBorder method) diagonal_up (pyopenxlsx.XLStyle.Border property) diagonal_up() (pyopenxlsx.XLBorder method) Dialogsheet (pyopenxlsx.XLRelationshipType attribute) (pyopenxlsx.XLSheetType attribute) Diamond (pyopenxlsx.XLMarkerStyle attribute) (pyopenxlsx.XLVectorShapeType attribute) different_first() (pyopenxlsx.XLHeaderFooter method) different_odd_even() (pyopenxlsx.XLHeaderFooter method) dirty_count (pyopenxlsx.CalculationEngine property) (pyopenxlsx.XLCalculationEngine property) disable_prompts() (pyopenxlsx.XLDataValidations method) Disabled (pyopenxlsx.XLIMEMode attribute) display_empty_cells_as (pyopenxlsx.XLSparklineOptions property) display_name (pyopenxlsx.Table property) (pyopenxlsx.XLPerson property) display_name() (pyopenxlsx.XLTable method) display_x_axis (pyopenxlsx.XLSparklineOptions property) Distributed (pyopenxlsx.XLAlignmentStyle attribute) DocSecurity (pyopenxlsx.XLProperty attribute) Donut (pyopenxlsx.XLVectorShapeType attribute) Dot (pyopenxlsx.XLLineDashType attribute) (pyopenxlsx.XLMarkerStyle attribute) Dotted (pyopenxlsx.XLLineStyle attribute) Double (pyopenxlsx.XLLineStyle attribute) (pyopenxlsx.XLUnderlineStyle attribute) Doughnut (pyopenxlsx.XLChartType attribute) drawing (pyopenxlsx.Worksheet property) Drawing (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) drawing() (pyopenxlsx.XLDocument method) (pyopenxlsx.XLWorksheet method) DuplicateValues (pyopenxlsx.XLCfType attribute) dxf_id() (pyopenxlsx.XLCfRule method)

E

Ellipse (pyopenxlsx.XLVectorShapeType attribute) EmitEmptyRows (pyopenxlsx.XLStreamEmptyRowPolicy attribute) Empty (pyopenxlsx.XLCalcStatus attribute) empty (pyopenxlsx.XLSlicerCollection property) empty() (pyopenxlsx.XLCell method) (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLCfRules method) (pyopenxlsx.XLConditionalFormat method) (pyopenxlsx.XLConditionalFormats method) (pyopenxlsx.XLDataValidation method) (pyopenxlsx.XLDataValidations method) (pyopenxlsx.XLDxf method) (pyopenxlsx.XLRelationshipItem method) (pyopenxlsx.XLRichText method) (pyopenxlsx.XLRow method) empty_rows (pyopenxlsx.XLStreamReadOptions property) end_col (pyopenxlsx.XLVectorShapeOptions property) end_offset_x (pyopenxlsx.XLVectorShapeOptions property) end_offset_y (pyopenxlsx.XLVectorShapeOptions property) end_row (pyopenxlsx.XLVectorShapeOptions property) EndsWith (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLCfType attribute) Equal (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) equal_average() (pyopenxlsx.XLCfRule method) error (pyopenxlsx.DataValidation property)

Error (pyopenxlsx.XLCalcStatus attribute) error (pyopenxlsx.XLDataValidationConfig property) error() (pyopenxlsx.XLDataValidation method) error_style (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) error_style() (pyopenxlsx.XLDataValidation method) error_title (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) error_title() (pyopenxlsx.XLDataValidation method) evaluate() (pyopenxlsx.FormulaEngine method) (pyopenxlsx.XLFormulaEngine method) evaluate_many() (pyopenxlsx.FormulaEngine method) even_footer() (pyopenxlsx.XLHeaderFooter method) even_header() (pyopenxlsx.XLHeaderFooter method) exists() (pyopenxlsx.DefinedNames method) (pyopenxlsx.XLDefinedNames method) Exponential (pyopenxlsx.XLTrendlineType attribute) Expression (pyopenxlsx.XLCfType attribute) ExtendedProperties (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) extension (pyopenxlsx.ImageInfo property) ExternalLink (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) ExternalLinkPath (pyopenxlsx.XLRelationshipType attribute) extract_dependencies (pyopenxlsx.XLCalculationEngine attribute) extract_images() (pyopenxlsx.Workbook method) extract_images_async() (pyopenxlsx.Workbook method)

F

fg_color (pyopenxlsx.XLStyle.Fill property) Fill (class in pyopenxlsx) fill (pyopenxlsx.Cell property) Fill (pyopenxlsx.XLAlignmentStyle attribute) fill (pyopenxlsx.XLStyle property) fill() (pyopenxlsx.XLDxf method) fill_by_index() (pyopenxlsx.XLFills method) fill_color (pyopenxlsx.XLVectorShapeOptions property) fill_color() (pyopenxlsx.XLShape method) fill_index() (pyopenxlsx.XLCellFormat method) fill_type() (pyopenxlsx.XLFill method) fills() (pyopenxlsx.XLStyles method) filter_column() (pyopenxlsx.XLAutoFilter method) filters (pyopenxlsx.XLPivotTableOptions property) filters() (pyopenxlsx.PivotTableBuilder method) find() (pyopenxlsx.XLSlicerCollection method) find_cell() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLRow method) (pyopenxlsx.XLWorksheet method) find_merge() (pyopenxlsx.XLMergeCells method) first (pyopenxlsx.XLSparklineOptions property) first_footer() (pyopenxlsx.XLHeaderFooter method) first_header() (pyopenxlsx.XLHeaderFooter method) first_marker_color (pyopenxlsx.XLSparklineOptions property) first_page_number() (pyopenxlsx.XLPageSetup method) fit_to_height (pyopenxlsx.PageSetup property) fit_to_height() (pyopenxlsx.XLPageSetup method) fit_to_pages() (pyopenxlsx.XLWorksheet method) fit_to_width (pyopenxlsx.PageSetup property) fit_to_width() (pyopenxlsx.XLPageSetup method) FixedValue (pyopenxlsx.XLErrorBarValueType attribute) flip_h (pyopenxlsx.XLVectorShapeOptions property) flip_v (pyopenxlsx.XLVectorShapeOptions property) FlowChartData (pyopenxlsx.XLVectorShapeType attribute) FlowChartDecision (pyopenxlsx.XLVectorShapeType attribute) FlowChartDocument (pyopenxlsx.XLVectorShapeType attribute) FlowChartProcess (pyopenxlsx.XLVectorShapeType attribute) flush() (pyopenxlsx.XLStreamWriter method) Font (class in pyopenxlsx) font (pyopenxlsx.Cell property) (pyopenxlsx.XLStyle property)

font() (pyopenxlsx.XLDxf method) font_by_index() (pyopenxlsx.XLFonts method) font_color (pyopenxlsx.XLRichTextRun property) font_index() (pyopenxlsx.XLCellFormat method) font_name (pyopenxlsx.XLRichTextRun property) font_size (pyopenxlsx.XLRichTextRun property) fonts() (pyopenxlsx.XLStyles method) footer (pyopenxlsx.PageMargins property) footer() (pyopenxlsx.XLPageMargins method) format() (pyopenxlsx.XLColumn method) (pyopenxlsx.XLNumberFormatter method) (pyopenxlsx.XLRow method) format_cells (pyopenxlsx.XLSheetProtectionOptions property) format_cells_allowed() (pyopenxlsx.XLWorksheet method) format_code() (pyopenxlsx.XLNumberFormat method) format_columns (pyopenxlsx.XLSheetProtectionOptions property) format_columns_allowed() (pyopenxlsx.XLWorksheet method) format_rows (pyopenxlsx.XLSheetProtectionOptions property) format_rows_allowed() (pyopenxlsx.XLWorksheet method) Formula (class in pyopenxlsx) formula (pyopenxlsx.Cell property) Formula (pyopenxlsx.XLCfvoType attribute) formula() (pyopenxlsx.XLCfRule method) formula1 (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) formula1() (pyopenxlsx.XLDataValidation method) formula2 (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) formula2() (pyopenxlsx.XLDataValidation method) formula_count (pyopenxlsx.CalculationEngine property) (pyopenxlsx.XLCalculationEngine property) FormulaEngine (class in pyopenxlsx) formulas() (pyopenxlsx.XLCfRule method) freeze_panes() (pyopenxlsx.XLWorksheet method) Frozen (pyopenxlsx.XLPaneState attribute) FrozenSplit (pyopenxlsx.XLPaneState attribute) FullAlpha (pyopenxlsx.XLIMEMode attribute) FullHangul (pyopenxlsx.XLIMEMode attribute) FullKatakana (pyopenxlsx.XLIMEMode attribute)

G

gap_width() (pyopenxlsx.Chart method) General (pyopenxlsx.XLAlignmentStyle attribute) get() (pyopenxlsx.DefinedNames method) (pyopenxlsx.XLComments method) (pyopenxlsx.XLDefinedNames method) (pyopenxlsx.XLFormula method) get_archive_entries() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_archive_entry() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_cell_value() (pyopenxlsx.XLWorksheet method) get_content_items() (pyopenxlsx.XLContentTypes method) get_embedded_images() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_formula() (pyopenxlsx.XLCell method) get_full_report() (pyopenxlsx.XLFormulaDiagnosticReporter method) get_hyperlink() (pyopenxlsx.XLWorksheet method) get_image() (pyopenxlsx.XLDocument method) get_image_data() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_range_data() (pyopenxlsx.XLWorksheet method) get_range_values() (pyopenxlsx.XLWorksheet method)

get_row() (pyopenxlsx.Worksheet method) get_row_values() (pyopenxlsx.XLWorksheet method) get_rows_data() (pyopenxlsx.XLWorksheet method) get_runs() (pyopenxlsx.XLRichText method) get_string() (pyopenxlsx.XLCell method) (pyopenxlsx.XLDocument method) get_string_index() (pyopenxlsx.XLDocument method) get_table() (pyopenxlsx.XLTables method) Gradient (pyopenxlsx.XLFillType attribute) grand_totals() (pyopenxlsx.PivotTableBuilder method) Gray0625 (pyopenxlsx.XLPatternType attribute) Gray125 (pyopenxlsx.XLPatternType attribute) GreaterThan (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) GreaterThanOrEqual (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) green() (pyopenxlsx.XLColor method) grid_lines (pyopenxlsx.PrintOptions property) grid_lines() (pyopenxlsx.XLPrintOptions method) group_columns() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) group_rows() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method)

H

Hair (pyopenxlsx.XLLineStyle attribute) HalfAlpha (pyopenxlsx.XLIMEMode attribute) HalfHangul (pyopenxlsx.XLIMEMode attribute) HalfKatakana (pyopenxlsx.XLIMEMode attribute) has_archive_entry() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) has_auto_filter() (pyopenxlsx.XLWorksheet method) has_comments() (pyopenxlsx.XLWorksheet method) has_current_cell (pyopenxlsx.XLEvalSession property) has_drawing (pyopenxlsx.Worksheet property) has_drawing() (pyopenxlsx.XLWorksheet method) has_errors() (pyopenxlsx.XLFormulaDiagnosticReporter method) has_font() (pyopenxlsx.XLDxf method) has_formula() (pyopenxlsx.XLCell method) has_hyperlink() (pyopenxlsx.XLWorksheet method) has_macro (pyopenxlsx.Workbook property) has_macro() (pyopenxlsx.XLDocument method) has_next() (pyopenxlsx.XLStreamReader method) has_panes() (pyopenxlsx.XLWorksheet method) has_persons() (pyopenxlsx.XLDocument method) has_relationships() (pyopenxlsx.XLWorksheet method) has_sheet_comments() (pyopenxlsx.XLDocument method) has_sheet_drawing() (pyopenxlsx.XLDocument method) has_sheet_relationships() (pyopenxlsx.XLDocument method) has_sheet_tables() (pyopenxlsx.XLDocument method) has_sheet_threaded_comments() (pyopenxlsx.XLDocument method) has_sheet_vml_drawing() (pyopenxlsx.XLDocument method) has_tables() (pyopenxlsx.XLWorksheet method) has_threaded_comments() (pyopenxlsx.XLWorksheet method) has_vml_drawing() (pyopenxlsx.XLWorksheet method) header (pyopenxlsx.PageMargins property) header() (pyopenxlsx.XLPageMargins method) header_footer() (pyopenxlsx.XLWorksheet method) headings (pyopenxlsx.PrintOptions property) headings() (pyopenxlsx.XLPrintOptions method)

Heart (pyopenxlsx.XLVectorShapeType attribute) height (pyopenxlsx.XLChartAnchor property) (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLSlicerOptions property) (pyopenxlsx.XLStreamRowOpts property) (pyopenxlsx.XLVectorShapeOptions property) height() (pyopenxlsx.XLDrawingItem method) (pyopenxlsx.XLRow method) (pyopenxlsx.XLShapeStyle method) hex() (pyopenxlsx.XLColor method) Hexagon (pyopenxlsx.XLVectorShapeType attribute) hidden (pyopenxlsx.Column property) Hidden (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLSheetState attribute) hidden (pyopenxlsx.XLStreamRowOpts property) hidden() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLShapeStyle method) hide() (pyopenxlsx.XLShapeStyle method) High (pyopenxlsx.XLAxisTickLabelPosition attribute) high (pyopenxlsx.XLSparklineOptions property) high_marker_color (pyopenxlsx.XLSparklineOptions property) Hiragana (pyopenxlsx.XLIMEMode attribute) hole_size() (pyopenxlsx.Chart method) horizontal (pyopenxlsx.XLStyle.Alignment property) horizontal() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) (pyopenxlsx.XLBorder method) horizontal_centered (pyopenxlsx.PrintOptions property) horizontal_centered() (pyopenxlsx.XLPrintOptions method) horz_align (pyopenxlsx.XLVectorShapeOptions property) Hyperlink (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) HyperlinkBase (pyopenxlsx.XLProperty attribute) HyperlinksChanged (pyopenxlsx.XLProperty attribute)

I

IconSet (pyopenxlsx.XLCfType attribute) id (pyopenxlsx.XLPerson property) (pyopenxlsx.XLThreadedComment property) id() (pyopenxlsx.XLRelationshipItem method) (pyopenxlsx.XLTableColumn method) id_exists() (pyopenxlsx.XLRelationships method) if_() (pyopenxlsx.FormulaEngine method) Image (pyopenxlsx.XLRelationshipType attribute) image() (pyopenxlsx.XLDrawing method) image_binary() (pyopenxlsx.XLDrawingItem method) image_count() (pyopenxlsx.XLDrawing method) ImageInfo (class in pyopenxlsx) images() (pyopenxlsx.XLWorksheet method) ime_mode (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) ime_mode() (pyopenxlsx.XLDataValidation method) increment_sheet_count() (pyopenxlsx.XLAppProperties method) indent (pyopenxlsx.XLStyle.Alignment property) indent() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) index (pyopenxlsx.Worksheet property) index() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) index_of_sheet() (pyopenxlsx.XLWorkbook method) indexed() (pyopenxlsx.XLDataBarColor method) Information (pyopenxlsx.XLDataValidationErrorStyle attribute) insert_col_break() (pyopenxlsx.XLWorksheet method) insert_column() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) insert_columns (pyopenxlsx.XLSheetProtectionOptions property) insert_columns_allowed() (pyopenxlsx.XLWorksheet method) insert_hyperlinks (pyopenxlsx.XLSheetProtectionOptions property) insert_hyperlinks_allowed() (pyopenxlsx.XLWorksheet method) insert_image() (pyopenxlsx.XLWorksheet method) insert_image_bytes() (pyopenxlsx.XLWorksheet method) insert_image_opt() (pyopenxlsx.XLWorksheet method) insert_row() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method)

insert_row_break() (pyopenxlsx.XLWorksheet method) insert_rows (pyopenxlsx.XLSheetProtectionOptions property) insert_rows_allowed() (pyopenxlsx.XLWorksheet method) insert_sheet_name() (pyopenxlsx.XLAppProperties method) intersect() (pyopenxlsx.XLCellRange method) Invalid (pyopenxlsx.XLCfvoType attribute) (pyopenxlsx.XLShapeTextHAlign attribute) (pyopenxlsx.XLShapeTextVAlign attribute) is_active (pyopenxlsx.StreamWriter property) (pyopenxlsx.XLStreamWriter property) is_active() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) is_chartsheet() (pyopenxlsx.XLSheet method) is_collapsed() (pyopenxlsx.XLRow method) is_date (pyopenxlsx.Cell property) is_date_format() (in module pyopenxlsx) is_hidden() (pyopenxlsx.XLColumn method) (pyopenxlsx.XLRow method) is_multi_sheet (pyopenxlsx.XLCalculationEngine property) is_open() (pyopenxlsx.XLDocument method) is_protected() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) is_resolved (pyopenxlsx.XLThreadedComment property) is_selected() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) is_sort_descending (pyopenxlsx.XLSlicer property) is_stream_active() (pyopenxlsx.XLStreamWriter method) is_streamed_sheet() (pyopenxlsx.XLWorksheet method) is_worksheet() (pyopenxlsx.XLSheet method) italic (pyopenxlsx.XLRichTextRun property) (pyopenxlsx.XLStyle.Font property) italic() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) items (pyopenxlsx.XLSlicer property) iter_native_rows() (pyopenxlsx.Worksheet method) iter_rows() (pyopenxlsx.Worksheet method)

J

Justify (pyopenxlsx.XLAlignmentStyle attribute)

K

Keywords (pyopenxlsx.XLProperty attribute)

L

Landscape (pyopenxlsx.XLPageOrientation attribute) last (pyopenxlsx.XLSparklineOptions property) Last7Days (pyopenxlsx.XLCfTimePeriod attribute) last_cell() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) last_error (pyopenxlsx.XLStreamReader property) last_marker_color (pyopenxlsx.XLSparklineOptions property) last_row (pyopenxlsx.StreamWriter property) (pyopenxlsx.XLStreamWriter property) last_status (pyopenxlsx.XLCalculationEngine property) LastModifiedBy (pyopenxlsx.XLProperty attribute) LastMonth (pyopenxlsx.XLCfTimePeriod attribute) LastPrinted (pyopenxlsx.XLProperty attribute) LastWeek (pyopenxlsx.XLCfTimePeriod attribute) left (pyopenxlsx.PageMargins property) Left (pyopenxlsx.XLAlignmentStyle attribute) (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLShapeTextHAlign attribute) left (pyopenxlsx.XLStyle.Border property) left() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) legend() (pyopenxlsx.Chart method) LessThan (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) LessThanOrEqual (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) LgDash (pyopenxlsx.XLLineDashType attribute) LgDashDot (pyopenxlsx.XLLineDashType attribute) LgDashDotDot (pyopenxlsx.XLLineDashType attribute) Light1 (pyopenxlsx.XLSlicerStyle attribute) Light2 (pyopenxlsx.XLSlicerStyle attribute) Light3 (pyopenxlsx.XLSlicerStyle attribute) Light4 (pyopenxlsx.XLSlicerStyle attribute)

Light5 (pyopenxlsx.XLSlicerStyle attribute) Light6 (pyopenxlsx.XLSlicerStyle attribute) LightDown (pyopenxlsx.XLPatternType attribute) LightGray (pyopenxlsx.XLPatternType attribute) LightGrid (pyopenxlsx.XLPatternType attribute) LightHorizontal (pyopenxlsx.XLPatternType attribute) LightningBolt (pyopenxlsx.XLVectorShapeType attribute) LightTrellis (pyopenxlsx.XLPatternType attribute) LightUp (pyopenxlsx.XLPatternType attribute) LightVertical (pyopenxlsx.XLPatternType attribute) Line (pyopenxlsx.XLChartType attribute) (pyopenxlsx.XLSparklineType attribute) (pyopenxlsx.XLVectorShapeType attribute) Line3D (pyopenxlsx.XLChartType attribute) line_color (pyopenxlsx.XLVectorShapeOptions property) line_dash (pyopenxlsx.XLVectorShapeOptions property) line_width (pyopenxlsx.XLVectorShapeOptions property) Linear (pyopenxlsx.XLTrendlineType attribute) LinePercentStacked (pyopenxlsx.XLChartType attribute) LineStacked (pyopenxlsx.XLChartType attribute) link_cell() (in module pyopenxlsx) LinksUpToDate (pyopenxlsx.XLProperty attribute) List (pyopenxlsx.XLDataValidationType attribute) load_workbook() (in module pyopenxlsx) load_workbook_async() (in module pyopenxlsx) local_sheet_id() (pyopenxlsx.XLDefinedName method) locked (pyopenxlsx.XLImageOptions property) locked() (pyopenxlsx.XLCellFormat method) locked_position (pyopenxlsx.XLSlicer property) locked_position() (pyopenxlsx.XLSlicerBuilder method) Logarithmic (pyopenxlsx.XLTrendlineType attribute) Low (pyopenxlsx.XLAxisTickLabelPosition attribute) low (pyopenxlsx.XLSparklineOptions property) low_marker_color (pyopenxlsx.XLSparklineOptions property)

M

macro (pyopenxlsx.XLVectorShapeOptions property) Macrosheet (pyopenxlsx.XLRelationshipType attribute) (pyopenxlsx.XLSheetType attribute) Major (pyopenxlsx.XLFontSchemeStyle attribute) Manager (pyopenxlsx.XLProperty attribute) margin_left() (pyopenxlsx.XLShapeStyle method) margin_top() (pyopenxlsx.XLShapeStyle method) mark_all_dirty() (pyopenxlsx.XLCalculationEngine method) mark_dirty() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) markers (pyopenxlsx.XLSparklineOptions property) markers_color (pyopenxlsx.XLSparklineOptions property) Max (pyopenxlsx.XLAxisCrosses attribute) (pyopenxlsx.XLCfvoType attribute) (pyopenxlsx.XLPivotSubtotal attribute) (pyopenxlsx.XLTotalsRowFunction attribute) max_column (pyopenxlsx.StreamWriter property) (pyopenxlsx.Worksheet property) (pyopenxlsx.XLStreamWriter property) max_depth (pyopenxlsx.XLCalculationOptions property) max_expanded_deps (pyopenxlsx.XLCalculationOptions property) max_priority_value() (pyopenxlsx.XLCfRules method) max_row (pyopenxlsx.Worksheet property) MaxMin (pyopenxlsx.XLAxisOrientation attribute) Medium (pyopenxlsx.XLLineStyle attribute)

MediumDashDot (pyopenxlsx.XLLineStyle attribute) MediumDashDotDot (pyopenxlsx.XLLineStyle attribute) MediumDashed (pyopenxlsx.XLLineStyle attribute) MediumGray (pyopenxlsx.XLPatternType attribute) merge_cells() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) merge_cells_async() (pyopenxlsx.Worksheet method) merge_exists() (pyopenxlsx.XLMergeCells method) merges (pyopenxlsx.Worksheet property) merges() (pyopenxlsx.XLWorksheet method) message (pyopenxlsx.XLFormulaDiagnostic property) Min (pyopenxlsx.XLAxisCrosses attribute) (pyopenxlsx.XLCfvoType attribute) (pyopenxlsx.XLPivotSubtotal attribute) (pyopenxlsx.XLTotalsRowFunction attribute) MinMax (pyopenxlsx.XLAxisOrientation attribute) Minor (pyopenxlsx.XLFontSchemeStyle attribute) Minus (pyopenxlsx.XLErrorBarType attribute) ModificationDate (pyopenxlsx.XLProperty attribute) module pyopenxlsx Moon (pyopenxlsx.XLVectorShapeType attribute) move_to() (pyopenxlsx.XLSlicer method) move_with_cells() (pyopenxlsx.XLShapeClientData method) MovingAverage (pyopenxlsx.XLTrendlineType attribute) mso_wrap_style() (pyopenxlsx.XLShapeStyle method)

N

name (pyopenxlsx.ImageInfo property) (pyopenxlsx.Table property) (pyopenxlsx.Worksheet property) (pyopenxlsx.XLChartAnchor property) (pyopenxlsx.XLPivotField property) (pyopenxlsx.XLPivotTableOptions property) (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLSlicerOptions property) (pyopenxlsx.XLStyle.Font property) (pyopenxlsx.XLVectorShapeOptions property) name() (pyopenxlsx.Font method) (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLDrawingItem method) (pyopenxlsx.XLFont method) (pyopenxlsx.XLPivotTable method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLSlicerBuilder method) (pyopenxlsx.XLTable method) (pyopenxlsx.XLTableColumn method) (pyopenxlsx.XLWorksheet method) negative (pyopenxlsx.XLSparklineOptions property) negative_color (pyopenxlsx.XLSparklineOptions property) next_row() (pyopenxlsx.XLStreamReader method) next_row_detailed() (pyopenxlsx.XLStreamReader method) next_row_strings() (pyopenxlsx.XLStreamReader method) next_table_id() (pyopenxlsx.XLDocument method) NextMonth (pyopenxlsx.XLCfTimePeriod attribute) NextToAxis (pyopenxlsx.XLAxisTickLabelPosition attribute) NextWeek (pyopenxlsx.XLCfTimePeriod attribute)

NoControl (pyopenxlsx.XLIMEMode attribute) None (pyopenxlsx.XLDataValidationType attribute) (pyopenxlsx.XLFontSchemeStyle attribute) (pyopenxlsx.XLLineStyle attribute) (pyopenxlsx.XLMarkerStyle attribute) (pyopenxlsx.XLPatternType attribute) (pyopenxlsx.XLTotalsRowFunction attribute) (pyopenxlsx.XLUnderlineStyle attribute) None_ (pyopenxlsx.XLAxisTickLabelPosition attribute) NotBetween (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) NotContains (pyopenxlsx.XLCfOperator attribute) NotContainsBlanks (pyopenxlsx.XLCfType attribute) NotContainsErrors (pyopenxlsx.XLCfType attribute) NotContainsText (pyopenxlsx.XLCfType attribute) NotEqual (pyopenxlsx.XLCfOperator attribute) (pyopenxlsx.XLDataValidationOperator attribute) notify_changed() (pyopenxlsx.XLCalculationEngine method) num_columns (pyopenxlsx.Range property) num_columns() (pyopenxlsx.XLCellRange method) num_fmt() (pyopenxlsx.XLDxf method) num_fmt_id (pyopenxlsx.XLPivotField property) num_rows (pyopenxlsx.Range property) num_rows() (pyopenxlsx.XLCellRange method) Number (pyopenxlsx.XLCfvoType attribute) number_format (pyopenxlsx.XLStyle property) number_format_by_id() (pyopenxlsx.XLNumberFormats method) number_format_by_index() (pyopenxlsx.XLNumberFormats method) number_format_id() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLNumberFormat method) number_formats() (pyopenxlsx.XLStyles method)

O

object_type() (pyopenxlsx.XLShapeClientData method) objects (pyopenxlsx.XLSheetProtectionOptions property) objects_protected() (pyopenxlsx.XLWorksheet method) odd_footer() (pyopenxlsx.XLHeaderFooter method) odd_header() (pyopenxlsx.XLHeaderFooter method) Off (pyopenxlsx.XLIMEMode attribute) offset (pyopenxlsx.XLFormulaDiagnostic property) offset() (pyopenxlsx.XLCell method) (pyopenxlsx.XLSlicerBuilder method) offset_x (pyopenxlsx.XLImageOptions property) (pyopenxlsx.XLSlicerOptions property) (pyopenxlsx.XLVectorShapeOptions property) offset_y (pyopenxlsx.XLImageOptions property) (pyopenxlsx.XLSlicerOptions property) (pyopenxlsx.XLVectorShapeOptions property) Ok (pyopenxlsx.XLCalcStatus attribute) On (pyopenxlsx.XLIMEMode attribute)

OneCell (pyopenxlsx.XLImagePositioning attribute) open() (pyopenxlsx.XLDocument method) operator (pyopenxlsx.DataValidation property) operator_ (pyopenxlsx.XLDataValidationConfig property) operator_() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLDataValidation method) options (pyopenxlsx.PivotTableBuilder property) (pyopenxlsx.XLStreamReader property) Or (pyopenxlsx.XLFilterLogic attribute) orientation (pyopenxlsx.PageSetup property) orientation() (pyopenxlsx.XLPageSetup method) Other1 (pyopenxlsx.XLSlicerStyle attribute) Other2 (pyopenxlsx.XLSlicerStyle attribute) outline() (pyopenxlsx.XLBorder method) outline_level (pyopenxlsx.XLStreamRowOpts property) outline_level() (pyopenxlsx.XLRow method) overlap() (pyopenxlsx.Chart method)

P

page_margins() (pyopenxlsx.XLWorksheet method) page_order() (pyopenxlsx.XLPageSetup method) page_setup() (pyopenxlsx.XLWorksheet method) PageMargins (class in pyopenxlsx) PageSetup (class in pyopenxlsx) paper_size (pyopenxlsx.PageSetup property) paper_size() (pyopenxlsx.XLPageSetup method) Parallelogram (pyopenxlsx.XLVectorShapeType attribute) parent_id (pyopenxlsx.XLThreadedComment property) parse (pyopenxlsx.XLCellKey attribute) password_hash() (pyopenxlsx.XLWorksheet method) password_is_set() (pyopenxlsx.XLWorksheet method) path (pyopenxlsx.ImageInfo property) path() (pyopenxlsx.XLContentItem method) (pyopenxlsx.XLDocument method) Pattern (pyopenxlsx.XLFillType attribute) pattern (pyopenxlsx.XLStyle.Fill property) pattern_type() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) peek_cell() (pyopenxlsx.XLWorksheet method) Percent (pyopenxlsx.XLCfvoType attribute) percent() (pyopenxlsx.XLCfRule method) Percentage (pyopenxlsx.XLErrorBarValueType attribute) Percentile (pyopenxlsx.XLCfvoType attribute) Person (pyopenxlsx.XLRelationshipType attribute) person() (pyopenxlsx.XLPersons method) person_id (pyopenxlsx.XLThreadedComment property) persons() (pyopenxlsx.XLDocument method) Picture (pyopenxlsx.XLMarkerStyle attribute) Pie (pyopenxlsx.XLChartType attribute) Pie3D (pyopenxlsx.XLChartType attribute) pivot_subtotal() (in module pyopenxlsx) pivot_table() (in module pyopenxlsx) pivot_table_style_name (pyopenxlsx.XLPivotTableOptions property) pivot_tables (pyopenxlsx.XLSheetProtectionOptions property) pivot_tables() (pyopenxlsx.XLWorksheet method) pivot_tables_allowed() (pyopenxlsx.XLWorksheet method) PivotCacheDefinition (pyopenxlsx.XLRelationshipType attribute)

PivotCacheRecords (pyopenxlsx.XLRelationshipType attribute) PivotTable (pyopenxlsx.XLRelationshipType attribute) PivotTableBuilder (class in pyopenxlsx) plain_text (pyopenxlsx.XLRichText property) Plus (pyopenxlsx.XLErrorBarType attribute) (pyopenxlsx.XLMarkerStyle attribute) Polynomial (pyopenxlsx.XLTrendlineType attribute) Portrait (pyopenxlsx.XLPageOrientation attribute) position() (pyopenxlsx.XLShapeStyle method) positioning (pyopenxlsx.XLImageOptions property) Power (pyopenxlsx.XLTrendlineType attribute) prepend_sheet_name() (pyopenxlsx.XLAppProperties method) print_options() (pyopenxlsx.XLWorksheet method) print_with_sheet (pyopenxlsx.XLImageOptions property) PrinterSettings (pyopenxlsx.XLRelationshipType attribute) PrintOptions (class in pyopenxlsx) priority() (pyopenxlsx.XLCfRule method) Product (pyopenxlsx.XLPivotSubtotal attribute) prompt (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) prompt() (pyopenxlsx.XLDataValidation method) prompt_title (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) prompt_title() (pyopenxlsx.XLDataValidation method) propagate_dirty (pyopenxlsx.XLCalculationOptions property) properties (pyopenxlsx.Workbook property) property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method) protect() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) (pyopenxlsx.XLWorksheet method) protect_objects() (pyopenxlsx.XLWorksheet method) protect_scenarios() (pyopenxlsx.XLWorksheet method) protect_sheet() (pyopenxlsx.XLWorksheet method) Protection (class in pyopenxlsx) pyopenxlsx module PythonMergeCells (in module pyopenxlsx)

Q

qualified_address() (pyopenxlsx.XLCellKey method)

R

Radar (pyopenxlsx.XLChartType attribute) RadarFilled (pyopenxlsx.XLChartType attribute) RadarMarkers (pyopenxlsx.XLChartType attribute) Range (class in pyopenxlsx) range (pyopenxlsx.Table property) range() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) range_reference() (pyopenxlsx.XLTable method) range_used() (pyopenxlsx.XLWorksheet method) rank() (pyopenxlsx.XLCfRule method) raw (pyopenxlsx.CalculationEngine property) (pyopenxlsx.Chart property) (pyopenxlsx.DefinedName property) (pyopenxlsx.DefinedNames property) (pyopenxlsx.FormulaEngine property) raw() (pyopenxlsx.XLShapeStyle method) rebuild() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) recalculate() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) recalculate_all() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) recalculate_inputs() (pyopenxlsx.CalculationEngine method) Rectangle (pyopenxlsx.XLVectorShapeType attribute) red() (pyopenxlsx.XLColor method) ref (pyopenxlsx.XLThreadedComment property) ref() (pyopenxlsx.XLAutoFilter method) (pyopenxlsx.XLComment method) refers_to() (pyopenxlsx.XLDefinedName method) relationship_by_id() (pyopenxlsx.XLRelationships method) relationship_by_target() (pyopenxlsx.XLRelationships method) relationship_id() (pyopenxlsx.XLDrawingItem method) Relationships (pyopenxlsx.XLContentType attribute) relationships() (pyopenxlsx.XLRelationships method) reload_defined_names() (pyopenxlsx.XLCalculationEngine method) remove() (pyopenxlsx.DataValidations method) (pyopenxlsx.DefinedNames method) (pyopenxlsx.Workbook method) (pyopenxlsx.XLDataValidations method) (pyopenxlsx.XLDefinedNames method) (pyopenxlsx.XLSlicerCollection method)

remove_async() (pyopenxlsx.Workbook method) remove_cell() (pyopenxlsx.XLDataValidation method) remove_col_break() (pyopenxlsx.XLWorksheet method) remove_conditional_formatting() (pyopenxlsx.XLWorksheet method) remove_hyperlink() (pyopenxlsx.XLWorksheet method) remove_range() (pyopenxlsx.XLDataValidation method) remove_row_break() (pyopenxlsx.XLWorksheet method) renumber_priorities() (pyopenxlsx.XLCfRules method) replies() (pyopenxlsx.XLThreadedComments method) report_error() (pyopenxlsx.XLFormulaDiagnosticReporter method) resize() (pyopenxlsx.XLSlicer method) rgb() (pyopenxlsx.XLDataBarColor method) Ribbon (pyopenxlsx.XLVectorShapeType attribute) rich_text (pyopenxlsx.XLVectorShapeOptions property) right (pyopenxlsx.PageMargins property) Right (pyopenxlsx.XLAlignmentStyle attribute) (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLShapeTextHAlign attribute) right (pyopenxlsx.XLStyle.Border property) right() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) RightTriangle (pyopenxlsx.XLVectorShapeType attribute) rotation (pyopenxlsx.XLVectorShapeOptions property) rotation() (pyopenxlsx.Chart method) (pyopenxlsx.XLAlignment method) row (pyopenxlsx.XLCellKey property) (pyopenxlsx.XLChartAnchor property) row() (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLDrawingItem method) (pyopenxlsx.XLShapeClientData method) (pyopenxlsx.XLWorksheet method) row_count() (pyopenxlsx.XLRowRange method) (pyopenxlsx.XLWorksheet method) row_format() (pyopenxlsx.XLWorksheet method) row_number() (pyopenxlsx.XLRow method) rows (pyopenxlsx.Worksheet property) (pyopenxlsx.XLPivotTableOptions property) rows() (pyopenxlsx.PivotTableBuilder method) (pyopenxlsx.XLWorksheet method) runs (pyopenxlsx.XLRichText property)

S

save() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) save_as() (pyopenxlsx.XLDocument method) save_async() (pyopenxlsx.Workbook method) scale (pyopenxlsx.PageSetup property) scale() (pyopenxlsx.XLPageSetup method) scale_with_doc() (pyopenxlsx.XLHeaderFooter method) scale_x (pyopenxlsx.XLImageOptions property) scale_y (pyopenxlsx.XLImageOptions property) ScaleCrop (pyopenxlsx.XLProperty attribute) Scatter (pyopenxlsx.XLChartType attribute) ScatterLine (pyopenxlsx.XLChartType attribute) ScatterLineMarker (pyopenxlsx.XLChartType attribute) ScatterMarker (pyopenxlsx.XLChartType attribute) ScatterSmooth (pyopenxlsx.XLChartType attribute) ScatterSmoothMarker (pyopenxlsx.XLChartType attribute) scenarios (pyopenxlsx.XLSheetProtectionOptions property) scenarios_protected() (pyopenxlsx.XLWorksheet method) scheme() (pyopenxlsx.XLFont method) select_locked_cells (pyopenxlsx.XLSheetProtectionOptions property) select_locked_cells_allowed() (pyopenxlsx.XLWorksheet method) select_unlocked_cells (pyopenxlsx.XLSheetProtectionOptions property) select_unlocked_cells_allowed() (pyopenxlsx.XLWorksheet method) selected_items (pyopenxlsx.XLSlicer property) serial() (pyopenxlsx.XLDateTime method) series() (pyopenxlsx.Chart method) series_color (pyopenxlsx.XLSparklineOptions property) series_many() (pyopenxlsx.Chart method) set() (pyopenxlsx.XLColor method) (pyopenxlsx.XLComments method) (pyopenxlsx.XLDataBarColor method) set_above_average() (pyopenxlsx.XLCfRule method) set_active() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) set_address() (pyopenxlsx.XLCellReference method) set_align_with_margins() (pyopenxlsx.XLHeaderFooter method) set_allow_blank() (pyopenxlsx.XLDataValidation method) set_allow_in_cell() (pyopenxlsx.XLShape method) set_anchor() (pyopenxlsx.XLShapeClientData method) set_apply_alignment() (pyopenxlsx.XLCellFormat method) set_apply_border() (pyopenxlsx.XLCellFormat method) set_apply_fill() (pyopenxlsx.XLCellFormat method) set_apply_font() (pyopenxlsx.XLCellFormat method) set_apply_number_format() (pyopenxlsx.XLCellFormat method) set_apply_protection() (pyopenxlsx.XLCellFormat method) set_author_id() (pyopenxlsx.XLComment method) set_auto_fill() (pyopenxlsx.XLShapeClientData method) set_auto_filter() (pyopenxlsx.XLWorksheet method) set_auto_filter_allowed() (pyopenxlsx.XLWorksheet method) set_automatic() (pyopenxlsx.XLDataBarColor method) set_background_color() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) set_black_and_white() (pyopenxlsx.XLPageSetup method) set_bold() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_border_index() (pyopenxlsx.XLCellFormat method) set_border_outline() (pyopenxlsx.XLCellRange method) set_bottom() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLPageMargins method) set_calculated_column_formula() (pyopenxlsx.XLTableColumn method) set_caption() (pyopenxlsx.XLSlicer method) set_cell_format() (pyopenxlsx.XLCell method) set_cell_value() (pyopenxlsx.XLWorksheet method) set_cells_batch() (pyopenxlsx.XLWorksheet method) set_chart_area_color() (pyopenxlsx.XLChart method) set_col_grand_totals() (pyopenxlsx.XLPivotTableOptions method) set_collapsed() (pyopenxlsx.XLRow method) set_color() (pyopenxlsx.Fill method) (pyopenxlsx.Font method) (pyopenxlsx.XLChartSeries method) (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLFill method) (pyopenxlsx.XLFont method) (pyopenxlsx.XLSheet method) set_column() (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLShapeClientData method) set_column_format() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) set_comment() (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLTable method) set_compact_data() (pyopenxlsx.XLPivotTableOptions method) set_compression_level() (pyopenxlsx.XLDocument method) set_crosses() (pyopenxlsx.XLAxis method) set_crosses_at() (pyopenxlsx.XLAxis method) set_current_cell() (pyopenxlsx.XLEvalSession method) set_current_sheet() (pyopenxlsx.XLEvalSession method) set_custom_filter() (pyopenxlsx.XLFilterColumn method) set_custom_property() (pyopenxlsx.XLDocument method) set_data_labels() (pyopenxlsx.XLChartSeries method) set_data_labels_from_range() (pyopenxlsx.XLChartSeries method) set_data_on_rows() (pyopenxlsx.XLPivotTableOptions method) set_data_point_color() (pyopenxlsx.XLChartSeries method) set_date_axis() (pyopenxlsx.XLAxis method) set_date_range() (pyopenxlsx.XLDataValidation method) set_decimal_range() (pyopenxlsx.XLDataValidation method) set_default_author() (pyopenxlsx.XLDocument method) set_delete_columns_allowed() (pyopenxlsx.XLWorksheet method) set_delete_rows_allowed() (pyopenxlsx.XLWorksheet method) set_descent() (pyopenxlsx.XLRow method) set_diagonal() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_diagonal_down() (pyopenxlsx.XLBorder method) set_diagonal_up() (pyopenxlsx.XLBorder method) set_different_first() (pyopenxlsx.XLHeaderFooter method) set_different_odd_even() (pyopenxlsx.XLHeaderFooter method) set_disable_prompts() (pyopenxlsx.XLDataValidations method) set_display_name() (pyopenxlsx.XLTable method) set_dxf_id() (pyopenxlsx.XLCfRule method) set_equal_average() (pyopenxlsx.XLCfRule method) set_error() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) set_even_footer() (pyopenxlsx.XLHeaderFooter method) set_even_header() (pyopenxlsx.XLHeaderFooter method) set_fill_color() (pyopenxlsx.XLShape method) set_fill_index() (pyopenxlsx.XLCellFormat method) set_fill_type() (pyopenxlsx.XLFill method) set_first_footer() (pyopenxlsx.XLHeaderFooter method) set_first_header() (pyopenxlsx.XLHeaderFooter method) set_first_page_number() (pyopenxlsx.XLPageSetup method) set_fit_to_height() (pyopenxlsx.XLPageSetup method) set_fit_to_width() (pyopenxlsx.XLPageSetup method) set_font_index() (pyopenxlsx.XLCellFormat method) set_footer() (pyopenxlsx.XLPageMargins method) set_format() (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLColumn method) (pyopenxlsx.XLRow method) set_format_cells_allowed() (pyopenxlsx.XLWorksheet method) set_format_code() (pyopenxlsx.XLNumberFormat method) set_format_columns_allowed() (pyopenxlsx.XLWorksheet method) set_format_rows_allowed() (pyopenxlsx.XLWorksheet method) set_formula() (pyopenxlsx.XLCell method) (pyopenxlsx.XLCfRule method) set_formula1() (pyopenxlsx.XLDataValidation method) set_formula2() (pyopenxlsx.XLDataValidation method) set_formula_needs_recalculation() (pyopenxlsx.XLDocument method) set_full_calc_on_load (pyopenxlsx.XLCalculationOptions property) set_full_calculation_on_load() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) set_gap_width() (pyopenxlsx.XLChart method) set_grid_lines() (pyopenxlsx.XLPrintOptions method) set_header() (pyopenxlsx.XLPageMargins method) set_heading_pair() (pyopenxlsx.XLAppProperties method) set_headings() (pyopenxlsx.XLPrintOptions method) set_height() (pyopenxlsx.XLRow method) (pyopenxlsx.XLShapeStyle method) set_hidden() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLColumn method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLRow method) set_hole_size() (pyopenxlsx.XLChart method) set_horizontal() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) (pyopenxlsx.XLBorder method) set_horizontal_centered() (pyopenxlsx.XLPrintOptions method) set_ime_mode() (pyopenxlsx.XLDataValidation method) set_indent() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) set_index() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) set_indexed() (pyopenxlsx.XLDataBarColor method) set_input_value() (pyopenxlsx.CalculationEngine method) (pyopenxlsx.XLCalculationEngine method) set_insert_columns_allowed() (pyopenxlsx.XLWorksheet method) set_insert_hyperlinks_allowed() (pyopenxlsx.XLWorksheet method) set_insert_rows_allowed() (pyopenxlsx.XLWorksheet method) set_italic() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_left() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) set_legend_position() (pyopenxlsx.XLChart method) set_line_dash() (pyopenxlsx.XLChartSeries method) set_line_width() (pyopenxlsx.XLChartSeries method) set_list() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) set_local_sheet_id() (pyopenxlsx.XLDefinedName method) set_locked() (pyopenxlsx.XLCellFormat method) set_log_scale() (pyopenxlsx.XLAxis method) set_major_gridlines() (pyopenxlsx.XLAxis method) set_major_unit() (pyopenxlsx.XLAxis method) set_margin_left() (pyopenxlsx.XLShapeStyle method) set_margin_top() (pyopenxlsx.XLShapeStyle method) set_marker_style() (pyopenxlsx.XLChartSeries method) set_max_bounds() (pyopenxlsx.XLAxis method) set_merge_item() (pyopenxlsx.XLPivotTableOptions method) set_min_bounds() (pyopenxlsx.XLAxis method) set_minor_gridlines() (pyopenxlsx.XLAxis method) set_minor_unit() (pyopenxlsx.XLAxis method) set_move_with_cells() (pyopenxlsx.XLShapeClientData method) set_mso_wrap_style() (pyopenxlsx.XLShapeStyle method) set_name() (pyopenxlsx.Font method) (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLFont method) (pyopenxlsx.XLPivotTable method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLTable method) (pyopenxlsx.XLTableColumn method) (pyopenxlsx.XLWorksheet method) set_name_resolver() (pyopenxlsx.XLEvalSession method) set_number_format() (pyopenxlsx.XLAxis method) set_number_format_id() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLNumberFormat method) set_object_type() (pyopenxlsx.XLShapeClientData method) set_odd_footer() (pyopenxlsx.XLHeaderFooter method) set_odd_header() (pyopenxlsx.XLHeaderFooter method) set_operator() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLDataValidation method) set_orientation() (pyopenxlsx.XLAxis method) (pyopenxlsx.XLPageSetup method) set_outline() (pyopenxlsx.XLBorder method) set_outline_level() (pyopenxlsx.XLRow method) set_overlap() (pyopenxlsx.XLChart method) set_page_order() (pyopenxlsx.XLPageSetup method) set_page_over_then_down() (pyopenxlsx.XLPivotTableOptions method) set_paper_size() (pyopenxlsx.XLPageSetup method) set_password() (pyopenxlsx.XLWorksheet method) set_pattern_type() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) set_percent() (pyopenxlsx.XLCfRule method) set_pivot_table_style() (pyopenxlsx.XLPivotTableOptions method) set_pivot_tables_allowed() (pyopenxlsx.XLWorksheet method) set_plot_area_color() (pyopenxlsx.XLChart method) set_position() (pyopenxlsx.XLShapeStyle method) set_print_area() (pyopenxlsx.XLWorksheet method) set_print_title_cols() (pyopenxlsx.XLWorksheet method) set_print_title_rows() (pyopenxlsx.XLWorksheet method) set_priority() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLCfRules method) set_prompt() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) set_property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method) set_range_reference() (pyopenxlsx.XLTable method) set_rank() (pyopenxlsx.XLCfRule method) set_raw() (pyopenxlsx.XLShapeStyle method) set_ref() (pyopenxlsx.XLAutoFilter method) set_ref_range() (pyopenxlsx.XLAutoFilter method) set_reference_drop_list() (pyopenxlsx.DataValidation method) (pyopenxlsx.XLDataValidation method) set_refers_to() (pyopenxlsx.XLDefinedName method) set_rgb() (pyopenxlsx.XLDataBarColor method) set_right() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) set_rotation() (pyopenxlsx.XLAlignment method) (pyopenxlsx.XLChart method) set_row() (pyopenxlsx.StreamWriter method) (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLShapeClientData method) (pyopenxlsx.XLStreamWriter method) set_row_and_column() (pyopenxlsx.XLCellReference method) set_row_format() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method)

set_row_grand_totals() (pyopenxlsx.XLPivotTableOptions method) set_row_ref() (pyopenxlsx.StreamWriter method) (pyopenxlsx.XLStreamWriter method) set_scale() (pyopenxlsx.XLPageSetup method) set_scale_with_doc() (pyopenxlsx.XLHeaderFooter method) set_scheme() (pyopenxlsx.XLFont method) set_select_locked_cells_allowed() (pyopenxlsx.XLWorksheet method) set_select_unlocked_cells_allowed() (pyopenxlsx.XLWorksheet method) set_selected() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) set_series_marker() (pyopenxlsx.XLChart method) set_series_smooth() (pyopenxlsx.XLChart method) set_sheet_index() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) set_sheet_name() (pyopenxlsx.XLAppProperties method) set_sheet_view_mode() (pyopenxlsx.XLWorksheet method) set_show_col_headers() (pyopenxlsx.XLPivotTableOptions method) set_show_col_stripes() (pyopenxlsx.XLPivotTableOptions method) set_show_column_stripes() (pyopenxlsx.XLTable method) set_show_data_labels() (pyopenxlsx.XLChart method) set_show_data_table() (pyopenxlsx.XLChart method) set_show_drill() (pyopenxlsx.XLPivotTableOptions method) set_show_drop_down() (pyopenxlsx.XLDataValidation method) set_show_error() (pyopenxlsx.XLPivotTableOptions method) set_show_error_message() (pyopenxlsx.XLDataValidation method) set_show_first_column() (pyopenxlsx.XLTable method) set_show_grid_lines() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) set_show_header_row() (pyopenxlsx.XLTable method) set_show_input_message() (pyopenxlsx.XLDataValidation method) set_show_last_column() (pyopenxlsx.XLPivotTableOptions method) (pyopenxlsx.XLTable method) set_show_row_col_headers() (pyopenxlsx.XLWorksheet method) set_show_row_headers() (pyopenxlsx.XLPivotTableOptions method) set_show_row_stripes() (pyopenxlsx.XLPivotTableOptions method) (pyopenxlsx.XLTable method) set_show_totals_row() (pyopenxlsx.XLTable method) set_shrink_to_fit() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) set_size() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_size_with_cells() (pyopenxlsx.XLShapeClientData method) set_smooth() (pyopenxlsx.XLChartSeries method) set_sort_allowed() (pyopenxlsx.XLWorksheet method) set_sqref() (pyopenxlsx.XLConditionalFormat method) (pyopenxlsx.XLDataValidation method) set_std_dev() (pyopenxlsx.XLCfRule method) set_stop_if_true() (pyopenxlsx.XLCfRule method) set_strikethrough() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_stroked() (pyopenxlsx.XLShape method) set_style() (pyopenxlsx.XLCell method) (pyopenxlsx.XLChart method) (pyopenxlsx.XLShape method) (pyopenxlsx.XLSlicer method) set_style_name() (pyopenxlsx.XLTable method) set_style_obj() (pyopenxlsx.XLShape method) set_style_raw() (pyopenxlsx.XLSlicer method) set_text() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLComment method) set_text_h_align() (pyopenxlsx.XLShapeClientData method) set_text_length_range() (pyopenxlsx.XLDataValidation method) set_text_rotation() (pyopenxlsx.Alignment method) set_text_v_align() (pyopenxlsx.XLShapeClientData method) set_theme() (pyopenxlsx.XLDataBarColor method) set_tick_label_position() (pyopenxlsx.XLAxis method) set_time_period() (pyopenxlsx.XLCfRule method) set_time_range() (pyopenxlsx.XLDataValidation method) set_tint() (pyopenxlsx.XLDataBarColor method) set_title() (pyopenxlsx.XLAxis method) (pyopenxlsx.XLChart method) (pyopenxlsx.XLChartSeries method) set_top() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) set_top10() (pyopenxlsx.XLFilterColumn method) set_totals_row_formula() (pyopenxlsx.XLTableColumn method) set_totals_row_function() (pyopenxlsx.XLTableColumn method) set_totals_row_label() (pyopenxlsx.XLTableColumn method) set_type() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLDataValidation method) (pyopenxlsx.XLShape method) set_underline() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_use_auto_formatting() (pyopenxlsx.XLPivotTableOptions method) set_use_first_page_number() (pyopenxlsx.XLPageSetup method) set_v_text_anchor() (pyopenxlsx.XLShapeStyle method) set_values() (pyopenxlsx.XLRow method) set_vert_align() (pyopenxlsx.XLFont method) set_vertical() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) (pyopenxlsx.XLBorder method) set_vertical_centered() (pyopenxlsx.XLPrintOptions method) set_visibility() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) set_whole_number_range() (pyopenxlsx.XLDataValidation method) set_width() (pyopenxlsx.XLColumn method) (pyopenxlsx.XLShapeStyle method) set_wrap_text() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) set_x_window() (pyopenxlsx.XLDataValidations method) set_y_window() (pyopenxlsx.XLDataValidations method) set_zoom() (pyopenxlsx.XLWorksheet method) shape() (pyopenxlsx.XLComments method) (pyopenxlsx.XLVmlDrawing method) shape_count() (pyopenxlsx.XLVmlDrawing method) shape_id() (pyopenxlsx.XLShape method) SharedDoc (pyopenxlsx.XLProperty attribute) SharedStrings (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) sheet (pyopenxlsx.XLCellKey property) (pyopenxlsx.XLSheetProtectionOptions property) sheet() (pyopenxlsx.XLWorkbook method) sheet_comments() (pyopenxlsx.XLDocument method) sheet_count() (pyopenxlsx.XLWorkbook method) sheet_drawing() (pyopenxlsx.XLDocument method) sheet_exists() (pyopenxlsx.XLWorkbook method) sheet_names() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) sheet_protected() (pyopenxlsx.XLWorksheet method) sheet_protection_summary() (pyopenxlsx.XLWorksheet method) sheet_relationships() (pyopenxlsx.XLDocument method) sheet_state (pyopenxlsx.Worksheet property) sheet_tables() (pyopenxlsx.XLDocument method) sheet_threaded_comments() (pyopenxlsx.XLDocument method) sheet_view_mode() (pyopenxlsx.XLWorksheet method) sheet_vml_drawing() (pyopenxlsx.XLDocument method) sheetnames (pyopenxlsx.Workbook property) show() (pyopenxlsx.XLShapeStyle method) show_all() (pyopenxlsx.XLSlicer method) show_caption (pyopenxlsx.XLSlicer property) show_column_stripes (pyopenxlsx.Table property) show_column_stripes() (pyopenxlsx.XLTable method) show_drop_down (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) show_drop_down() (pyopenxlsx.XLDataValidation method) show_error_message (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) show_error_message() (pyopenxlsx.XLDataValidation method) show_first_column (pyopenxlsx.Table property) show_first_column() (pyopenxlsx.XLTable method) show_grid_lines() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) show_header_row() (pyopenxlsx.XLTable method) show_headers() (pyopenxlsx.PivotTableBuilder method) show_input_message (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) show_input_message() (pyopenxlsx.XLDataValidation method) show_last_column (pyopenxlsx.Table property) show_last_column() (pyopenxlsx.XLTable method) show_only() (pyopenxlsx.XLSlicer method) (pyopenxlsx.XLSlicerBuilder method) show_row_col_headers() (pyopenxlsx.XLWorksheet method) show_row_stripes (pyopenxlsx.Table property) show_row_stripes() (pyopenxlsx.XLTable method) show_totals_row (pyopenxlsx.Table property) show_totals_row() (pyopenxlsx.XLTable method) shrink_to_fit() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) Side (class in pyopenxlsx) Single (pyopenxlsx.XLUnderlineStyle attribute) size (pyopenxlsx.XLStyle.Font property) size() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) (pyopenxlsx.XLSlicerBuilder method) size_with_cells() (pyopenxlsx.XLShapeClientData method) SkipMissingRows (pyopenxlsx.XLStreamEmptyRowPolicy attribute) SlantDashDot (pyopenxlsx.XLLineStyle attribute) Slicer (pyopenxlsx.XLRelationshipType attribute) SlicerCache (pyopenxlsx.XLRelationshipType attribute) slicers() (pyopenxlsx.XLWorksheet method) SmileyFace (pyopenxlsx.XLVectorShapeType attribute) Solid (pyopenxlsx.XLLineDashType attribute) (pyopenxlsx.XLPatternType attribute) sort (pyopenxlsx.XLSheetProtectionOptions property) sort_allowed() (pyopenxlsx.XLWorksheet method) sort_descending() (pyopenxlsx.XLSlicerBuilder method) source_range (pyopenxlsx.XLPivotTableOptions property) source_range() (pyopenxlsx.XLPivotTable method) Split (pyopenxlsx.XLPaneState attribute) split_panes() (pyopenxlsx.XLWorksheet method) sqref (pyopenxlsx.DataValidation property) sqref() (pyopenxlsx.XLConditionalFormat method) (pyopenxlsx.XLDataValidation method) Square (pyopenxlsx.XLMarkerStyle attribute) Stacked (pyopenxlsx.XLSparklineType attribute) StandardDeviation (pyopenxlsx.XLErrorBarValueType attribute) StandardError (pyopenxlsx.XLErrorBarValueType attribute) Star (pyopenxlsx.XLMarkerStyle attribute) Star16 (pyopenxlsx.XLVectorShapeType attribute) Star24 (pyopenxlsx.XLVectorShapeType attribute) Star4 (pyopenxlsx.XLVectorShapeType attribute) Star5 (pyopenxlsx.XLVectorShapeType attribute) std_dev() (pyopenxlsx.XLCfRule method) StdDev (pyopenxlsx.XLTotalsRowFunction attribute) StockHLC (pyopenxlsx.XLChartType attribute) StockOHLC (pyopenxlsx.XLChartType attribute) Stop (pyopenxlsx.XLDataValidationErrorStyle attribute) stop_if_true() (pyopenxlsx.XLCfRule method) stream_reader() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) stream_writer() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) StreamReader (class in pyopenxlsx) StreamWriter (class in pyopenxlsx) strikethrough (pyopenxlsx.XLRichTextRun property) (pyopenxlsx.XLStyle.Font property) strikethrough() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) string_count() (pyopenxlsx.XLDocument method) string_exists() (pyopenxlsx.XLDocument method) stripes() (pyopenxlsx.PivotTableBuilder method) stroked() (pyopenxlsx.XLShape method) Style (class in pyopenxlsx) style (pyopenxlsx.Cell property) (pyopenxlsx.Table property) (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLStyle.BorderElement property) style() (pyopenxlsx.Chart method) (pyopenxlsx.PivotTableBuilder method) (pyopenxlsx.Side method) (pyopenxlsx.XLLine method) (pyopenxlsx.XLShape method) (pyopenxlsx.XLSlicerBuilder method) style_index (pyopenxlsx.Cell property) (pyopenxlsx.Column property) (pyopenxlsx.XLStreamRowOpts property) style_name() (pyopenxlsx.XLTable method) style_raw (pyopenxlsx.XLSlicer property) style_raw() (pyopenxlsx.XLSlicerBuilder method) styles (pyopenxlsx.Workbook property) Styles (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) styles() (pyopenxlsx.XLDocument method) Subject (pyopenxlsx.XLProperty attribute) Subscript (pyopenxlsx.XLVerticalAlignRunStyle attribute) subtotal (pyopenxlsx.XLPivotField property) Sum (pyopenxlsx.XLPivotSubtotal attribute) (pyopenxlsx.XLTotalsRowFunction attribute) sum() (pyopenxlsx.FormulaEngine method) summary() (pyopenxlsx.XLBorder method) (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLCfRules method) (pyopenxlsx.XLConditionalFormat method) (pyopenxlsx.XLDataBarColor method) (pyopenxlsx.XLDxf method) (pyopenxlsx.XLLine method) Sun (pyopenxlsx.XLVectorShapeType attribute) Superscript (pyopenxlsx.XLVerticalAlignRunStyle attribute) Surface (pyopenxlsx.XLChartType attribute) Surface3D (pyopenxlsx.XLChartType attribute) Surface3DWireframe (pyopenxlsx.XLChartType attribute) SurfaceWireframe (pyopenxlsx.XLChartType attribute) SysDash (pyopenxlsx.XLLineDashType attribute) SysDashDot (pyopenxlsx.XLLineDashType attribute) SysDot (pyopenxlsx.XLLineDashType attribute)

T

Table (class in pyopenxlsx) (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) tables() (pyopenxlsx.XLWorksheet method) target() (pyopenxlsx.XLRelationshipItem method) target_cell (pyopenxlsx.XLPivotTableOptions property) target_cell() (pyopenxlsx.XLPivotTable method) target_exists() (pyopenxlsx.XLRelationships method) text (pyopenxlsx.Formula property) (pyopenxlsx.XLRichTextRun property) (pyopenxlsx.XLThreadedComment property) (pyopenxlsx.XLVectorShapeOptions property) text() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLComment method) text_h_align() (pyopenxlsx.XLShapeClientData method) text_rotation (pyopenxlsx.XLStyle.Alignment property) text_rotation() (pyopenxlsx.Alignment method) text_v_align() (pyopenxlsx.XLShapeClientData method) TextLength (pyopenxlsx.XLDataValidationType attribute) Theme (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) theme() (pyopenxlsx.XLDataBarColor method) Thick (pyopenxlsx.XLLineStyle attribute) Thin (pyopenxlsx.XLLineStyle attribute) ThisMonth (pyopenxlsx.XLCfTimePeriod attribute) ThisWeek (pyopenxlsx.XLCfTimePeriod attribute) threaded_comments() (pyopenxlsx.XLWorksheet method) ThreadedComments (pyopenxlsx.XLRelationshipType attribute) Time (pyopenxlsx.XLDataValidationType attribute) time_period() (pyopenxlsx.XLCfRule method) TimePeriod (pyopenxlsx.XLCfType attribute) tint() (pyopenxlsx.XLDataBarColor method) title (pyopenxlsx.Worksheet property)

Title (pyopenxlsx.XLProperty attribute) title() (pyopenxlsx.Chart method) Today (pyopenxlsx.XLCfTimePeriod attribute) Tomorrow (pyopenxlsx.XLCfTimePeriod attribute) top (pyopenxlsx.PageMargins property) Top (pyopenxlsx.XLAlignmentStyle attribute) (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLShapeTextVAlign attribute) top (pyopenxlsx.XLStyle.Border property) top() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) (pyopenxlsx.XLPageMargins method) Top10 (pyopenxlsx.XLCfType attribute) top_left() (pyopenxlsx.XLCellRange method) TopLeft (pyopenxlsx.XLPane attribute) TopRight (pyopenxlsx.XLLegendPosition attribute) (pyopenxlsx.XLPane attribute) totals_row_formula() (pyopenxlsx.XLTableColumn method) totals_row_function() (pyopenxlsx.XLTableColumn method) totals_row_label() (pyopenxlsx.XLTableColumn method) Triangle (pyopenxlsx.XLMarkerStyle attribute) (pyopenxlsx.XLVectorShapeType attribute) TwoCell (pyopenxlsx.XLImagePositioning attribute) type (pyopenxlsx.DataValidation property) (pyopenxlsx.XLDataValidationConfig property) (pyopenxlsx.XLSparklineOptions property) (pyopenxlsx.XLVectorShapeOptions property) type() (pyopenxlsx.XLCfRule method) (pyopenxlsx.XLContentItem method) (pyopenxlsx.XLDataValidation method) (pyopenxlsx.XLRelationshipItem method) (pyopenxlsx.XLShape method) type_of_sheet() (pyopenxlsx.XLWorkbook method)

U

underline (pyopenxlsx.XLRichTextRun property) (pyopenxlsx.XLStyle.Font property) underline() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) UniqueValues (pyopenxlsx.XLCfType attribute) Unknown (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) unmerge_cells() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLWorksheet method) unmerge_cells_async() (pyopenxlsx.Worksheet method)

unprotect() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) Unset (pyopenxlsx.XLLineDashType attribute) update_dimension() (pyopenxlsx.XLWorksheet method) update_formula_cell() (pyopenxlsx.XLCalculationEngine method) update_sheet_name() (pyopenxlsx.XLWorksheet method) update_sheet_references() (pyopenxlsx.XLWorkbook method) update_worksheet_dimensions() (pyopenxlsx.XLWorkbook method) use_defined_names (pyopenxlsx.XLCalculationOptions property) use_first_page_number() (pyopenxlsx.XLPageSetup method)

V

v_text_anchor() (pyopenxlsx.XLShapeStyle method) valid (pyopenxlsx.XLPerson property) (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLSlicerCollection property) (pyopenxlsx.XLThreadedComment property) valid() (pyopenxlsx.XLCellKey method) (pyopenxlsx.XLComment method) (pyopenxlsx.XLDefinedName method) validate_package_invariants() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) validate_sheet_name() (pyopenxlsx.XLDocument method) value (pyopenxlsx.Cell property) (pyopenxlsx.XLCell property) values() (pyopenxlsx.XLRow method) Var (pyopenxlsx.XLTotalsRowFunction attribute) VBAProject (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute)

vert_align (pyopenxlsx.XLVectorShapeOptions property) vert_align() (pyopenxlsx.XLFont method) vertical (pyopenxlsx.XLStyle.Alignment property) vertical() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) (pyopenxlsx.XLBorder method) vertical_centered (pyopenxlsx.PrintOptions property) vertical_centered() (pyopenxlsx.XLPrintOptions method) VeryHidden (pyopenxlsx.XLSheetState attribute) visibility() (pyopenxlsx.XLChartsheet method) (pyopenxlsx.XLSheet method) (pyopenxlsx.XLWorksheet method) Visible (pyopenxlsx.XLSheetState attribute) visible() (pyopenxlsx.XLShapeStyle method) vml_drawing() (pyopenxlsx.XLWorksheet method) VMLDrawing (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute)

W

Warning (pyopenxlsx.XLDataValidationErrorStyle attribute) Whole (pyopenxlsx.XLDataValidationType attribute) width (pyopenxlsx.Column property) (pyopenxlsx.XLChartAnchor property) (pyopenxlsx.XLSlicer property) (pyopenxlsx.XLSlicerOptions property) (pyopenxlsx.XLVectorShapeOptions property) width() (pyopenxlsx.XLColumn method) (pyopenxlsx.XLDrawingItem method) (pyopenxlsx.XLShapeStyle method) Workbook (class in pyopenxlsx) workbook (pyopenxlsx.Workbook property) Workbook (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) workbook() (pyopenxlsx.XLDocument method) WorkbookMacroEnabled (pyopenxlsx.XLContentType attribute)

Worksheet (class in pyopenxlsx) (pyopenxlsx.XLContentType attribute) (pyopenxlsx.XLRelationshipType attribute) (pyopenxlsx.XLSheetType attribute) worksheet() (pyopenxlsx.XLWorkbook method) worksheet_count() (pyopenxlsx.XLWorkbook method) worksheet_exists() (pyopenxlsx.XLWorkbook method) worksheet_names() (pyopenxlsx.Workbook method) (pyopenxlsx.XLWorkbook method) wrap_text (pyopenxlsx.XLStyle.Alignment property) wrap_text() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) write_back (pyopenxlsx.XLCalculationOptions property) write_range_data() (pyopenxlsx.XLWorksheet method) write_row_data() (pyopenxlsx.XLWorksheet method) write_rows_data() (pyopenxlsx.XLWorksheet method)

X

X (pyopenxlsx.XLErrorBarDirection attribute) (pyopenxlsx.XLMarkerStyle attribute) x_axis() (pyopenxlsx.Chart method) (pyopenxlsx.XLChart method) x_window() (pyopenxlsx.XLDataValidations method) XLAlignment (class in pyopenxlsx) XLAlignmentStyle (class in pyopenxlsx) XLAppProperties (class in pyopenxlsx) XLAutoFilter (class in pyopenxlsx) XLAxis (class in pyopenxlsx) XLAxisCrosses (class in pyopenxlsx) XLAxisOrientation (class in pyopenxlsx) XLAxisTickLabelPosition (class in pyopenxlsx) XLBorder (class in pyopenxlsx) XLBorders (class in pyopenxlsx) XLCalcStatus (class in pyopenxlsx) XLCalculationEngine (class in pyopenxlsx) XLCalculationOptions (class in pyopenxlsx) XLCell (class in pyopenxlsx) XLCellAddressError XLCellFormat (class in pyopenxlsx) XLCellFormats (class in pyopenxlsx) XLCellKey (class in pyopenxlsx) XLCellRange (class in pyopenxlsx) XLCellReference (class in pyopenxlsx) XLCfOperator (class in pyopenxlsx) XLCfRule (class in pyopenxlsx) XLCfRules (class in pyopenxlsx) XLCfTimePeriod (class in pyopenxlsx) XLCfType (class in pyopenxlsx) XLCfvoType (class in pyopenxlsx) XLChart (class in pyopenxlsx) XLChartAnchor (class in pyopenxlsx) XLChartSeries (class in pyopenxlsx) XLChartsheet (class in pyopenxlsx) XLChartType (class in pyopenxlsx) XLColor (class in pyopenxlsx) XLColumn (class in pyopenxlsx) XLComment (class in pyopenxlsx) XLComments (class in pyopenxlsx) XLConditionalFormat (class in pyopenxlsx) XLConditionalFormats (class in pyopenxlsx) XLContentItem (class in pyopenxlsx) XLContentType (class in pyopenxlsx) XLContentTypes (class in pyopenxlsx) XLDataBarColor (class in pyopenxlsx) XLDataValidation (class in pyopenxlsx) XLDataValidationConfig (class in pyopenxlsx) XLDataValidationErrorStyle (class in pyopenxlsx) XLDataValidationOperator (class in pyopenxlsx) XLDataValidations (class in pyopenxlsx) XLDataValidationType (class in pyopenxlsx) XLDateTime (class in pyopenxlsx) XLDateTimeError XLDefinedName (class in pyopenxlsx) XLDefinedNameIterator (class in pyopenxlsx) XLDefinedNames (class in pyopenxlsx) XLDocument (class in pyopenxlsx) XLDrawing (class in pyopenxlsx) XLDrawingItem (class in pyopenxlsx) XLDxf (class in pyopenxlsx) XLErrorBarDirection (class in pyopenxlsx) XLErrorBarType (class in pyopenxlsx) XLErrorBarValueType (class in pyopenxlsx) XLEvalSession (class in pyopenxlsx) XLException XLFill (class in pyopenxlsx) XLFills (class in pyopenxlsx) XLFillType (class in pyopenxlsx) XLFilterColumn (class in pyopenxlsx) XLFilterLogic (class in pyopenxlsx) XLFont (class in pyopenxlsx) XLFonts (class in pyopenxlsx) XLFontSchemeStyle (class in pyopenxlsx) XLFormula (class in pyopenxlsx) XLFormulaDiagnostic (class in pyopenxlsx) XLFormulaDiagnosticReporter (class in pyopenxlsx) XLFormulaEngine (class in pyopenxlsx) XLFormulaError XLHeaderFooter (class in pyopenxlsx) XLImageOptions (class in pyopenxlsx)

XLImagePositioning (class in pyopenxlsx) XLIMEMode (class in pyopenxlsx) XLInputError XLInternalError XLLegendPosition (class in pyopenxlsx) XLLine (class in pyopenxlsx) XLLineDashType (class in pyopenxlsx) XLLineStyle (class in pyopenxlsx) XLMarkerStyle (class in pyopenxlsx) XLMergeCells (class in pyopenxlsx) XLNumberFormat (class in pyopenxlsx) XLNumberFormats (class in pyopenxlsx) XLNumberFormatter (class in pyopenxlsx) XLOverflowError XLPageMargins (class in pyopenxlsx) XLPageOrientation (class in pyopenxlsx) XLPageSetup (class in pyopenxlsx) XLPane (class in pyopenxlsx) XLPaneState (class in pyopenxlsx) XLPatternType (class in pyopenxlsx) XLPerson (class in pyopenxlsx) XLPersons (class in pyopenxlsx) XLPivotField (class in pyopenxlsx) XLPivotSubtotal (class in pyopenxlsx) XLPivotTable (class in pyopenxlsx) XLPivotTableOptions (class in pyopenxlsx) XLPrintOptions (class in pyopenxlsx) XLProperties (class in pyopenxlsx) XLProperty (class in pyopenxlsx) XLPropertyError XLRelationshipItem (class in pyopenxlsx) XLRelationships (class in pyopenxlsx) XLRelationshipType (class in pyopenxlsx) XLRichText (class in pyopenxlsx) XLRichTextRun (class in pyopenxlsx) XLRow (class in pyopenxlsx) XLRowRange (class in pyopenxlsx) XLShape (class in pyopenxlsx) XLShapeClientData (class in pyopenxlsx) XLShapeStyle (class in pyopenxlsx) XLShapeTextHAlign (class in pyopenxlsx) XLShapeTextVAlign (class in pyopenxlsx) XLSheet (class in pyopenxlsx) XLSheetError XLSheetProtectionOptions (class in pyopenxlsx) XLSheetState (class in pyopenxlsx) XLSheetType (class in pyopenxlsx) XLSlicer (class in pyopenxlsx) XLSlicerBuilder (class in pyopenxlsx) XLSlicerCollection (class in pyopenxlsx) XLSlicerOptions (class in pyopenxlsx) XLSlicerStyle (class in pyopenxlsx) XLSparklineOptions (class in pyopenxlsx) XLSparklineType (class in pyopenxlsx) XLStreamEmptyRowPolicy (class in pyopenxlsx) XLStreamReader (class in pyopenxlsx) XLStreamReadOptions (class in pyopenxlsx) XLStreamRowOpts (class in pyopenxlsx) XLStreamWriter (class in pyopenxlsx) XLStyle (class in pyopenxlsx) XLStyle.Alignment (class in pyopenxlsx) XLStyle.Border (class in pyopenxlsx) XLStyle.BorderElement (class in pyopenxlsx) XLStyle.Fill (class in pyopenxlsx) XLStyle.Font (class in pyopenxlsx) XLStyles (class in pyopenxlsx) XLTable (class in pyopenxlsx) XLTableColumn (class in pyopenxlsx) XLTables (class in pyopenxlsx) XLThreadedComment (class in pyopenxlsx) XLThreadedComments (class in pyopenxlsx) XLTotalsRowFunction (class in pyopenxlsx) XLTrendlineType (class in pyopenxlsx) XLUnderlineStyle (class in pyopenxlsx) XLValueTypeError XLVectorShapeOptions (class in pyopenxlsx) XLVectorShapeType (class in pyopenxlsx) XLVerticalAlignRunStyle (class in pyopenxlsx) XLVmlDrawing (class in pyopenxlsx) XLWorkbook (class in pyopenxlsx) XLWorksheet (class in pyopenxlsx)

Y

Y (pyopenxlsx.XLErrorBarDirection attribute) y_axis() (pyopenxlsx.Chart method) (pyopenxlsx.XLChart method)

y_window() (pyopenxlsx.XLDataValidations method) Yesterday (pyopenxlsx.XLCfTimePeriod attribute)

Z

zoom (pyopenxlsx.Worksheet property)

zoom() (pyopenxlsx.XLWorksheet method)