ExcelFile.SetColOptions Method
Sets all Column options at once (if the column is hidden, etc).
Remarks
To set individual values, use the corresponding methods (i.e. SetColHidden(Int32, Int32, Boolean)) Use this method only to copy the options from one column to another.
Syntax
Namespace: FlexCel.Core
public abstract void SetColOptions(Int32 col, Int32 options)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
col | Int32 | Column Index (1 based) | |
options | Int32 | A flag with all column options. |
Examples
To copy all the column options from column 1 to 2, use
xls.SetColOptions(2, xls.GetColOptions(1));
This is faster and simpler than assigning each option alone.