API Reference
ColumnSizingOptions
Options for clamping column widths and enabling wrapping by header. Widths use Excel's character-based units (approx. number of '0' glyphs).
Inheritance
- Object
- ColumnSizingOptions
Constructors
public ColumnSizingOptions() #Inherited Methods
public override Boolean Equals(Object obj) #BooleanParameters
- obj Object
Properties
public Double ShortWidth { get; set; } #Width in characters used for headers registered in ShortHeaders.
public Double NumericWidth { get; set; } #Width in characters used for headers registered in NumericHeaders.
public Double MediumWidth { get; set; } #Width in characters used for headers registered in MediumHeaders.
public Double LongWidth { get; set; } #Width in characters used for headers registered in LongHeaders.
public HashSet<String> ShortHeaders { get; } #Case-insensitive set of header names that should use ShortWidth.
public HashSet<String> NumericHeaders { get; } #Case-insensitive set of header names that should use NumericWidth.
public HashSet<String> MediumHeaders { get; } #Case-insensitive set of header names that should use MediumWidth.
public HashSet<String> LongHeaders { get; } #Case-insensitive set of header names that should use LongWidth.
public HashSet<String> WrapHeaders { get; } #Case-insensitive set of header names that should be wrapped regardless of width.
public Double WrapWidth { get; set; } #Default width (in characters) used for headers registered in WrapHeaders.
public HashSet<String> AutoFitHeaders { get; } #Headers that should be auto-fit instead of using the preset widths.
public Boolean AutoFitRemainingColumns { get; set; } #When true, headers that do not have an explicit width/preset will be auto-fit.
public Dictionary<String, Double> WidthByHeader { get; } #Explicit column width overrides keyed by header name. Values are Excel character widths.