def test_read_row(datadir, DummyWorkbook): datadir.join("reader").chdir() src = b""" <sheetData xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" > <row r="1" spans="4:27"> <c r="D1"> <v>1</v> </c> <c r="K1"> <v>0.01</v> </c> <c r="AA1"> <v>100</v> </c> </row> </sheetData> """ from openpyxl.worksheet.iter_worksheet import IterableWorksheet ws = IterableWorksheet(DummyWorkbook, "Sheet", "", "", [], []) xml = fromstring(src) row = tuple(ws._get_row(xml, 11, 11)) values = [c.value for c in row] assert values == [0.01] row = tuple(ws._get_row(xml, 1, 11)) values = [c.value for c in row] assert values == [None, None, None, 1, None, None, None, None, None, None, 0.01]
def test_read_row(datadir, DummyWorkbook): datadir.join("reader").chdir() src = b""" <sheetData xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" > <row r="1" spans="4:27"> <c r="D1"> <v>1</v> </c> <c r="K1"> <v>0.01</v> </c> <c r="AA1"> <v>100</v> </c> </row> </sheetData> """ from openpyxl.worksheet.iter_worksheet import IterableWorksheet ws = IterableWorksheet(DummyWorkbook, "Sheet", "", "", [], []) xml = fromstring(src) row = tuple(ws._get_row(xml, 11, 11)) values = [c.value for c in row] assert values == [0.01] row = tuple(ws._get_row(xml, 1, 11)) values = [c.value for c in row] assert values == [ None, None, None, 1, None, None, None, None, None, None, 0.01 ]
def test_read_empty_row(datadir, DummyWorkbook): from openpyxl.worksheet.iter_worksheet import IterableWorksheet ws = IterableWorksheet(DummyWorkbook, "Sheet", "", "", [], []) src = """ <row r="2" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" /> """ element = fromstring(src) row = ws._get_row(element, max_col=10) row = tuple(row) assert len(row) == 10