def test_unique_xls_sheet_name(self):
xls_writer = XlsWriter()
xls_writer.add_sheet("section9_pit_latrine_with_slab_group")
xls_writer.add_sheet("section9_pit_latrine_without_slab_group")
# create a set of sheet names keys
sheet_names_set = set(xls_writer._sheets.keys())
self.assertEqual(len(sheet_names_set), 2)
def test_xls_writer(self):
xls_writer = XlsWriter()
xls_writer.set_file()
xls_writer.write_tables_to_workbook([
('table one', [['column header 1', 'column header 2'], [
1,
2,
]]), ('table two', [['1,1', '1,2'], ['2,1', '2,2']])
])
file_object = xls_writer.save_workbook_to_file()
def test_unique_xls_sheet_name(self):
xls_writer = XlsWriter()
xls_writer.add_sheet('section9_pit_latrine_with_slab_group')
xls_writer.add_sheet('section9_pit_latrine_without_slab_group')
# create a set of sheet names keys
sheet_names_set = set(xls_writer._sheets.keys())
self.assertEqual(len(sheet_names_set), 2)
def test_xls_writer(self):
xls_writer = XlsWriter()
xls_writer.set_file()
xls_writer.write_tables_to_workbook([
('table one', [['column header 1', 'column header 2'], [1, 2,]]),
('table two', [['1,1', '1,2'], ['2,1', '2,2']])
])
file_object = xls_writer.save_workbook_to_file()