TXlsFile.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. TExcelFile.SetAutoRowHeight) Use this method only to copy the options from one row to another.

Syntax

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetRowOptions(const row: Integer; const options: Integer); override;

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.

See also

• TXlsFile