openpyxl.worksheet.tests.test_worksheet module

class openpyxl.worksheet.tests.test_worksheet.DummyWorkbook[source]

Bases: object

encoding = 'UTF-8'
class openpyxl.worksheet.tests.test_worksheet.TestEditableWorksheet[source]

Bases: object

test_deleta_all_rows(dummy_worksheet)[source]
test_delete_cols(dummy_worksheet)[source]
test_delete_last_col(dummy_worksheet)[source]
test_delete_last_row(dummy_worksheet)[source]
test_delete_missing_cols(dummy_worksheet)[source]
test_delete_missing_rows(dummy_worksheet)[source]
test_delete_rows(dummy_worksheet)[source]
test_insert_cols(dummy_worksheet)[source]
test_insert_rows(dummy_worksheet)[source]
test_move_cell(dummy_worksheet)[source]
test_move_col_right(dummy_worksheet)[source]
test_move_empty_range(dummy_worksheet)[source]
test_move_nothing(dummy_worksheet)[source]
test_move_range_down(dummy_worksheet)[source]
test_move_range_from_string(dummy_worksheet)[source]
test_move_range_left(dummy_worksheet)[source]
test_move_range_right(dummy_worksheet)[source]
test_move_range_up(dummy_worksheet)[source]
test_move_range_with_formula(dummy_worksheet)[source]
test_move_row_down(dummy_worksheet)[source]
test_move_row_up(dummy_worksheet)[source]
test_move_translated_fomula(dummy_worksheet, translate, formula, result)[source]
test_remainder(dummy_worksheet, idx, offset, max_val, remainder)[source]
class openpyxl.worksheet.tests.test_worksheet.TestWorksheet[source]

Bases: object

test_active_cell(Worksheet)[source]
test_add_table(Worksheet)[source]
test_append(Worksheet)[source]
test_append_2d_list(Worksheet)[source]
test_append_cell(Worksheet)[source]
test_append_dict_index(Worksheet)[source]
test_append_dict_letter(Worksheet)[source]
test_append_iterator(Worksheet)[source]
test_append_list(Worksheet)[source]
test_append_range(Worksheet)[source]
test_auto_filter(Worksheet)[source]
test_bad_append(Worksheet)[source]
test_by_col(Worksheet)[source]
test_cell_alternate_coordinates(Worksheet)[source]
test_cell_insufficient_coordinates(Worksheet)[source]
test_cols(Worksheet)[source]
test_delitem(dummy_worksheet)[source]
test_fill_rows(Worksheet, row, column, coordinate)[source]
test_freeze(Worksheet)[source]
test_get_cell(Worksheet)[source]
test_get_row(Worksheet, key)[source]
test_get_single__column(Worksheet, key)[source]
test_getitem(Worksheet)[source]
test_getitem_invalid(Worksheet, key)[source]
test_getslice(Worksheet)[source]
test_gridlines(Worksheet)[source]
test_invalid_cell(Worksheet)[source]
test_iter_rows(Worksheet)[source]
test_merge_coordinate(Worksheet)[source]
test_merge_more_columns_than_rows(Worksheet)[source]
test_merge_more_rows_than_columns(Worksheet)[source]
test_merge_range_string(Worksheet)[source]
test_merged_cell_ranges(Worksheet)[source]
test_merged_cells_lookup(Worksheet)[source]
test_new_worksheet(Worksheet)[source]
test_no_cols(Worksheet)[source]
test_no_rows(Worksheet)[source]
test_one_cell(Worksheet)[source]
test_path(Worksheet)[source]
test_print_area(cell_range, result)[source]
test_print_titles(rows, cols, titles)[source]
test_rows(Worksheet)[source]
test_selected_cell(Worksheet)[source]
test_setitem(Worksheet)[source]
test_unmerge_coordinate(Worksheet)[source]
test_unmerge_range_string(Worksheet)[source]
test_values(Worksheet)[source]
test_worksheet_dimension(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.Worksheet()[source]
openpyxl.worksheet.tests.test_worksheet.dummy_worksheet(Worksheet)[source]

Creates a worksheet A1:H6 rows with values the same as cell coordinates

openpyxl.worksheet.tests.test_worksheet.test_add_chart(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_add_image(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_freeze_panes_both(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_freeze_panes_horiz(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_freeze_panes_vert(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_max_column(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_max_row(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_min_column(Worksheet)[source]
openpyxl.worksheet.tests.test_worksheet.test_min_row(Worksheet)[source]