Index

A

active (pyopenxlsx.Workbook property) add_author() (pyopenxlsx.XLComments method) add_cell() (pyopenxlsx.DataValidation method) add_comment() (pyopenxlsx.Worksheet method) add_conditional_formatting() (pyopenxlsx.Worksheet method) add_heading_pair() (pyopenxlsx.XLAppProperties method) add_hyperlink() (pyopenxlsx.Worksheet method) add_image() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLDrawing method) add_image_async() (pyopenxlsx.Worksheet method) add_internal_hyperlink() (pyopenxlsx.Worksheet method) add_override() (pyopenxlsx.XLContentTypes method) add_range() (pyopenxlsx.DataValidation method) add_run() (pyopenxlsx.XLRichText method) add_scaled_image() (pyopenxlsx.XLDrawing method) add_shape() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLDrawing method) add_sheet_name() (pyopenxlsx.XLAppProperties method) add_sparkline() (pyopenxlsx.Worksheet method) add_style() (pyopenxlsx.Workbook method) add_style_async() (pyopenxlsx.Workbook method) add_table() (pyopenxlsx.Worksheet method) add_threaded_comment() (pyopenxlsx.Worksheet method) add_threaded_reply() (pyopenxlsx.Worksheet method) add_validation() (pyopenxlsx.DataValidations method) add_worksheet() (pyopenxlsx.XLWorkbook method) address (pyopenxlsx.Range property) address() (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLCellReference method) align_worksheets() (pyopenxlsx.XLAppProperties method) Alignment (class in pyopenxlsx) alignment (pyopenxlsx.Cell property)

alignment() (pyopenxlsx.XLCellFormat method) all() (pyopenxlsx.XLDefinedNames method) allow_blank (pyopenxlsx.DataValidation property) allow_in_cell() (pyopenxlsx.XLShape method) alpha() (pyopenxlsx.XLColor method) anchor() (pyopenxlsx.XLShapeClientData method) app_properties() (pyopenxlsx.XLDocument method) append() (pyopenxlsx.DataValidations method) (pyopenxlsx.Worksheet method) (pyopenxlsx.XLDefinedNames method) append_async() (pyopenxlsx.Worksheet method) append_column() (pyopenxlsx.Table method) append_merge() (pyopenxlsx.XLMergeCells method) append_row() (pyopenxlsx.XLStreamWriter 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.Worksheet method) apply_border() (pyopenxlsx.XLCellFormat method) apply_fill() (pyopenxlsx.XLCellFormat method) apply_font() (pyopenxlsx.XLCellFormat method) apply_number_format() (pyopenxlsx.XLCellFormat method) apply_protection() (pyopenxlsx.XLCellFormat method) AppVersion (pyopenxlsx.XLProperty attribute) as_datetime() (pyopenxlsx.XLDateTime method) author() (pyopenxlsx.XLComments method) author_count() (pyopenxlsx.XLComments method) author_id() (pyopenxlsx.XLComment method) auto_fill() (pyopenxlsx.XLShapeClientData method) auto_filter (pyopenxlsx.Worksheet property) auto_fit_column() (pyopenxlsx.Worksheet method)

B

background_color() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) Baseline (pyopenxlsx.XLVerticalAlignRunStyle attribute) Between (pyopenxlsx.XLDataValidationOperator attribute) black_and_white (pyopenxlsx.PageSetup property) blue() (pyopenxlsx.XLColor method) bold (pyopenxlsx.XLRichTextRun property) bold() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) Border (class in pyopenxlsx)

border (pyopenxlsx.Cell property) border_by_index() (pyopenxlsx.XLBorders method) border_index() (pyopenxlsx.XLCellFormat method) borders() (pyopenxlsx.XLStyles method) bottom (pyopenxlsx.PageMargins property) Bottom (pyopenxlsx.XLAlignmentStyle attribute) bottom() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) BottomLeft (pyopenxlsx.XLPane attribute) BottomRight (pyopenxlsx.XLPane attribute)

C

