TExcelFile.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. SetAutoRowHeight) Use this method only to copy the options from one row to another.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.SetRowOptions(const row: Integer; const options: Integer); virtual; abstract;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row Index (1 based) |
const | options | Integer | 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.