OfficeIMO

API Reference

Class

TableVisualOptions

Namespace OfficeIMO.Excel.Fluent
Assembly OfficeIMO.Excel
Modifiers sealed

Declarative visual options for tables produced by ReportSheetBuilder.TableFrom. Keeps the API generic so callers can style by header names without project-specific code.

Inheritance

  • Object
  • TableVisualOptions

Constructors

Properties

public Boolean FreezeHeaderRow { get; set; } #

Freeze through the header row for easier scrolling.

public Dictionary<String, Int32> 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, Color> 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, IconSetOptions> 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 Boolean 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 Color AutoFormatDataBarColor { get; set; } #

Optional override for the data bar color used by AutoFormatDynamicCollections.

public Int32 AutoFormatDecimals { get; set; } #

Optional override for decimals used by AutoFormatDynamicCollections.