CalculationChain (pyopenxlsx.XLContentType attribute) Category (pyopenxlsx.XLProperty attribute) Cell (class in pyopenxlsx) cell() (pyopenxlsx.Worksheet method) cell_format_by_index() (pyopenxlsx.XLCellFormats method) cell_formats() (pyopenxlsx.XLStyles method) Center (pyopenxlsx.XLAlignmentStyle attribute) CenterContinuous (pyopenxlsx.XLAlignmentStyle attribute) Chart (pyopenxlsx.XLContentType attribute) ChartColorStyle (pyopenxlsx.XLContentType attribute) Chartsheet (pyopenxlsx.XLContentType attribute) ChartStyle (pyopenxlsx.XLContentType attribute) clear() (pyopenxlsx.DataValidations method) (pyopenxlsx.Formula method) (pyopenxlsx.Range method) (pyopenxlsx.XLCellRange method) (pyopenxlsx.XLRichText method) clear_active_tab() (pyopenxlsx.XLWorkbook method) clear_all_conditional_formatting() (pyopenxlsx.Worksheet method) clear_async() (pyopenxlsx.Range method) clear_panes() (pyopenxlsx.Worksheet method) client_data() (pyopenxlsx.XLShape method) clone_sheet() (pyopenxlsx.XLWorkbook method) close() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLStreamReader method) (pyopenxlsx.XLStreamWriter method) close_async() (pyopenxlsx.Workbook method) color() (pyopenxlsx.Fill method) (pyopenxlsx.Font method) (pyopenxlsx.Side method) (pyopenxlsx.XLFill method) (pyopenxlsx.XLFont method) Column (class in pyopenxlsx) column() (pyopenxlsx.Worksheet method) (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLShapeClientData method)

comment (pyopenxlsx.Cell property) comment() (pyopenxlsx.XLDefinedName method) Comments (pyopenxlsx.XLContentType attribute) Company (pyopenxlsx.XLProperty attribute) content_item() (pyopenxlsx.XLContentTypes method) content_types() (pyopenxlsx.XLDocument method) ControlProperties (pyopenxlsx.XLContentType attribute) copy_worksheet() (pyopenxlsx.Workbook method) copy_worksheet_async() (pyopenxlsx.Workbook method) core_properties() (pyopenxlsx.XLDocument method) CoreProperties (pyopenxlsx.XLContentType attribute) count() (pyopenxlsx.XLBorders method) (pyopenxlsx.XLCellFormats method) (pyopenxlsx.XLComments method) (pyopenxlsx.XLDefinedNames method) (pyopenxlsx.XLFills method) (pyopenxlsx.XLFonts method) (pyopenxlsx.XLMergeCells method) (pyopenxlsx.XLNumberFormats method) create() (pyopenxlsx.XLBorders method) (pyopenxlsx.XLCellFormats method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLFills method) (pyopenxlsx.XLFonts method) (pyopenxlsx.XLNumberFormats method) create_sheet() (pyopenxlsx.Workbook method) create_sheet_async() (pyopenxlsx.Workbook method) CreationDate (pyopenxlsx.XLProperty attribute) Creator (pyopenxlsx.XLProperty attribute) current_row() (pyopenxlsx.XLStreamReader method) current_row_index (pyopenxlsx.XLStreamReader property) Custom (pyopenxlsx.XLDataValidationType attribute) custom_properties (pyopenxlsx.Workbook property) custom_property() (pyopenxlsx.XLDocument method) CustomProperties (pyopenxlsx.XLContentType attribute)

D

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) DashDot (pyopenxlsx.XLLineStyle attribute) DashDotDot (pyopenxlsx.XLLineStyle attribute) Dashed (pyopenxlsx.XLLineStyle attribute) data_validations (pyopenxlsx.Worksheet property) DataValidation (class in pyopenxlsx) DataValidations (class in pyopenxlsx) Date (pyopenxlsx.XLDataValidationType attribute) Decimal (pyopenxlsx.XLDataValidationType attribute) Default (pyopenxlsx.XLPageOrientation attribute) defined_names (pyopenxlsx.Workbook property) defined_names() (pyopenxlsx.XLWorkbook method) delete_column() (pyopenxlsx.Worksheet method) delete_comment() (pyopenxlsx.XLComments method) delete_custom_property() (pyopenxlsx.XLDocument method)

