def test_get_max_cell(datadir, DummyWorkbook, ReadOnlyWorksheet, filename): datadir.join("reader").chdir() DummyWorkbook._archive.write(filename, "sheet1.xml") ws = ReadOnlyWorksheet(DummyWorkbook, "Sheet", "sheet1.xml", []) ws._shared_strings = ['A', 'B'] rows = tuple(ws.rows) assert rows[-1][-1].coordinate == "AA30"
def test_force_dimension(datadir, DummyWorkbook, ReadOnlyWorksheet): datadir.join("reader").chdir() wb = DummyWorkbook wb._archive.write("sheet2_no_dimension.xml", "sheet1.xml") ws = ReadOnlyWorksheet(DummyWorkbook, "Sheet", "sheet1.xml", []) ws._shared_strings = ['A', 'B'] dims = ws.calculate_dimension(True) assert dims == "A1:AA30"