Table of Contents

TXlsFile.GetRowOptions Method

Returns all Row options at once (if the row is autosize, if it is hidden, etc).

Remarks

To get individual values, use the corresponding methods (i.e. TExcelFile.GetAutoRowHeight) Use this method only to copy the options from one row to another.

Syntax

Unit: FlexCel.XlsAdapter

function TXlsFile.GetRowOptions(const row: Integer): Integer; override;

Parameters

<-> Parameter Type Description
const row Integer Row Index (1 based)

Returns

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 alone.

See also