ExcelColumnSizingOptions
OfficeIMO.Excel
Options for clamping column widths and enabling wrapping by header. Preset defaults use character units; each width also accepts a physical length.
Inheritance
- object
- ExcelColumnSizingOptions
Usage
Explore 1 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 1
Constructors
public ExcelColumnSizingOptions() #Inherited Methods
Properties
public ExcelColumnWidth ShortWidth { get; set; } #Character or physical width used for headers registered in ExcelColumnSizingOptions.ShortHeaders.
public ExcelColumnWidth NumericWidth { get; set; } #Character or physical width used for headers registered in ExcelColumnSizingOptions.NumericHeaders.
public ExcelColumnWidth MediumWidth { get; set; } #Character or physical width used for headers registered in ExcelColumnSizingOptions.MediumHeaders.
public ExcelColumnWidth LongWidth { get; set; } #Character or physical width used for headers registered in ExcelColumnSizingOptions.LongHeaders.
public HashSet<string> ShortHeaders { get; } #Case-insensitive set of header names that should use ExcelColumnSizingOptions.ShortWidth.
public HashSet<string> NumericHeaders { get; } #Case-insensitive set of header names that should use ExcelColumnSizingOptions.NumericWidth.
public HashSet<string> MediumHeaders { get; } #Case-insensitive set of header names that should use ExcelColumnSizingOptions.MediumWidth.
public HashSet<string> LongHeaders { get; } #Case-insensitive set of header names that should use ExcelColumnSizingOptions.LongWidth.
public HashSet<string> WrapHeaders { get; } #Case-insensitive set of header names that should be wrapped regardless of width.
public ExcelColumnWidth WrapWidth { get; set; } #Default character or physical width used for headers registered in ExcelColumnSizingOptions.WrapHeaders.
public HashSet<string> AutoFitHeaders { get; } #Headers that should be auto-fit instead of using the preset widths.
public bool AutoFitRemainingColumns { get; set; } #When true, headers that do not have an explicit width/preset will be auto-fit.
public Dictionary<string, ExcelColumnWidth> WidthByHeader { get; } #Explicit column width overrides keyed by header name. Values are character or physical dimensions.