Index

A

activate() (App method) (Book method) (Shape method) (Sheet method) active (Apps property) (Books property) (Sheets property) add() (Apps method) (Books method) (Charts method) (Names method) (Pictures method) (PivotFields method) (PivotTables method) (PivotValueFields method) (Sheets method) (TableColumns method) (TableRows method) (Tables method) add_cell_value() (ConditionalFormats method) add_color_scale() (ConditionalFormats method) add_comment() (Range method) add_custom() (ConditionalFormats method) add_data_bar() (ConditionalFormats method) add_hyperlink() (Range method) add_icon_set() (ConditionalFormats method) add_note() (Range method) add_reply() (Comment method) address (Range property) adjust_indent() (Range method) alert() (App method) alert_style (DataValidation property) api (App property) (Book property) (Books property) (Border property) (Borders property) (Characters property) (Chart property) (ChartAxis property) (ChartLegend property) (Charts property) (ChartSeries property) (ChartSeriesCollection property) (Comment property) (ConditionalFormats property) (DataValidation property) (Font property) (Name property) (Names property) (Note property) (PageSetup property) (Picture property) (Pictures property) (PivotField property) (PivotFields property) (PivotTable property) (PivotTables property) (PivotValueField property) (PivotValueFields property) (Range property) (Shape property) (Shapes property) (Sheet property) (Sheets property) (Table property) (TableColumns property) (TableRows property) (Tables property)

app (Book property) App (class in xlwings) apply_bottom_items() (AutoFilter method) apply_bottom_percent() (AutoFilter method) apply_comparison() (AutoFilter method) apply_top_items() (AutoFilter method) apply_top_percent() (AutoFilter method) apply_values() (AutoFilter method) Apps (class in xlwings.main) author (Comment property) (Note property) autofill() (Range method) AutoFilter (class in xlwings) autofilter (Range property) (Table property) AutoFilterCriteria (class in xlwings) autofit() (Range method) (RangeColumns method) (RangeRows method) (Sheet method)

B

bar_color (ConditionalFormat property) bold (Font property) Book (class in xlwings) book (Sheet property) BookAsync (class in xlwings) books (App property) Books (class in xlwings.main)

Border (class in xlwings.main) Borders (class in xlwings.main) borders (Range property) built-in function xlwings.arg() xlwings.func() xlwings.ret() xlwings.script()

C

calculate() (App method) calculation (App property) caller() (Book class method) category_axis (Chart property) cells (Sheet property) Characters (class in xlwings.main) Chart (class in xlwings) chart_type (Chart property) ChartAxis (class in xlwings.main) ChartLegend (class in xlwings.main) Charts (class in xlwings.main) charts (Sheet property) ChartSeries (class in xlwings.main) ChartSeriesCollection (class in xlwings.main) cleanup() (Apps method) clear() (AutoFilter method) (Borders method) (ConditionalFormats method) (Range method) (Sheet method) clear_contents() (Range method) (Sheet method) clear_formats() (Range method) (Sheet method) close() (Book method) color (Border property) (Borders property) (Font property) (Range property) colors (ConditionalFormat property) column (Range property) column_width (Range property) columns (PivotTable property) (Range property) (Table property) Comment (class in xlwings.main)

comment (Range property) CommentReply (class in xlwings.main) comments (Book property) Comments (class in xlwings.main) comments (Sheet property) conditional_formats (Range property) ConditionalFormat (class in xlwings) ConditionalFormats (class in xlwings) copy() (Range method) (Sheet method) copy_from() (Range method) copy_picture() (Range method) count (Apps property) (AutoFilterCriteria property) (Books property) (Charts property) (ChartSeriesCollection property) (Comments property) (ConditionalFormats property) (Names property) (Notes property) (Pictures property) (PivotFields property) (PivotTables property) (PivotValueFields property) (Range property) (RangeColumns property) (RangeRows property) (Shapes property) (Sheets property) (TableColumns property) (TableRows property) (Tables property) creation_date (Comment property) criteria (AutoFilter property) current_region (Range property) cut_copy_mode (App property)

D

data_body_range (PivotTable property) (Table property) (TableColumn property) data_validation (Range property) DataValidation (class in xlwings.main) delete() (Chart method) (Comment method) (ConditionalFormat method) (DataValidation method) (Name method) (Note method) (Picture method) (PivotTable method) (Range method) (Shape method) (Sheet method) (TableColumn method) (TableRow method)

display_alerts (App property) display_name (Table property)

E

enable_events (App property) end() (Range method)

error_message (DataValidation property) error_title (DataValidation property) expand() (Range method)

F