delete_heading_pair() (pyopenxlsx.XLAppProperties method) delete_merge() (pyopenxlsx.XLMergeCells method) delete_override() (pyopenxlsx.XLContentTypes method) delete_property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method) delete_row() (pyopenxlsx.Worksheet method) delete_sheet() (pyopenxlsx.XLWorkbook method) delete_sheet_name() (pyopenxlsx.XLAppProperties method) Description (pyopenxlsx.XLProperty attribute) diagonal() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) Disabled (pyopenxlsx.XLIMEMode attribute) display_name (pyopenxlsx.Table property) Distributed (pyopenxlsx.XLAlignmentStyle attribute) DocSecurity (pyopenxlsx.XLProperty attribute) Dotted (pyopenxlsx.XLLineStyle attribute) Double (pyopenxlsx.XLLineStyle attribute) (pyopenxlsx.XLUnderlineStyle attribute) drawing (pyopenxlsx.Worksheet property) Drawing (pyopenxlsx.XLContentType attribute)

E

empty() (pyopenxlsx.XLRichText method) Equal (pyopenxlsx.XLDataValidationOperator attribute) error (pyopenxlsx.DataValidation property) error_style (pyopenxlsx.DataValidation property) error_title (pyopenxlsx.DataValidation property) evaluate() (pyopenxlsx.FormulaEngine method)

exists() (pyopenxlsx.XLDefinedNames method) ExtendedProperties (pyopenxlsx.XLContentType attribute) extension (pyopenxlsx.ImageInfo property) ExternalLink (pyopenxlsx.XLContentType attribute) extract_images() (pyopenxlsx.Workbook method) extract_images_async() (pyopenxlsx.Workbook method)

F

Fill (class in pyopenxlsx) fill (pyopenxlsx.Cell property) Fill (pyopenxlsx.XLAlignmentStyle attribute) fill_by_index() (pyopenxlsx.XLFills method) fill_color() (pyopenxlsx.XLShape method) fill_index() (pyopenxlsx.XLCellFormat method) fill_type() (pyopenxlsx.XLFill method) fills() (pyopenxlsx.XLStyles method) find_merge() (pyopenxlsx.XLMergeCells method) fit_to_height (pyopenxlsx.PageSetup property) fit_to_width (pyopenxlsx.PageSetup property) Font (class in pyopenxlsx) font (pyopenxlsx.Cell property) 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) format_code() (pyopenxlsx.XLNumberFormat method) Formula (class in pyopenxlsx) formula (pyopenxlsx.Cell property) formula1 (pyopenxlsx.DataValidation property) formula2 (pyopenxlsx.DataValidation property) FormulaEngine (class in pyopenxlsx) freeze_panes() (pyopenxlsx.Worksheet method) Frozen (pyopenxlsx.XLPaneState attribute) FrozenSplit (pyopenxlsx.XLPaneState attribute) FullAlpha (pyopenxlsx.XLIMEMode attribute) FullHangul (pyopenxlsx.XLIMEMode attribute) FullKatakana (pyopenxlsx.XLIMEMode attribute)

G

General (pyopenxlsx.XLAlignmentStyle attribute) get() (pyopenxlsx.XLComments method) (pyopenxlsx.XLDefinedNames method) get_archive_entries() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_archive_entry() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_cell_value() (pyopenxlsx.Worksheet method) get_cell_value_async() (pyopenxlsx.Worksheet method) get_content_items() (pyopenxlsx.XLContentTypes method) get_embedded_images() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method) get_hyperlink() (pyopenxlsx.Worksheet method) get_image() (pyopenxlsx.XLDocument method) get_image_data() (pyopenxlsx.Workbook method) (pyopenxlsx.XLDocument method)

