openpyxl.worksheet.tests package
Submodules
- openpyxl.worksheet.tests.conftest module
- openpyxl.worksheet.tests.test_cell_range module
CellRange()
MultiCellRange()
TestCellRange
TestCellRange.test_cells()
TestCellRange.test_check_title()
TestCellRange.test_cols()
TestCellRange.test_contains()
TestCellRange.test_copy()
TestCellRange.test_ctor()
TestCellRange.test_dict()
TestCellRange.test_different_worksheets()
TestCellRange.test_doesnt_contain()
TestCellRange.test_edge_cells()
TestCellRange.test_eq()
TestCellRange.test_expand()
TestCellRange.test_from_string()
TestCellRange.test_gt()
TestCellRange.test_intersection()
TestCellRange.test_is_not_disjoint()
TestCellRange.test_is_not_disjoint_in_both()
TestCellRange.test_is_not_subset()
TestCellRange.test_is_not_superset()
TestCellRange.test_isdisjoint_by_col()
TestCellRange.test_isdisjoint_by_row()
TestCellRange.test_isdisjoint_in_both()
TestCellRange.test_isdisjoint_order()
TestCellRange.test_issubset()
TestCellRange.test_issuperset()
TestCellRange.test_lt()
TestCellRange.test_max_col_too_small()
TestCellRange.test_max_row_too_small()
TestCellRange.test_ne()
TestCellRange.test_no_intersection()
TestCellRange.test_no_union()
TestCellRange.test_repr()
TestCellRange.test_rows()
TestCellRange.test_shift()
TestCellRange.test_shift_negative()
TestCellRange.test_shrink()
TestCellRange.test_size()
TestCellRange.test_str()
TestCellRange.test_union()
TestMultiCellRange
TestMultiCellRange.test_add_cell_range()
TestMultiCellRange.test_add_coord()
TestMultiCellRange.test_avoid_duplicates()
TestMultiCellRange.test_contains()
TestMultiCellRange.test_copy()
TestMultiCellRange.test_ctor()
TestMultiCellRange.test_doesnt_contain()
TestMultiCellRange.test_empty()
TestMultiCellRange.test_eq()
TestMultiCellRange.test_from_string()
TestMultiCellRange.test_iadd()
TestMultiCellRange.test_iter()
TestMultiCellRange.test_ne()
TestMultiCellRange.test_not_empty()
TestMultiCellRange.test_remove()
TestMultiCellRange.test_remove_invalid()
TestMultiCellRange.test_repr()
- openpyxl.worksheet.tests.test_controls module
- openpyxl.worksheet.tests.test_datavalidation module
DataValidation()
DataValidationList()
TestDataValidation
TestDataValidation.test_add_after_sqref()
TestDataValidation.test_contains()
TestDataValidation.test_ctor()
TestDataValidation.test_from_xml()
TestDataValidation.test_hide_drop_down()
TestDataValidation.test_list_validation()
TestDataValidation.test_parser()
TestDataValidation.test_read_formula()
TestDataValidation.test_sqref()
TestDataValidation.test_writer_validation()
TestDataValidationList
test_collapse_cell_addresses()
test_expand_cell_ranges()
- openpyxl.worksheet.tests.test_dimensions module
ColumnDimension()
DummyWorkbook
DummyWorksheet
RowDimension()
TestColDimension
TestColDimension.test_col_dimensions()
TestColDimension.test_col_reindex()
TestColDimension.test_col_style()
TestColDimension.test_col_width()
TestColDimension.test_column_dimension()
TestColDimension.test_copy()
TestColDimension.test_empty_col()
TestColDimension.test_no_named_style()
TestColDimension.test_outline_cols()
TestGrouping
TestRowDimension
test_dimension_interface()
test_invalid_dimension_ctor()
- openpyxl.worksheet.tests.test_filters module
AutoFilter()
ColorFilter()
CustomFilter()
CustomFilters()
DateGroupItem()
DynamicFilter()
FilterColumn()
Filters()
IconFilter()
SortCondition()
SortState()
TestAutoFilter
TestColorFilter
TestCustomFilter
TestCustomFilters
TestDateGroupItem
TestDynamicFilter
TestFilterColumn
TestFilters
TestIconFilter
TestSortCondition
TestSortState
TestTop10
Top10()
- openpyxl.worksheet.tests.test_formula module
- openpyxl.worksheet.tests.test_header module
- openpyxl.worksheet.tests.test_hyperlink module
- openpyxl.worksheet.tests.test_merge module
MergeCell()
MergedCellRange()
TestMergeCell
TestMergedCellRange
TestMergedCellRange.test_contains()
TestMergedCellRange.test_copy()
TestMergedCellRange.test_ctor()
TestMergedCellRange.test_empty_side()
TestMergedCellRange.test_format_1x3()
TestMergedCellRange.test_format_3x1()
TestMergedCellRange.test_format_3x3()
TestMergedCellRange.test_format_protection()
TestMergedCellRange.test_get_borders()
TestMergedCellRange.test_not_contained()
default_border()
double_border()
start_border()
thick_border()
thin_border()
- openpyxl.worksheet.tests.test_ole module
- openpyxl.worksheet.tests.test_page module
- openpyxl.worksheet.tests.test_pagebreak module
- openpyxl.worksheet.tests.test_print_settings module
- openpyxl.worksheet.tests.test_properties module
- openpyxl.worksheet.tests.test_protection module
- openpyxl.worksheet.tests.test_read_only module
DummyWorkbook()
ReadOnlyWorksheet()
TestReadOnlyWorksheet
TestReadOnlyWorksheet.test_calculate_dimension()
TestReadOnlyWorksheet.test_cell()
TestReadOnlyWorksheet.test_cleanup_on_break()
TestReadOnlyWorksheet.test_empty_cell()
TestReadOnlyWorksheet.test_from_xml()
TestReadOnlyWorksheet.test_iter()
TestReadOnlyWorksheet.test_pad_row()
TestReadOnlyWorksheet.test_pad_row_cells()
TestReadOnlyWorksheet.test_pad_row_left()
TestReadOnlyWorksheet.test_pad_row_right()
TestReadOnlyWorksheet.test_pad_rows_after()
TestReadOnlyWorksheet.test_pad_rows_before()
TestReadOnlyWorksheet.test_pad_rows_between()
TestReadOnlyWorksheet.test_pad_rows_bounded()
TestReadOnlyWorksheet.test_read_cell_from_empty_row()
TestReadOnlyWorksheet.test_read_rows()
TestReadOnlyWorksheet.test_reset_dimensions()
test_implementation_compatbility()
- openpyxl.worksheet.tests.test_reader module
PrimedWorksheetReader()
TestWorksheetParser
TestWorksheetParser.test_array_formula()
TestWorksheetParser.test_auto_filter()
TestWorksheetParser.test_bad_conditional_format_rule()
TestWorksheetParser.test_boolean()
TestWorksheetParser.test_cell_without_coordinates()
TestWorksheetParser.test_col_break()
TestWorksheetParser.test_col_width()
TestWorksheetParser.test_conditonal_formatting()
TestWorksheetParser.test_custom_views_breaks()
TestWorksheetParser.test_datetime()
TestWorksheetParser.test_extended_conditional_formatting()
TestWorksheetParser.test_external_hyperlinks()
TestWorksheetParser.test_formula()
TestWorksheetParser.test_formula_data_only()
TestWorksheetParser.test_hidden_col()
TestWorksheetParser.test_hidden_row()
TestWorksheetParser.test_inline_richtext()
TestWorksheetParser.test_inline_string()
TestWorksheetParser.test_invalid_row_number()
TestWorksheetParser.test_legacy()
TestWorksheetParser.test_local_hyperlinks()
TestWorksheetParser.test_mac_date()
TestWorksheetParser.test_merge_cells()
TestWorksheetParser.test_number()
TestWorksheetParser.test_out_of_range_datetime()
TestWorksheetParser.test_page_row_break()
TestWorksheetParser.test_parse_richtext()
TestWorksheetParser.test_read_dimension()
TestWorksheetParser.test_read_row_with_exponent()
TestWorksheetParser.test_row_and_cell_skipping_coordinates()
TestWorksheetParser.test_row_and_cell_without_coordinates()
TestWorksheetParser.test_row_dimensions()
TestWorksheetParser.test_scenarios()
TestWorksheetParser.test_second_row_cell_index_without_coordinates()
TestWorksheetParser.test_shared_formula()
TestWorksheetParser.test_sheet_format()
TestWorksheetParser.test_sheet_properties()
TestWorksheetParser.test_sheet_protection()
TestWorksheetParser.test_sheet_views()
TestWorksheetParser.test_string()
TestWorksheetParser.test_string_formula_data_only()
TestWorksheetParser.test_styled_col()
TestWorksheetParser.test_styled_row()
TestWorksheetParser.test_table_formula()
TestWorksheetParser.test_tables()
TestWorksheetParser.test_timedelta()
TestWorksheetReader
TestWorksheetReader.test_array_formula()
TestWorksheetReader.test_cell()
TestWorksheetReader.test_cols()
TestWorksheetReader.test_external_hyperlinks()
TestWorksheetReader.test_formatting()
TestWorksheetReader.test_internal_hyperlinks()
TestWorksheetReader.test_merged()
TestWorksheetReader.test_merged_hyperlinks()
TestWorksheetReader.test_more_rows_than_cells()
TestWorksheetReader.test_normalize_merged_cell_link()
TestWorksheetReader.test_properties()
TestWorksheetReader.test_rows()
TestWorksheetReader.test_tables()
WorkSheetParser()
Workbook()
WorksheetReader()
test_number_convesion()
- openpyxl.worksheet.tests.test_related module
- openpyxl.worksheet.tests.test_scenario module
- openpyxl.worksheet.tests.test_table module
- openpyxl.worksheet.tests.test_views module
- openpyxl.worksheet.tests.test_worksheet module
DummyWorkbook
TestEditableWorksheet
TestEditableWorksheet.test_deleta_all_rows()
TestEditableWorksheet.test_delete_cols()
TestEditableWorksheet.test_delete_last_col()
TestEditableWorksheet.test_delete_last_row()
TestEditableWorksheet.test_delete_missing_cols()
TestEditableWorksheet.test_delete_missing_rows()
TestEditableWorksheet.test_delete_rows()
TestEditableWorksheet.test_insert_cols()
TestEditableWorksheet.test_insert_rows()
TestEditableWorksheet.test_move_cell()
TestEditableWorksheet.test_move_col_right()
TestEditableWorksheet.test_move_empty_range()
TestEditableWorksheet.test_move_nothing()
TestEditableWorksheet.test_move_range_down()
TestEditableWorksheet.test_move_range_from_string()
TestEditableWorksheet.test_move_range_left()
TestEditableWorksheet.test_move_range_right()
TestEditableWorksheet.test_move_range_up()
TestEditableWorksheet.test_move_range_with_formula()
TestEditableWorksheet.test_move_row_down()
TestEditableWorksheet.test_move_row_up()
TestEditableWorksheet.test_move_translated_fomula()
TestEditableWorksheet.test_remainder()
TestWorksheet
TestWorksheet.test_active_cell()
TestWorksheet.test_add_table()
TestWorksheet.test_append()
TestWorksheet.test_append_2d_list()
TestWorksheet.test_append_cell()
TestWorksheet.test_append_dict_index()
TestWorksheet.test_append_dict_letter()
TestWorksheet.test_append_iterator()
TestWorksheet.test_append_list()
TestWorksheet.test_append_range()
TestWorksheet.test_auto_filter()
TestWorksheet.test_bad_append()
TestWorksheet.test_by_col()
TestWorksheet.test_cell_alternate_coordinates()
TestWorksheet.test_cell_insufficient_coordinates()
TestWorksheet.test_cols()
TestWorksheet.test_delitem()
TestWorksheet.test_fill_rows()
TestWorksheet.test_freeze()
TestWorksheet.test_get_cell()
TestWorksheet.test_get_row()
TestWorksheet.test_get_single__column()
TestWorksheet.test_getitem()
TestWorksheet.test_getitem_invalid()
TestWorksheet.test_getslice()
TestWorksheet.test_gridlines()
TestWorksheet.test_hyperlink_value()
TestWorksheet.test_invalid_cell()
TestWorksheet.test_iter_rows()
TestWorksheet.test_merge_coordinate()
TestWorksheet.test_merge_more_columns_than_rows()
TestWorksheet.test_merge_more_rows_than_columns()
TestWorksheet.test_merge_range_string()
TestWorksheet.test_merged_cell_ranges()
TestWorksheet.test_merged_cells_lookup()
TestWorksheet.test_new_worksheet()
TestWorksheet.test_no_cols()
TestWorksheet.test_no_rows()
TestWorksheet.test_one_cell()
TestWorksheet.test_path()
TestWorksheet.test_print_area()
TestWorksheet.test_print_titles()
TestWorksheet.test_rows()
TestWorksheet.test_selected_cell()
TestWorksheet.test_setitem()
TestWorksheet.test_unmerge_coordinate()
TestWorksheet.test_unmerge_range_string()
TestWorksheet.test_values()
TestWorksheet.test_worksheet_dimension()
Worksheet()
dummy_worksheet()
test_add_chart()
test_add_image()
test_freeze_panes_both()
test_freeze_panes_horiz()
test_freeze_panes_vert()
test_max_column()
test_max_row()
test_min_column()
test_min_row()
- openpyxl.worksheet.tests.test_worksheet_copy module
TestWorksheetCopy
TestWorksheetCopy.test_cannot_copy_between_workbooks()
TestWorksheetCopy.test_cannot_copy_junk()
TestWorksheetCopy.test_cannot_copy_to_self()
TestWorksheetCopy.test_cell_copy_comment()
TestWorksheetCopy.test_cell_copy_hyperlink()
TestWorksheetCopy.test_cell_copy_style()
TestWorksheetCopy.test_cell_copy_value()
TestWorksheetCopy.test_copy_col_dimensions()
TestWorksheetCopy.test_copy_page_margins()
TestWorksheetCopy.test_copy_page_setup()
TestWorksheetCopy.test_copy_print_options()
TestWorksheetCopy.test_copy_row_dimensions()
TestWorksheetCopy.test_ctor()
TestWorksheetCopy.test_merged_cell_copy()
WorksheetCopy()
compare_cells()
copier()
test_copy_worksheet()
- openpyxl.worksheet.tests.test_write_only module
- openpyxl.worksheet.tests.test_writer module
TestWorksheetWriter
TestWorksheetWriter.test_breaks()
TestWorksheetWriter.test_cleanup()
TestWorksheetWriter.test_cols()
TestWorksheetWriter.test_comments()
TestWorksheetWriter.test_dimensions()
TestWorksheetWriter.test_drawings()
TestWorksheetWriter.test_filter()
TestWorksheetWriter.test_format()
TestWorksheetWriter.test_formatting()
TestWorksheetWriter.test_header()
TestWorksheetWriter.test_hyperlinks()
TestWorksheetWriter.test_legacy()
TestWorksheetWriter.test_margins()
TestWorksheetWriter.test_merged_cells()
TestWorksheetWriter.test_page_setup()
TestWorksheetWriter.test_print()
TestWorksheetWriter.test_properties()
TestWorksheetWriter.test_protection()
TestWorksheetWriter.test_row_dimensons()
TestWorksheetWriter.test_rows_sort()
TestWorksheetWriter.test_scenarios()
TestWorksheetWriter.test_setup()
TestWorksheetWriter.test_sort()
TestWorksheetWriter.test_tables()
TestWorksheetWriter.test_validations()
TestWorksheetWriter.test_vba()
TestWorksheetWriter.test_views()
TestWorksheetWriter.test_write_row()
TestWorksheetWriter.test_write_rows()
TestWorksheetWriter.test_write_rows_comment()
TestWorksheetWriter.test_write_sheet()
TestWorksheetWriter.test_write_tail()
TestWorksheetWriter.test_write_top()
writer()