field (AutoFilterCriteria property) field_names (PivotTable property) fill_color (ChartSeries property) (ConditionalFormat property) filters (PivotTable property) find() (Range method) flush() (Book method) font (Characters property) Font (class in xlwings.main) font_bold (ConditionalFormat property) font_color (ConditionalFormat property) font_italic (ConditionalFormat property)

formatter() (in module xlwings.reports) formula (ConditionalFormat property) (DataValidation property) (Range property) formula1 (ConditionalFormat property) (DataValidation property) formula2 (ConditionalFormat property) (DataValidation property) (Range property) formula_array (Range property) freeze_panes (Sheet property) fullname (Book property) function (PivotValueField property)

G

get_active() (Books method) (Sheets method) get_address() (Range method) get_author() (Comment method) (Note method) get_bold() (Font method) get_color() (Border method) (Borders method) (Font method) (Range method) get_colors() (Range method) get_column_width() (Range method) get_comment() (Range method) get_comments() (Book method) (Sheet method) get_conditional_formats() (Range method) get_count() (TableColumns method) (TableRows method) get_creation_date() (Comment method) get_criteria() (AutoFilter method) get_current_region() (Range method) get_data_body_range() (PivotTable method) (TableColumn method) get_data_validation() (Range method) get_fill_color() (ChartSeries method) get_formula() (Range method) get_formula_array() (Range method) get_height() (Range method) get_hidden() (RangeColumns method) (RangeRows method) get_horizontal_alignment() (Range method) get_hyperlink() (Range method) get_italic() (Font method) get_left() (Range method) get_line_color() (ChartSeries method) get_line_style() (Border method) (Borders method) get_location() (Comment method) (Note method) get_major_unit() (ChartAxis method) get_marker_background_color() (ChartSeries method)

get_marker_foreground_color() (ChartSeries method) get_marker_size() (ChartSeries method) get_marker_style() (ChartSeries method) get_maximum_scale() (ChartAxis method) get_merge_area() (Range method) get_merge_cells() (Range method) get_minimum_scale() (ChartAxis method) get_name() (ChartSeries method) (Font method) get_number_format() (ChartAxis method) (Range method) get_png() (Chart method) get_range() (PivotTable method) (TableColumn method) (TableRow method) get_replies() (Comment method) get_resolved() (Comment method) get_row_height() (Range method) get_selection() (App method) (Book method) get_series() (Chart method) get_size() (Font method) get_special_cells() (Range method) get_table() (Range method) get_text() (Characters method) (Comment method) (CommentReply method) (Note method) (Shape method) get_title() (ChartAxis method) get_top() (Range method) get_used_range() (Sheet method) get_value() (Range method) get_vertical_alignment() (Range method) get_visible() (ChartAxis method) get_weight() (Border method) (Borders method) get_width() (Range method) get_wrap_text() (Range method) gradient (ConditionalFormat property) group() (Range method)

H

has_array (Range property) header_row_range (Table property) height (Chart property) (Picture property) (Range property) (Shape property)

hidden (RangeColumns property) (RangeRows property) horizontal_alignment (Range property) hwnd (App property) hyperlink (Range property)

I

icon_set (ConditionalFormat property) ignore_blank (DataValidation property) Image (class in xlwings.reports) in_cell_dropdown (DataValidation property) index (Sheet property) (TableColumn property) (TableRow property)

input_message (DataValidation property) input_title (DataValidation property) insert() (Range method) insert_row_range (Table property) interactive (App property) italic (Font property)

J

json() (Book method)

K

keys() (Apps method)

kill() (App method)

L

last_cell (Range property) layout (PivotTable property) left (Chart property) (Picture property) (Range property) (Shape property) legend (Chart property) line_color (ChartSeries property)

line_style (Border property) (Borders property) load() (Book method) (in module xlwings) (Sheet method) location (Comment property) (Note property) lock_aspect_ratio (Picture property)

M

macro() (App method) (Book method) major_unit (ChartAxis property) Markdown (class in xlwings.reports) MarkdownStyle (class in xlwings.reports) marker_background_color (ChartSeries property) marker_foreground_color (ChartSeries property) marker_size (ChartSeries property) marker_style (ChartSeries property)

maximum_scale (ChartAxis property) merge() (Range method) merge_area (Range property) merge_cells (Range property) minimum_scale (ChartAxis property) module xlwings xlwings.reports move() (Sheet method)

N

name (Book property) (Chart property) (ChartSeries property) Name (class in xlwings) name (Font property) (Name property) (Picture property) (PivotField property) (PivotTable property) (PivotValueField property) (Range property) (Shape property) (Sheet property) (Table property) (TableColumn property)

names (Book property) Names (class in xlwings.main) names (Sheet property) Note (class in xlwings.main) note (Range property) notes (Book property) Notes (class in xlwings.main) notes (Sheet property) number_format (ChartAxis property) (PivotValueField property) (Range property)

