openpyxl.tests.test_iter module

openpyxl.tests.test_iter.DummyWorkbook()[source]
openpyxl.tests.test_iter.ReadOnlyWorksheet()[source]
class openpyxl.tests.test_iter.TestRead[source]

Bases: object

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, coord, 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, coord, value)[source]
test_read_single_cell_range(sample_workbook)[source]
openpyxl.tests.test_iter.count_open_fds()[source]

Return the number of open file descriptors for this process

The implementation assumes that all FDs are smaller than 10,000 and that nobody (other threads, garbage collection) modifies the file descriptors while we are counting.

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_file_descriptor_leak(datadir)[source]
openpyxl.tests.test_iter.test_force_dimension(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
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_empty_rows(datadir, DummyWorkbook, ReadOnlyWorksheet)[source]
openpyxl.tests.test_iter.test_read_empty_sheet(datadir, read_only)[source]
openpyxl.tests.test_iter.test_read_mac_date(datadir, read_only)[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]