openpyxl.tests.test_iter module

openpyxl.tests.test_iter.DummyWorkbook()[source]
openpyxl.tests.test_iter.ReadOnlyWorksheet()[source]
class openpyxl.tests.test_iter.TestRead[source]
expected = [('Sheet1 - Text', 7), ('Sheet2 - Numbers', 27), ('Sheet3 - Formulas', 4), ('Sheet4 - Dates', 3)]
test_get_missing_cell(sample_workbook)[source]
test_getitem(sample_workbook)[source]
test_max_column(sample_workbook, sheetname, col)[source]
test_max_row(sample_workbook)[source]
test_read_boolean(sample_workbook, cell, expected)[source]
test_read_fast_integrated_numbers(sample_workbook)[source]
test_read_fast_integrated_numbers_2(sample_workbook)[source]
test_read_fast_integrated_text(sample_workbook)[source]
test_read_single_cell(sample_workbook)[source]
test_read_single_cell_date(sample_workbook, cell, value)[source]
test_read_single_cell_range(sample_workbook)[source]
openpyxl.tests.test_iter.sample_workbook(request, datadir)[source]

Standard and read-only workbook

openpyxl.tests.test_iter.test_calculate_dimension(datadir)[source]

Behaviour differs between implementations

openpyxl.tests.test_iter.test_ctor(datadir, DummyWorkbook, ReadOnlyWorksheet, filename, expected)[source]
openpyxl.tests.test_iter.test_force_dimension(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_get_empty_cells_nonempty_row(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]

Fix for issue #908.

Get row slice which only contains empty cells in a row containing non-empty cells earlier in the row.

openpyxl.tests.test_iter.test_get_max_cell(datadir, DummyWorkbook, ReadOnlyWorksheet, filename)[source]
openpyxl.tests.test_iter.test_nonstandard_name(datadir)[source]
openpyxl.tests.test_iter.test_open_many_sheets(datadir)[source]
openpyxl.tests.test_iter.test_read_cell_from_empty_row(DummyWorkbook, ReadOnlyWorksheet, row, column)[source]
openpyxl.tests.test_iter.test_read_dimension(datadir, filename, expected)[source]
openpyxl.tests.test_iter.test_read_empty_row(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_read_empty_rows(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_read_empty_sheet(datadir, read_only)[source]
openpyxl.tests.test_iter.test_read_row(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_read_single_cell_formula(datadir, data_only, expected)[source]
openpyxl.tests.test_iter.test_read_style_iter(tmpdir)[source]

Test if cell styles are read properly in iter mode.

openpyxl.tests.test_iter.test_read_with_missing_cells(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_read_without_coordinates(DummyWorkbook, ReadOnlyWorksheet)[source]