get_range_data() (pyopenxlsx.Worksheet method) get_range_data_async() (pyopenxlsx.Worksheet method) get_range_values() (pyopenxlsx.Worksheet method) get_range_values_async() (pyopenxlsx.Worksheet method) get_row_values() (pyopenxlsx.Worksheet method) get_row_values_async() (pyopenxlsx.Worksheet method) get_rows_data() (pyopenxlsx.Worksheet method) get_rows_data_async() (pyopenxlsx.Worksheet method) get_runs() (pyopenxlsx.XLRichText method) Gradient (pyopenxlsx.XLFillType attribute) Gray0625 (pyopenxlsx.XLPatternType attribute) Gray125 (pyopenxlsx.XLPatternType attribute) GreaterThan (pyopenxlsx.XLDataValidationOperator attribute) GreaterThanOrEqual (pyopenxlsx.XLDataValidationOperator attribute) green() (pyopenxlsx.XLColor method) grid_lines (pyopenxlsx.PrintOptions property)

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_drawing (pyopenxlsx.Worksheet property) has_hyperlink() (pyopenxlsx.Worksheet method) has_macro (pyopenxlsx.Workbook property) has_macro() (pyopenxlsx.XLDocument method) has_next() (pyopenxlsx.XLStreamReader method) has_panes (pyopenxlsx.Worksheet property) header (pyopenxlsx.PageMargins property) headings (pyopenxlsx.PrintOptions property)

height() (pyopenxlsx.XLShapeStyle method) hex() (pyopenxlsx.XLColor method) hidden (pyopenxlsx.Column property) Hidden (pyopenxlsx.XLSheetState attribute) hidden() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLShapeStyle method) hide() (pyopenxlsx.XLShapeStyle method) Hiragana (pyopenxlsx.XLIMEMode attribute) horizontal() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) horizontal_centered (pyopenxlsx.PrintOptions property) Hyperlink (pyopenxlsx.XLContentType attribute) HyperlinkBase (pyopenxlsx.XLProperty attribute) HyperlinksChanged (pyopenxlsx.XLProperty attribute)

I

image() (pyopenxlsx.XLDrawing method) image_count() (pyopenxlsx.XLDrawing method) ImageInfo (class in pyopenxlsx) ime_mode (pyopenxlsx.DataValidation property) increment_sheet_count() (pyopenxlsx.XLAppProperties method) indent() (pyopenxlsx.XLAlignment method) index (pyopenxlsx.Worksheet property) Information (pyopenxlsx.XLDataValidationErrorStyle attribute) insert_column() (pyopenxlsx.Worksheet method)

insert_row() (pyopenxlsx.Worksheet method) insert_sheet_name() (pyopenxlsx.XLAppProperties method) is_active (pyopenxlsx.XLStreamWriter property) is_date (pyopenxlsx.Cell property) is_date_format() (in module pyopenxlsx) is_open() (pyopenxlsx.XLDocument method) italic (pyopenxlsx.XLRichTextRun property) italic() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) iter_row_values() (pyopenxlsx.Worksheet method)

J

Justify (pyopenxlsx.XLAlignmentStyle attribute)

K

Keywords (pyopenxlsx.XLProperty attribute)

L

Landscape (pyopenxlsx.XLPageOrientation attribute) LastModifiedBy (pyopenxlsx.XLProperty attribute) LastPrinted (pyopenxlsx.XLProperty attribute) left (pyopenxlsx.PageMargins property) Left (pyopenxlsx.XLAlignmentStyle attribute) left() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) LessThan (pyopenxlsx.XLDataValidationOperator attribute) LessThanOrEqual (pyopenxlsx.XLDataValidationOperator attribute) LightDown (pyopenxlsx.XLPatternType attribute) LightGray (pyopenxlsx.XLPatternType attribute)

LightGrid (pyopenxlsx.XLPatternType attribute) LightHorizontal (pyopenxlsx.XLPatternType attribute) LightTrellis (pyopenxlsx.XLPatternType attribute) LightUp (pyopenxlsx.XLPatternType attribute) LightVertical (pyopenxlsx.XLPatternType attribute) 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.XLCellFormat method)

M

Major (pyopenxlsx.XLFontSchemeStyle attribute) Manager (pyopenxlsx.XLProperty attribute) margin_left() (pyopenxlsx.XLShapeStyle method) margin_top() (pyopenxlsx.XLShapeStyle method) max_column (pyopenxlsx.Worksheet property) max_row (pyopenxlsx.Worksheet property) 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) merge_cells_async() (pyopenxlsx.Worksheet method) merge_exists() (pyopenxlsx.XLMergeCells method) merges (pyopenxlsx.Worksheet property) Minor (pyopenxlsx.XLFontSchemeStyle attribute) ModificationDate (pyopenxlsx.XLProperty attribute) module pyopenxlsx move_with_cells() (pyopenxlsx.XLShapeClientData method) mso_wrap_style() (pyopenxlsx.XLShapeStyle method)

