class TestWorkbook:
def setUp(self):
# Connect to test file and make Sheet1 the active sheet
xl_file1 = os.path.join(os.path.dirname(os.path.abspath(__file__)), 'test_workbook_1.xlsx')
self.wb = Workbook(xl_file1)
self.wb.activate('Sheet1')
def tearDown(self):
self.wb.close()
def test_clear_content_active_sheet(self):
Range('G10').value = 22
self.wb.clear_contents()
cell = Range('G10').value
assert_equal(cell, None)
def test_clear_active_sheet(self):
Range('G10').value = 22
self.wb.clear()
cell = Range('G10').value
assert_equal(cell, None)
def test_clear_content(self):
Range('Sheet2', 'G10').value = 22
self.wb.clear_contents('Sheet2')
cell = Range('Sheet2', 'G10').value
assert_equal(cell, None)
def test_clear(self):
Range('Sheet2', 'G10').value = 22
self.wb.clear('Sheet2')
cell = Range('Sheet2', 'G10').value
assert_equal(cell, None)
