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]