XlsFile.SetRowOptions Method
Sets all Row options at once (if the row is autosize, if it is hidden, etc).
Remarks
To set individual values, use the corresponding methods (i.e. ExcelFile.SetAutoRowHeight) Use this method only to copy the options from one row to another.
Syntax
Namespace: FlexCel.XlsAdapter
public override void SetRowOptions(Int32 row, Int32 options)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
row | Int32 | Row Index (1 based) | |
options | Int32 | A flag with all row options |
Examples
To copy all the row options from row 1 to 2, use
xls.SetRowOptions(2, xls.GetRowOptions(1));
This is faster and simpler than assigning each option one by one.