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
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
