def test_ws_calc_size(self): ws = Worksheet({}) # force calc size ws._calc_size() self.assertEqual(ws.maxrow, 0) self.assertEqual(ws.maxcol, 0) ws._data = {'A1': {'v': 11}} ws._calc_size() self.assertEqual(ws.maxrow, 1) self.assertEqual(ws.maxcol, 1) ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}} ws._calc_size() self.assertEqual(ws.maxrow, 2) self.assertEqual(ws.maxcol, 1) ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}, 'B1': {'v': 12}} ws._calc_size() self.assertEqual(ws.maxrow, 2) self.assertEqual(ws.maxcol, 2) ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}, 'B1': {'v': 12}, 'B2': {'v': 22}} ws._calc_size() self.assertEqual(ws.maxrow, 2) self.assertEqual(ws.maxcol, 2) ws._data = {'A1': {'v': 1}, 'AA1': {'v': 27}, 'AAA1': {'v': 703}} ws._calc_size() self.assertEqual(ws.maxrow, 1) self.assertEqual(ws.maxcol, 703) ws._data = {'A1': {'v': 1}, 'A1000': {'v': 1000}, 'A1048576': {'v': 1048576}} ws._calc_size() self.assertEqual(ws.maxrow, 1048576) self.assertEqual(ws.maxcol, 1) ws._data = {'A1': {'v': 1}, 'AA1': {'v': 27}, 'AAA1': {'v': 703}, 'XFD1': {'v': 16384}, 'A1048576': {'v': 1048576}} ws._calc_size() self.assertEqual(ws.maxrow, 1048576) self.assertEqual(ws.maxcol, 16384)
def test_ws_size(self): ws = Worksheet({}) self.assertEqual(ws.size, [0, 0]) ws._data = {'A1': {'v': 11}, 'A2': {'v': 21}} ws._calc_size() self.assertEqual(ws.size, [2, 1])