def test_set_table_by_name(self):
self.sheets += Table(name='Sheet1')
self.sheets['Sheet1'] = Table(name='Sheet2')
self.assertEqual(len(self.sheets), 1)
self.assertEqual(self.sheets[0].name, 'Sheet2')
def test_remove_table_by_index(self):
self.sheets += Table(name='Sheet1')
self.sheets += Table(name='Sheet2')
del self.sheets['Sheet1']
self.assertEqual(len(self.sheets), 1)
self.assertEqual(self.sheets[0].name, 'Sheet2')
def test_sheet_insert(self):
self.sheets += Table(name='Sheet1')
self.sheets += Table(name='Sheet2')
self.sheets.insert(1, Table(name='Sheet3'))
self.assertEqual(self.sheets[1].name, 'Sheet3')
self.assertEqual(len(self.sheets), 3)
def test_copy_table_with_new_name(self):
table1 = Table(name='Test')
table1['A1'].set_value('marker')
table2 = table1.copy(newname='Copy of ' + table1.name)
self.assertEqual('Copy of Test', table2.name, "table2 has wrong name.")
self.assertEqual('marker', table2['A1'].value,
"marker not found in table2")
def setUp(self):
self.table = Table('TEST', size=(10, 10))
add_table_prelude_content(self.table)
for col in range(self.table.nrows()):
self.table[0, col].set_value('checkmark%d' % col )
invoke_cache = self.cellvalue(0, col)
for col in range(self.table.ncols()):
column_info = self.table.column_info(col)
column_info.style_name = 'c%d' % col
def test_has_xmlnode(self):
table = Table()
self.assertIsNotNone(table.xmlnode)
def setUp(self):
self.table = Table(name="TEST", size=(10, 10))
def test_has_TAG(self):
table = Table()
self.assertEqual(table.TAG, CN('table:table'))
def setUp(self):
self.table = Table(xmlnode=etree.XML(SQUAREMATRIX))
def test_get_style_name(self):
table = Table()
self.assertIsNone(table.style_name)
def test_get_last_sheet_by_index(self):
self.sheets += Table(name='Sheet1')
self.sheets += Table(name='Sheet2')
self.sheets += Table(name='Sheet3')
sheet = self.sheets[-1]
self.assertEqual(sheet.name, 'Sheet3')
def test_setup_error(self):
with self.assertRaises(ValueError):
Table(size=(1, 0))
with self.assertRaises(ValueError):
Table(size=(0, 1))
def test_name_with_cr_and_tabs(self):
table = Table('table\tname\r ')
self.assertEqual(table.name, 'table name', "table name not normalized")
def test_reset(self):
table = Table(name="TEST", size=(7, 5))
table.reset(size=(8, 10))
self.assertEqual("TEST", table.name, "name attribute is deleted")
self.assertEqual(table.ncols(), 10)
self.assertEqual(table.nrows(), 8)
def test_clear_table(self):
table = Table(name="TEST")
table[0, 0].set_value("marker")
table.clear()
self.assertIsNone(table[0, 0].value, "cell value should be None")
def test_init_row_cols(self):
table = Table(name="TEST", size=(7, 5))
self.assertEqual(table.nrows(), 7)
self.assertEqual(table.ncols(), 5)
def test_set_print(self):
table = Table()
table.print_ = True
self.assertTrue(table.print_)
self.assertEqual(table.get_attr(CN('table:print')), 'true',
'table:print should be true')
def test_get_print(self):
table = Table()
self.assertFalse(table.print_)
def test_get_name(self):
table = Table()
name = table.name
self.assertTrue(is_string(name))
def test_get_protected(self):
table = Table()
self.assertFalse(table.protected)
def test_set_name(self):
table = Table()
table.name = 'TABLE'
self.assertEqual(table.name, 'TABLE')
self.assertEqual(table.get_attr(CN('table:name')), 'TABLE',
'wrong tag name')
def test_protection_key_not_set(self):
table = Table()
key = table.get_attr(CN('table:protection-key'))
self.assertIsNone(key)
def test_name_with_apostroph2(self):
table = Table(" table'name")
self.assertEqual(table.name, 'table name', "table name not normalized")
def test_get_sheet_by_name(self):
self.sheets.append(Table(name='Sheet1'))
sheet = self.sheets['Sheet1']
self.assertEqual(sheet.name, 'Sheet1')
def test_set_style_name(self):
table = Table()
table.style_name = 'STYLE'
self.assertEqual(table.style_name, 'STYLE')
self.assertEqual(table.get_attr(CN('table:style-name')), 'STYLE',
'wrong tag name')
def test_sheet_index_1_error(self):
self.sheets += Table(name='Sheet1')
with self.assertRaises(IndexError):
self.sheets[1]
def test_set_protected(self):
table = Table()
table.protected = True
self.assertTrue(table.protected)
self.assertEqual(table.get_attr(CN('table:protected')), 'true',
'wrong tag name')
def test_copy_table_without_new_name(self):
table1 = Table(name='Test')
table2 = table1.copy()
self.assertEqual('CopyOfTest', table2.name, "table2 has wrong name.")
def test_protection_key_is_set(self):
table = Table()
table.protected = True
key = table.get_attr(CN('table:protection-key'))
self.assertIsNotNone(key, "protection-key not set")
self.assertGreater(len(key), 8, "protection-key is too short")
def setUp(self):
self.table = Table(xmlnode=etree.XML(TABLE_COMP))
