ExcelTableVisualOptions
OfficeIMO.Excel
Declarative visual options for tables produced by ExcelReportBuilder.AddTable. Keeps the API generic so callers can style by header names without project-specific code.
Inheritance
- object
- ExcelTableVisualOptions
Usage
Explore 3 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters 3
- Method ExcelReportBuilder.AddTable
- Method ExcelReportBuilder.AddTable``1
- Method ColumnComposer.AddTable``1
Constructors
public ExcelTableVisualOptions() #Inherited Methods
Properties
public bool FreezeHeaderRow { get; set; } #Freeze through the header row for easier scrolling.
public bool ShowFirstColumn { get; set; } #Emphasize the first table column when the selected table style supports it.
public bool ShowLastColumn { get; set; } #Emphasize the last table column when the selected table style supports it.
public bool ShowRowStripes { get; set; } #Show alternating row stripes for the table.
public bool ShowColumnStripes { get; set; } #Show alternating column stripes for the table.
public Dictionary<string, int> NumericColumnDecimals { get; } #Apply a numeric format with fixed decimals by header name.
public Dictionary<string, string> NumericColumnFormats { get; } #Apply a custom number format pattern by header name.
public Dictionary<string, OfficeColor> DataBars { get; } #Add a data bar to a column with a specific color by header name.
public HashSet<string> IconSetColumns { get; } #Add an icon set to columns identified by header name (simple).
public Dictionary<string, ExcelIconSetOptions> IconSets { get; } #Detailed icon set options by header name.
public Dictionary<string, IDictionary<string, string>> TextBackgrounds { get; } #Apply background colors depending on cell text for a given header name.
public Dictionary<string, ISet<string>> BoldByText { get; } #Makes cells bold when their text matches any value in the set, keyed by header name.
public bool AutoFormatDynamicCollections { get; set; } #When true, applies generic numeric formatting and a subtle data bar to columns that originate from mapped collections (heuristic: path contains a '.').
public OfficeColor AutoFormatDataBarColor { get; set; } #Optional override for the data bar color used by AutoFormatDynamicCollections.
public int AutoFormatDecimals { get; set; } #Optional override for decimals used by AutoFormatDynamicCollections.