Table of Contents

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.

See also