def test_get_xlsx_auto(self):
"""Verify an XLSX object can be created with placeholder rows."""
# Act
workbook = exporter._get_xlsx(self.item4, auto=True) # pylint: disable=W0212
# Assert
rows = []
worksheet = workbook.active
for data in worksheet.rows:
rows.append([cell.value for cell in data])
self.assertEqual("...", rows[-1][0])
def test_get_xlsx_auto(self):
"""Verify an XLSX object can be created with placeholder rows."""
# Act
workbook = exporter._get_xlsx(self.item4, auto=True) # pylint: disable=W0212
# Assert
rows = []
worksheet = workbook.active
for data in worksheet.rows:
rows.append([cell.value for cell in data])
self.assertEqual("...", rows[-1][0])
def test_get_xlsx(self):
"""Verify an XLSX object can be created."""
# Act
workbook = exporter._get_xlsx(self.item4) # pylint: disable=W0212
# Assert
rows = []
worksheet = workbook.active
for data in worksheet.rows:
rows.append([cell.value for cell in data])
self.assertIn('long', rows[0])
self.assertEqual('req3', rows[1][0])
def test_get_xlsx(self):
"""Verify an XLSX object can be created."""
# Act
workbook = exporter._get_xlsx(self.item4, auto=False) # pylint: disable=W0212
# Assert
rows = []
worksheet = workbook.active
for data in worksheet.rows:
rows.append([cell.value for cell in data])
self.assertIn('long', rows[0])
self.assertEqual('req3', rows[1][0])
