API Reference
ExcelColumnStyleByHeaderBuilder
Builder for applying styles/number formats to a column resolved by header.
Inheritance
- Object
- ExcelColumnStyleByHeaderBuilder
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Method ExcelColumnStyleByHeaderBuilder.AlignCenter
- Method ExcelColumnStyleByHeaderBuilder.AlignLeft
- Method ExcelColumnStyleByHeaderBuilder.AlignRight
- Method ExcelColumnStyleByHeaderBuilder.Background
- Method ExcelColumnStyleByHeaderBuilder.Background
- Method ExcelColumnStyleByHeaderBuilder.BackgroundByTextMap
- Method ExcelColumnStyleByHeaderBuilder.BackgroundByTextMap
- Method ExcelColumnStyleByHeaderBuilder.BackgroundWhenTextEquals
- Method ExcelColumnStyleByHeaderBuilder.Bold
- Method ExcelColumnStyleByHeaderBuilder.BoldByTextSet
- Method ExcelColumnStyleByHeaderBuilder.BoldWhenTextEquals
- Method ExcelColumnStyleByHeaderBuilder.Currency
- Method ExcelColumnStyleByHeaderBuilder.Date
- Method ExcelColumnStyleByHeaderBuilder.DateTime
- Method ExcelColumnStyleByHeaderBuilder.DurationHours
- Method ExcelColumnStyleByHeaderBuilder.FontColor
- Method ExcelColumnStyleByHeaderBuilder.FontColorByTextMap
- Method ExcelColumnStyleByHeaderBuilder.Integer
- Method ExcelColumnStyleByHeaderBuilder.Number
- Method ExcelColumnStyleByHeaderBuilder.NumberFormat
- Method ExcelColumnStyleByHeaderBuilder.Percent
- Method ExcelColumnStyleByHeaderBuilder.Text
- Method ExcelColumnStyleByHeaderBuilder.Time
- Method ExcelSheet.ColumnStyleByHeader
Accepted by parameters
Methods
public ExcelColumnStyleByHeaderBuilder AlignCenter() #ExcelColumnStyleByHeaderBuilderCenters text in the column.
public ExcelColumnStyleByHeaderBuilder AlignLeft() #ExcelColumnStyleByHeaderBuilderAligns text left in the column.
public ExcelColumnStyleByHeaderBuilder AlignRight() #ExcelColumnStyleByHeaderBuilderAligns text right in the column.
public ExcelColumnStyleByHeaderBuilder Background(String hexColor) #ExcelColumnStyleByHeaderBuilderApplies a solid background fill to the column. Accepts #RRGGBB or #AARRGGBB.
Parameters
- hexColor System.String
public ExcelColumnStyleByHeaderBuilder Background(OfficeColor color) #ExcelColumnStyleByHeaderBuilderApplies a solid background fill to the column using an OfficeIMO color.
Parameters
- color OfficeIMO.Drawing.OfficeColor
- Fill color.
public ExcelColumnStyleByHeaderBuilder BackgroundByTextMap(IDictionary<String, String> map, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderApplies 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
public ExcelColumnStyleByHeaderBuilder BackgroundByTextMap(IDictionary<String, OfficeColor> map, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderOverload that accepts OfficeIMO colors for convenience.
Parameters
- arg1 System.Collections.Generic.IDictionary{System.String,OfficeIMO.Drawing.OfficeColor}
- arg2 System.Boolean = true
public ExcelColumnStyleByHeaderBuilder BackgroundWhenTextEquals(String text, String hexColor, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderApplies 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 ExcelColumnStyleByHeaderBuilder Bold() #ExcelColumnStyleByHeaderBuilderMakes all cells in the column bold.
public ExcelColumnStyleByHeaderBuilder BoldByTextSet(ISet<String> values, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderMakes the cell bold when its text is in the provided set.
Parameters
- values System.Collections.Generic.ISet{System.String}
- caseInsensitive System.Boolean = true
public ExcelColumnStyleByHeaderBuilder BoldWhenTextEquals(String text, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderMakes the cell bold when its text equals the specified value.
Parameters
- text System.String
- caseInsensitive System.Boolean = true
public ExcelColumnStyleByHeaderBuilder Currency(Int32 decimals = 2, CultureInfo culture = null) #ExcelColumnStyleByHeaderBuilderApplies 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 ExcelColumnStyleByHeaderBuilder Date(String pattern = "yyyy-mm-dd") #ExcelColumnStyleByHeaderBuilderApplies a date format using the provided pattern.
Parameters
- pattern System.String = "yyyy-mm-dd"
- Date format pattern.
public ExcelColumnStyleByHeaderBuilder DateTime(String pattern = "yyyy-mm-dd hh:mm:ss") #ExcelColumnStyleByHeaderBuilderApplies a date and time format using the provided pattern.
Parameters
- pattern System.String = "yyyy-mm-dd hh:mm:ss"
- DateTime format pattern.
public ExcelColumnStyleByHeaderBuilder DurationHours() #ExcelColumnStyleByHeaderBuilderApplies a duration format in hours.
public ExcelColumnStyleByHeaderBuilder FontColor(String hexColor) #ExcelColumnStyleByHeaderBuilderSets font color using hex (#RRGGBB or #AARRGGBB).
Parameters
- hexColor System.String
public ExcelColumnStyleByHeaderBuilder FontColorByTextMap(IDictionary<String, String> map, Boolean caseInsensitive = true) #ExcelColumnStyleByHeaderBuilderSets 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 ExcelColumnStyleByHeaderBuilder Integer() #ExcelColumnStyleByHeaderBuilderApplies an integer number format.
public ExcelColumnStyleByHeaderBuilder Number(Int32 decimals = 0) #ExcelColumnStyleByHeaderBuilderApplies a numeric format with optional decimal places.
Parameters
- decimals System.Int32 = 0
- Number of decimal places.
public ExcelColumnStyleByHeaderBuilder NumberFormat(String format) #ExcelColumnStyleByHeaderBuilderApplies a custom number format string.
Parameters
- format System.String
- Number format pattern.
public ExcelColumnStyleByHeaderBuilder Percent(Int32 decimals = 0) #ExcelColumnStyleByHeaderBuilderApplies a percentage format.
Parameters
- decimals System.Int32 = 0
- Number of decimal places.
public ExcelColumnStyleByHeaderBuilder Text() #ExcelColumnStyleByHeaderBuilderApplies a text format.
public ExcelColumnStyleByHeaderBuilder Time() #ExcelColumnStyleByHeaderBuilderApplies a time format.
Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object