class WorksheetTest(unittest.TestCase): def setUp(self): self.ws = Worksheet("test", None, 0) self.format = Format(color="green") def tearDown(self): self.ws = None def test_methods_no_error(self): self.ws.write([0, 1], None) self.ws.write((0, 2), "Hello") self.ws.write((0, 3), 888) self.ws.write([0, 4], 888L) self.ws.write_row((0, 0), []) self.ws.write_row((0, 0), ["one", "two", "three"]) self.ws.write_row((0, 0), [1, 2, 3]) self.ws.write_col((0, 0), []) self.ws.write_col((0, 0), ["one", "two", "three"]) self.ws.write_col((0, 0), [1, 2, 3]) self.ws.write_blank((0, 0), []) def test_store_dimensions(self): self.ws._store_dimensions() datasize = self.ws._datasize self.assertEqual(14, datasize) def test_store_window2(self): self.ws._store_window2() datasize = self.ws._datasize self.assertEqual(14, datasize) def test_store_selection(self): self.ws._store_selection(0, 0, 0, 0) datasize = self.ws._datasize self.assertEqual(19, datasize) def test_store_colinfo_output(self): self.ws._store_colinfo() datasize = self.ws._datasize self.assertEqual(15, datasize) def test_format_row(self): self.ws.set_row(3, None) self.ws.set_row(2, 10) self.ws.set_row(1, 25, self.format) self.ws.set_row(4, None, self.format) # [4, 6] def test_format_column(self): self.ws.set_column(3, None) self.ws.set_column(2, 10) self.ws.set_column(1, 25, self.format) self.ws.set_column([4, 6], None, self.format) def test_process_cell(self): rc = self.ws._process_cell("C80") self.assertEqual((79, 2), rc) rc = self.ws._process_cell([63, 84]) self.assertEqual((63, 84), rc) def test_process_cellrange(self): rc = self.ws._process_cellrange("C80") self.assertEqual((79, 2, 79, 2), rc) rc = self.ws._process_cellrange((7, 6)) self.assertEqual((7, 6, 7, 6), rc) def test_process_rowrange(self): rc = self.ws._process_rowrange(6) self.assertEqual((6, 0, 6, -1), rc) rc = self.ws._process_rowrange((5, 6)) self.assertEqual((5, 0, 6, -1), rc) rc = self.ws._process_rowrange("4:6") self.assertEqual((3, 0, 5, -1), rc) def test_process_colrange(self): rc = self.ws._process_colrange(5) self.assertEqual((0, 5, -1, 5), rc) rc = self.ws._process_colrange((5, 6)) self.assertEqual((0, 5, -1, 6), rc) rc = self.ws._process_colrange("D:E") self.assertEqual((0, 3, -1, 4), rc)
class WorksheetTest(unittest.TestCase): def setUp(self): self.ws = Worksheet("test", None, 0) self.format = Format(color="green") def tearDown(self): self.ws = None def test_methods_no_error(self): self.ws.write([0, 1], None) self.ws.write((0, 2), "Hello") self.ws.write((0, 3), 888) self.ws.write([0, 4], 888L) self.ws.write_row((0, 0), []) self.ws.write_row((0, 0), ["one", "two", "three"]) self.ws.write_row((0, 0), [1, 2, 3]) self.ws.write_col((0, 0), []) self.ws.write_col((0, 0), ["one", "two", "three"]) self.ws.write_col((0, 0), [1, 2, 3]) self.ws.write_blank((0, 0), []) def test_store_dimensions(self): self.ws._store_dimensions() datasize = self.ws._datasize self.assertEqual(14, datasize) def test_store_window2(self): self.ws._store_window2() datasize = self.ws._datasize self.assertEqual(14, datasize) def test_store_selection(self): self.ws._store_selection(0, 0, 0, 0) datasize = self.ws._datasize self.assertEqual(19, datasize) def test_store_colinfo_output(self): self.ws._store_colinfo() datasize = self.ws._datasize self.assertEqual(15, datasize) def test_format_row(self): self.ws.set_row(3, None) self.ws.set_row(2, 10) self.ws.set_row(1, 25, self.format) self.ws.set_row(4, None, self.format) # [4, 6] def test_format_column(self): self.ws.set_column(3, None) self.ws.set_column(2, 10) self.ws.set_column(1, 25, self.format) self.ws.set_column([4, 6], None, self.format) def test_process_cell(self): rc = self.ws._process_cell("C80") self.assertEqual((79, 2), rc) rc = self.ws._process_cell([63, 84]) self.assertEqual((63, 84), rc) def test_process_cellrange(self): rc = self.ws._process_cellrange("C80") self.assertEqual((79, 2, 79, 2), rc) rc = self.ws._process_cellrange((7, 6)) self.assertEqual((7, 6, 7, 6), rc) def test_process_rowrange(self): rc = self.ws._process_rowrange(6) self.assertEqual((6, 0, 6, -1), rc) rc = self.ws._process_rowrange((5, 6)) self.assertEqual((5, 0, 6, -1), rc) rc = self.ws._process_rowrange("4:6") self.assertEqual((3, 0, 5, -1), rc) def test_process_colrange(self): rc = self.ws._process_colrange(5) self.assertEqual((0, 5, -1, 5), rc) rc = self.ws._process_colrange((5, 6)) self.assertEqual((0, 5, -1, 6), rc) rc = self.ws._process_colrange("D:E") self.assertEqual((0, 3, -1, 4), rc)