N

name (pyopenxlsx.ImageInfo property) (pyopenxlsx.Table property) (pyopenxlsx.Worksheet property) name() (pyopenxlsx.Font method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLFont method) next_row() (pyopenxlsx.XLStreamReader method) NoControl (pyopenxlsx.XLIMEMode attribute) None (pyopenxlsx.XLDataValidationType attribute) (pyopenxlsx.XLFontSchemeStyle attribute) (pyopenxlsx.XLLineStyle attribute) (pyopenxlsx.XLPatternType attribute) (pyopenxlsx.XLUnderlineStyle attribute)

NotBetween (pyopenxlsx.XLDataValidationOperator attribute) NotEqual (pyopenxlsx.XLDataValidationOperator attribute) num_columns (pyopenxlsx.Range property) num_columns() (pyopenxlsx.XLCellRange method) num_rows (pyopenxlsx.Range property) num_rows() (pyopenxlsx.XLCellRange method) 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) Off (pyopenxlsx.XLIMEMode attribute) On (pyopenxlsx.XLIMEMode attribute)

open() (pyopenxlsx.XLDocument method) operator (pyopenxlsx.DataValidation property) orientation (pyopenxlsx.PageSetup property)

P

page_margins (pyopenxlsx.Worksheet property) page_setup (pyopenxlsx.Worksheet property) PageMargins (class in pyopenxlsx) PageSetup (class in pyopenxlsx) paper_size (pyopenxlsx.PageSetup property) path (pyopenxlsx.ImageInfo property) path() (pyopenxlsx.XLContentItem method) (pyopenxlsx.XLDocument method) Pattern (pyopenxlsx.XLFillType attribute) pattern_type() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) persons() (pyopenxlsx.XLDocument method) plain_text (pyopenxlsx.XLRichText property) Portrait (pyopenxlsx.XLPageOrientation attribute) position() (pyopenxlsx.XLShapeStyle method)

prepend_sheet_name() (pyopenxlsx.XLAppProperties method) print_options (pyopenxlsx.Worksheet property) PrintOptions (class in pyopenxlsx) prompt (pyopenxlsx.DataValidation property) prompt_title (pyopenxlsx.DataValidation property) properties (pyopenxlsx.Workbook property) property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method) protect() (pyopenxlsx.Worksheet method) protect_async() (pyopenxlsx.Worksheet method) Protection (class in pyopenxlsx) protection (pyopenxlsx.Worksheet property) pyopenxlsx module PythonMergeCells (in module pyopenxlsx)

R

Range (class in pyopenxlsx) range (pyopenxlsx.Table property) range() (pyopenxlsx.Worksheet method) raw() (pyopenxlsx.XLShapeStyle method) read_dataframe() (pyopenxlsx.Worksheet method) read_dataframe_async() (pyopenxlsx.Worksheet method) red() (pyopenxlsx.XLColor method) ref() (pyopenxlsx.XLComment method) refers_to() (pyopenxlsx.XLDefinedName method) Relationships (pyopenxlsx.XLContentType attribute) remove() (pyopenxlsx.DataValidations method) (pyopenxlsx.Workbook method) (pyopenxlsx.XLDefinedNames method)

