def test_formatter_by_named_column(self):
"""Test one named column"""
s = Sheet(self.data, "test")
s.name_columns_by_row(0)
f = NamedColumnFormatter("Column 1", str)
s.apply_formatter(f)
assert s.column["Column 1"] == ["1", "4", "7"]
def test_formatter_by_named_columns(self):
"""Test multiple named columns"""
s = Sheet(self.data, "test")
s.name_columns_by_row(0)
f = NamedColumnFormatter(["Column 1", "Column 3"], str)
s.apply_formatter(f)
assert s.column["Column 1"] == ["1", "4", "7"]
assert s.column["Column 3"] == ["3", "6", "9"]
def test_formatter_by_named_row2(self):
"""Test a list of string as index"""
s = Sheet(self.data, "test")
s.name_rows_by_column(0)
f = NamedRowFormatter(["Row 1", "Row 2"], str)
s.apply_formatter(f)
assert s.row["Row 1"] == ["1", "2", "3"]
assert s.row["Row 2"] == ["4", "5", "6"]
def test_apply_sheet_formatter(self):
s = Sheet(self.data)
s.apply_formatter(SheetFormatter(float))
assert s.row[0] == s.row[1]
assert s.column[0] == [1, 1, 1.1, 1.1, 2, 2]
def test_apply_column_formatter(self):
s = Sheet(self.data)
s.apply_formatter(ColumnFormatter(0, float))
assert s.column[0] == [1, 1, 1.1, 1.1, 2, 2]
def test_formatter_by_named_row(self):
s = Sheet(self.data, "test")
s.name_rows_by_column(0)
f = NamedRowFormatter("Row 1", str)
s.apply_formatter(f)
assert s.row["Row 1"] == ["1", "2", "3"]
def test_apply_row_formatter(self):
s = Sheet(self.data)
s.apply_formatter(RowFormatter(0, str))
assert s.row[0] == s.row[1]