O

offset() (Range method) open() (Books method) operator (AutoFilterCriteria property) (ConditionalFormat property) (DataValidation property)

options() (Range method)

P

page_setup (Sheet property) PageSetup (class in xlwings.main) parent (Chart property) (Picture property) (PivotField property) (PivotFields property) (PivotTable property) (PivotTables property) (PivotValueField property) (PivotValueFields property) (Shape property) (Table property) paste() (Range method) path (App property) percent (AutoFilterCriteria property)

Picture (class in xlwings) Pictures (class in xlwings.main) pictures (Sheet property) pid (App property) pivot_tables (Sheet property) PivotField (class in xlwings) PivotFields (class in xlwings) PivotTable (class in xlwings) PivotTables (class in xlwings) PivotValueField (class in xlwings) PivotValueFields (class in xlwings) plot_by (Chart property) position (ChartLegend property) print_area (PageSetup property) properties() (App method)

Q

quit() (App method)

R

Range (class in xlwings) range (PivotTable property) (Table property) (TableColumn property) (TableRow property) range() (App method) (Sheet method) RangeColumns (class in xlwings) RangeRows (class in xlwings) raw_value (Range property) refers_to (Name property) refers_to_range (Name property) refresh() (PivotTable method) remove() (PivotField method) (PivotValueField method) remove_duplicates() (Range method)

render_template() (App method) (Book method) (in module xlwings.reports) (Sheet method) reopen() (Comment method) replace_all() (Range method) replies (Comment property) resize() (Range method) (Table method) resolve() (Comment method) resolved (Comment property) reverse_order (ConditionalFormat property) row (Range property) row_height (Range property) rows (PivotTable property) (Range property) (Table property)

S

save() (Book method) scale_height() (Shape method) scale_width() (Shape method) screen_updating (App property) select() (Range method) (Sheet method) selection (App property) (Book property) series (Chart property) set() (Borders method) (ChartAxis method) (ChartSeries method) (ConditionalFormat method) set_colors() (Range method) set_custom() (DataValidation method) set_date() (DataValidation method) set_decimal() (DataValidation method) set_list() (DataValidation method) set_mock_caller() (Book method) set_source_data() (Chart method) set_text_length() (DataValidation method) set_time() (DataValidation method) set_whole_number() (DataValidation method) set_x_axis_values() (Chart method) Shape (class in xlwings) shape (Range property) Shapes (class in xlwings.main) shapes (Sheet property)

Sheet (class in xlwings) sheet (Range property) sheet_names (Book property) sheets (Book property) Sheets (class in xlwings.main) show_autofilter (Table property) show_column_grand_totals (PivotTable property) show_error (DataValidation property) show_gridlines (Sheet property) show_headers (Table property) show_input (DataValidation property) show_row_grand_totals (PivotTable property) show_table_style_column_stripes (Table property) show_table_style_first_column (Table property) show_table_style_last_column (Table property) show_table_style_row_stripes (Table property) show_totals (Table property) show_value (ConditionalFormat property) size (Font property) (Range property) sort() (Range method) source (DataValidation property) source_field (PivotValueField property) startup_path (App property) status_bar (App property) stop_if_true (ConditionalFormat property) style (Chart property) sync() (Book method)

T

Table (class in xlwings.main) table (Range property) table_style (Table property) TableColumn (class in xlwings.main) TableColumns (class in xlwings.main) TableRow (class in xlwings.main) TableRows (class in xlwings.main) Tables (class in xlwings.main) tables (Sheet property) text (Characters property) (Comment property) (CommentReply property) (Note property) (Shape property) threshold_types (ConditionalFormat property) thresholds (ConditionalFormat property) title (Chart property) (ChartAxis property)

to_html() (Sheet method) to_pdf() (Book method) (Chart method) (Range method) (Sheet method) to_png() (Chart method) (Range method) top (Chart property) (Picture property) (Range property) (Shape property) totals_row_range (Table property) type (AutoFilterCriteria property) (ConditionalFormat property) (DataValidation property) (Shape property)

U

ungroup() (Range method) unmerge() (Range method)

update() (Picture method) (Table method) used_range (Sheet property)

V

value (Range property) value1 (AutoFilterCriteria property) value2 (AutoFilterCriteria property) value_axis (Chart property) values (AutoFilterCriteria property) (PivotTable property)

version (App property) vertical_alignment (Range property) view() (in module xlwings) visible (App property) (ChartAxis property) (ChartLegend property) (Sheet property)

W

weight (Border property) (Borders property) width (Chart property) (Picture property) (Range property) (Shape property)

wrap_text (Range property)

X

xlwings module xlwings.arg() built-in function xlwings.func() built-in function

xlwings.reports module xlwings.ret() built-in function xlwings.script() built-in function