remove_async() (pyopenxlsx.Workbook method) remove_conditional_formatting() (pyopenxlsx.Worksheet method) remove_hyperlink() (pyopenxlsx.Worksheet method) right (pyopenxlsx.PageMargins property) Right (pyopenxlsx.XLAlignmentStyle attribute) right() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) rotation() (pyopenxlsx.XLAlignment method) row() (pyopenxlsx.XLCellReference method) (pyopenxlsx.XLShapeClientData method) rows (pyopenxlsx.Worksheet property) 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) ScaleCrop (pyopenxlsx.XLProperty attribute) scheme() (pyopenxlsx.XLFont method) serial() (pyopenxlsx.XLDateTime method) set() (pyopenxlsx.XLColor method) (pyopenxlsx.XLComments 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_background_color() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) set_bold() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_border_index() (pyopenxlsx.XLCellFormat method) set_bottom() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_cell_value() (pyopenxlsx.Worksheet method) set_cell_value_async() (pyopenxlsx.Worksheet method) set_cells() (pyopenxlsx.Worksheet method) set_cells_async() (pyopenxlsx.Worksheet method) set_color() (pyopenxlsx.Fill method) (pyopenxlsx.Font method) (pyopenxlsx.XLFill method) (pyopenxlsx.XLFont method) set_column() (pyopenxlsx.XLShapeClientData method) set_column_format() (pyopenxlsx.Worksheet method) set_comment() (pyopenxlsx.XLDefinedName method) set_custom_property() (pyopenxlsx.XLDocument method) set_diagonal() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_error() (pyopenxlsx.DataValidation method) set_fill_color() (pyopenxlsx.XLShape method) set_fill_index() (pyopenxlsx.XLCellFormat method) set_fill_type() (pyopenxlsx.XLFill method) set_font_index() (pyopenxlsx.XLCellFormat method) set_format_code() (pyopenxlsx.XLNumberFormat method) set_heading_pair() (pyopenxlsx.XLAppProperties method) set_height() (pyopenxlsx.XLShapeStyle method) set_hidden() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLDefinedName method) set_horizontal() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) set_indent() (pyopenxlsx.XLAlignment method) set_italic() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_left() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_list() (pyopenxlsx.DataValidation method) set_local_sheet_id() (pyopenxlsx.XLDefinedName method) set_locked() (pyopenxlsx.XLCellFormat method) set_margin_left() (pyopenxlsx.XLShapeStyle method) set_margin_top() (pyopenxlsx.XLShapeStyle method) set_move_with_cells() (pyopenxlsx.XLShapeClientData method) set_mso_wrap_style() (pyopenxlsx.XLShapeStyle method) set_name() (pyopenxlsx.Font method) (pyopenxlsx.XLDefinedName method) (pyopenxlsx.XLFont method) set_number_format_id() (pyopenxlsx.XLCellFormat method) (pyopenxlsx.XLNumberFormat method) set_object_type() (pyopenxlsx.XLShapeClientData method) set_pattern_type() (pyopenxlsx.Fill method) (pyopenxlsx.XLFill method) set_position() (pyopenxlsx.XLShapeStyle method) set_print_area() (pyopenxlsx.Worksheet method) set_print_title_cols() (pyopenxlsx.Worksheet method) set_print_title_rows() (pyopenxlsx.Worksheet method) set_prompt() (pyopenxlsx.DataValidation method) set_property() (pyopenxlsx.XLAppProperties method) (pyopenxlsx.XLDocument method) (pyopenxlsx.XLProperties method)

