API Reference
ColumnStyleByHeaderBuilder
Builder for applying styles/number formats to a column resolved by header.
Inheritance
- Object
- ColumnStyleByHeaderBuilder
Methods
public ColumnStyleByHeaderBuilder AlignCenter() #ColumnStyleByHeaderBuilderCenters text in the column.
public ColumnStyleByHeaderBuilder AlignLeft() #ColumnStyleByHeaderBuilderAligns text left in the column.
public ColumnStyleByHeaderBuilder AlignRight() #ColumnStyleByHeaderBuilderAligns text right in the column.
public ColumnStyleByHeaderBuilder Background(Color color) #ColumnStyleByHeaderBuilderApplies a solid background fill to the column. Accepts #RRGGBB or #AARRGGBB.
Parameters
- hexColor System.String
Background(SixLabors.ImageSharp.Color color) #Applies a solid background fill to the column using an ImageSharp color.
Parameters
- color SixLabors.ImageSharp.Color
- Fill color.
public ColumnStyleByHeaderBuilder BackgroundByTextMap(IDictionary<String, Color> map, Boolean caseInsensitive = true) #ColumnStyleByHeaderBuilderApplies background fills to cells based on a text→color mapping. Keys are compared case-insensitively by default.
Parameters
- map System.Collections.Generic.IDictionary{System.String,System.String}
- caseInsensitive System.Boolean = true
BackgroundByTextMap(System.Collections.Generic.IDictionary{System.String,SixLabors.ImageSharp.Color} arg1, System.Boolean arg2) #Overload that accepts SixLabors colors for convenience.
Parameters
- arg1 System.Collections.Generic.IDictionary{System.String,SixLabors.ImageSharp.Color}
- arg2 System.Boolean
public ColumnStyleByHeaderBuilder BackgroundWhenTextEquals(String text, String hexColor, Boolean caseInsensitive = true) #ColumnStyleByHeaderBuilderApplies a background fill to cells in this column when their text equals the specified value. Comparison is case-insensitive by default.
Parameters
- text System.String
- hexColor System.String
- caseInsensitive System.Boolean = true
public ColumnStyleByHeaderBuilder Bold() #ColumnStyleByHeaderBuilderMakes all cells in the column bold.
public ColumnStyleByHeaderBuilder BoldByTextSet(ISet<String> values, Boolean caseInsensitive = true) #ColumnStyleByHeaderBuilderMakes the cell bold when its text is in the provided set.
Parameters
- values System.Collections.Generic.ISet{System.String}
- caseInsensitive System.Boolean = true
public ColumnStyleByHeaderBuilder BoldWhenTextEquals(String text, Boolean caseInsensitive = true) #ColumnStyleByHeaderBuilderMakes the cell bold when its text equals the specified value.
Parameters
- text System.String
- caseInsensitive System.Boolean = true
public ColumnStyleByHeaderBuilder Currency(Int32 decimals = 2, CultureInfo culture = null) #ColumnStyleByHeaderBuilderApplies a currency format using the specified culture.
Parameters
- decimals System.Int32 = 2
- Number of decimal places.
- culture System.Globalization.CultureInfo = null
- Culture for currency symbol.
public ColumnStyleByHeaderBuilder Date(String pattern = "yyyy-mm-dd") #ColumnStyleByHeaderBuilderApplies a date format using the provided pattern.
Parameters
- pattern System.String = "yyyy-mm-dd"
- Date format pattern.
public ColumnStyleByHeaderBuilder DateTime(String pattern = "yyyy-mm-dd hh:mm:ss") #ColumnStyleByHeaderBuilderApplies a date and time format using the provided pattern.
Parameters
- pattern System.String = "yyyy-mm-dd hh:mm:ss"
- DateTime format pattern.
public ColumnStyleByHeaderBuilder DurationHours() #ColumnStyleByHeaderBuilderApplies a duration format in hours.
public ColumnStyleByHeaderBuilder FontColor(String hexColor) #ColumnStyleByHeaderBuilderSets font color using hex (#RRGGBB or #AARRGGBB).
Parameters
- hexColor System.String
public ColumnStyleByHeaderBuilder FontColorByTextMap(IDictionary<String, String> map, Boolean caseInsensitive = true) #ColumnStyleByHeaderBuilderSets font colors by matching cell text to a provided mapping of text→hex color.
Parameters
- map System.Collections.Generic.IDictionary{System.String,System.String}
- caseInsensitive System.Boolean = true
public ColumnStyleByHeaderBuilder Integer() #ColumnStyleByHeaderBuilderApplies an integer number format.
public ColumnStyleByHeaderBuilder Number(Int32 decimals = 0) #ColumnStyleByHeaderBuilderApplies a numeric format with optional decimal places.
Parameters
- decimals System.Int32 = 0
- Number of decimal places.
public ColumnStyleByHeaderBuilder NumberFormat(String format) #ColumnStyleByHeaderBuilderApplies a custom number format string.
Parameters
- format System.String
- Number format pattern.
public ColumnStyleByHeaderBuilder Percent(Int32 decimals = 0) #ColumnStyleByHeaderBuilderApplies a percentage format.
Parameters
- decimals System.Int32 = 0
- Number of decimal places.
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object