set_raw() (pyopenxlsx.XLShapeStyle method) set_reference_drop_list() (pyopenxlsx.DataValidation method) set_refers_to() (pyopenxlsx.XLDefinedName method) set_right() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_rotation() (pyopenxlsx.XLAlignment method) set_row() (pyopenxlsx.XLShapeClientData method) set_row_format() (pyopenxlsx.Worksheet method) set_scheme() (pyopenxlsx.XLFont method) set_sheet_name() (pyopenxlsx.XLAppProperties method) set_shrink_to_fit() (pyopenxlsx.XLAlignment method) set_size() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) set_size_with_cells() (pyopenxlsx.XLShapeClientData method) set_strikethrough() (pyopenxlsx.XLFont method) set_stroked() (pyopenxlsx.XLShape method) set_style() (pyopenxlsx.XLShape method) set_style_obj() (pyopenxlsx.XLShape method) set_text() (pyopenxlsx.XLComment method) set_text_h_align() (pyopenxlsx.XLShapeClientData method) set_text_v_align() (pyopenxlsx.XLShapeClientData method) set_top() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) set_type() (pyopenxlsx.XLShape method) set_underline() (pyopenxlsx.XLFont method) set_v_text_anchor() (pyopenxlsx.XLShapeStyle method) set_vert_align() (pyopenxlsx.XLFont method) set_vertical() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) set_width() (pyopenxlsx.XLShapeStyle method) set_wrap_text() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) shape() (pyopenxlsx.XLComments method) shape_id() (pyopenxlsx.XLShape method) SharedDoc (pyopenxlsx.XLProperty attribute) SharedStrings (pyopenxlsx.XLContentType attribute) sheet_count() (pyopenxlsx.XLWorkbook method) sheet_exists() (pyopenxlsx.XLWorkbook method) sheet_state (pyopenxlsx.Worksheet property) sheetnames (pyopenxlsx.Workbook property) show() (pyopenxlsx.XLShapeStyle method) show_column_stripes (pyopenxlsx.Table property) show_drop_down (pyopenxlsx.DataValidation property) show_error_message (pyopenxlsx.DataValidation property) show_first_column (pyopenxlsx.Table property) show_input_message (pyopenxlsx.DataValidation property) show_last_column (pyopenxlsx.Table property) show_row_stripes (pyopenxlsx.Table property) show_totals_row (pyopenxlsx.Table property) shrink_to_fit() (pyopenxlsx.XLAlignment method) Side (class in pyopenxlsx) Single (pyopenxlsx.XLUnderlineStyle attribute) size() (pyopenxlsx.Font method) (pyopenxlsx.XLFont method) size_with_cells() (pyopenxlsx.XLShapeClientData method) SlantDashDot (pyopenxlsx.XLLineStyle attribute) Solid (pyopenxlsx.XLPatternType attribute) Split (pyopenxlsx.XLPaneState attribute) split_panes() (pyopenxlsx.Worksheet method) sqref (pyopenxlsx.DataValidation property) Stop (pyopenxlsx.XLDataValidationErrorStyle attribute) stream_reader() (pyopenxlsx.Worksheet method) stream_writer() (pyopenxlsx.Worksheet method) strikethrough (pyopenxlsx.XLRichTextRun property) strikethrough() (pyopenxlsx.XLFont method) stroked() (pyopenxlsx.XLShape method) Style (class in pyopenxlsx) style (pyopenxlsx.Cell property) (pyopenxlsx.Table property) style() (pyopenxlsx.Side method) (pyopenxlsx.XLShape method) style_index (pyopenxlsx.Cell property) (pyopenxlsx.Column property) styles (pyopenxlsx.Workbook property) Styles (pyopenxlsx.XLContentType attribute) styles() (pyopenxlsx.XLDocument method) Subject (pyopenxlsx.XLProperty attribute) Subscript (pyopenxlsx.XLVerticalAlignRunStyle attribute) Superscript (pyopenxlsx.XLVerticalAlignRunStyle attribute)

T

Table (class in pyopenxlsx) table (pyopenxlsx.Worksheet property) Table (pyopenxlsx.XLContentType attribute) tables (pyopenxlsx.Worksheet property) text (pyopenxlsx.Formula property) (pyopenxlsx.XLRichTextRun property) text() (pyopenxlsx.XLComment method) text_h_align() (pyopenxlsx.XLShapeClientData method) text_v_align() (pyopenxlsx.XLShapeClientData method) TextLength (pyopenxlsx.XLDataValidationType attribute) Theme (pyopenxlsx.XLContentType attribute) Thick (pyopenxlsx.XLLineStyle attribute)

Thin (pyopenxlsx.XLLineStyle attribute) Time (pyopenxlsx.XLDataValidationType attribute) title (pyopenxlsx.Worksheet property) Title (pyopenxlsx.XLProperty attribute) top (pyopenxlsx.PageMargins property) Top (pyopenxlsx.XLAlignmentStyle attribute) top() (pyopenxlsx.Border method) (pyopenxlsx.XLBorder method) TopLeft (pyopenxlsx.XLPane attribute) TopRight (pyopenxlsx.XLPane attribute) type (pyopenxlsx.DataValidation property) type() (pyopenxlsx.XLContentItem method) (pyopenxlsx.XLShape method)

U

underline (pyopenxlsx.XLRichTextRun property) underline() (pyopenxlsx.XLFont method) Unknown (pyopenxlsx.XLContentType attribute)

unmerge_cells() (pyopenxlsx.Worksheet method) unmerge_cells_async() (pyopenxlsx.Worksheet method) unprotect() (pyopenxlsx.Worksheet method) unprotect_async() (pyopenxlsx.Worksheet method)

V

v_text_anchor() (pyopenxlsx.XLShapeStyle method) valid() (pyopenxlsx.XLComment method) (pyopenxlsx.XLDefinedName method) value (pyopenxlsx.Cell property) VBAProject (pyopenxlsx.XLContentType attribute) vert_align() (pyopenxlsx.XLFont method)

vertical() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) vertical_centered (pyopenxlsx.PrintOptions property) VeryHidden (pyopenxlsx.XLSheetState attribute) Visible (pyopenxlsx.XLSheetState attribute) visible() (pyopenxlsx.XLShapeStyle method) VMLDrawing (pyopenxlsx.XLContentType attribute)

W

Warning (pyopenxlsx.XLDataValidationErrorStyle attribute) Whole (pyopenxlsx.XLDataValidationType attribute) width (pyopenxlsx.Column property) width() (pyopenxlsx.XLShapeStyle method) Workbook (class in pyopenxlsx) workbook (pyopenxlsx.Workbook property) Workbook (pyopenxlsx.XLContentType attribute) workbook() (pyopenxlsx.XLDocument method) WorkbookMacroEnabled (pyopenxlsx.XLContentType attribute) Worksheet (class in pyopenxlsx) (pyopenxlsx.XLContentType attribute)

worksheet() (pyopenxlsx.XLWorkbook method) worksheet_names() (pyopenxlsx.XLWorkbook method) wrap_text() (pyopenxlsx.Alignment method) (pyopenxlsx.XLAlignment method) write_dataframe() (pyopenxlsx.Worksheet method) write_dataframe_async() (pyopenxlsx.Worksheet method) write_range() (pyopenxlsx.Worksheet method) write_range_async() (pyopenxlsx.Worksheet method) write_row() (pyopenxlsx.Worksheet method) write_row_async() (pyopenxlsx.Worksheet method) write_rows() (pyopenxlsx.Worksheet method) write_rows_async() (pyopenxlsx.Worksheet method)

X

XLAlignment (class in pyopenxlsx) XLAlignmentStyle (class in pyopenxlsx) XLAppProperties (class in pyopenxlsx) XLBorder (class in pyopenxlsx) XLBorders (class in pyopenxlsx) XLCellFormat (class in pyopenxlsx) XLCellFormats (class in pyopenxlsx) XLCellRange (class in pyopenxlsx) XLCellReference (class in pyopenxlsx) XLColor (class in pyopenxlsx) XLComment (class in pyopenxlsx) XLComments (class in pyopenxlsx) XLContentItem (class in pyopenxlsx) XLContentType (class in pyopenxlsx) XLContentTypes (class in pyopenxlsx) XLDataValidationErrorStyle (class in pyopenxlsx) XLDataValidationOperator (class in pyopenxlsx) XLDataValidationType (class in pyopenxlsx) XLDateTime (class in pyopenxlsx) XLDefinedName (class in pyopenxlsx) XLDefinedNames (class in pyopenxlsx) XLDocument (class in pyopenxlsx) XLDrawing (class in pyopenxlsx) XLFill (class in pyopenxlsx) XLFills (class in pyopenxlsx) XLFillType (class in pyopenxlsx)

XLFont (class in pyopenxlsx) XLFonts (class in pyopenxlsx) XLFontSchemeStyle (class in pyopenxlsx) XLIMEMode (class in pyopenxlsx) XLLineStyle (class in pyopenxlsx) XLMergeCells (class in pyopenxlsx) XLNumberFormat (class in pyopenxlsx) XLNumberFormats (class in pyopenxlsx) XLPageOrientation (class in pyopenxlsx) XLPane (class in pyopenxlsx) XLPaneState (class in pyopenxlsx) XLPatternType (class in pyopenxlsx) XLProperties (class in pyopenxlsx) XLProperty (class in pyopenxlsx) XLRichText (class in pyopenxlsx) XLRichTextRun (class in pyopenxlsx) XLShape (class in pyopenxlsx) XLShapeClientData (class in pyopenxlsx) XLShapeStyle (class in pyopenxlsx) XLSheetState (class in pyopenxlsx) XLStreamReader (class in pyopenxlsx) XLStreamWriter (class in pyopenxlsx) XLStyles (class in pyopenxlsx) XLUnderlineStyle (class in pyopenxlsx) XLVerticalAlignRunStyle (class in pyopenxlsx) XLWorkbook (class in pyopenxlsx)

Z

zoom (pyopenxlsx.Worksheet property)