ExcelFile.SetColOptions Method

Sets all Column options at once (if the column is hidden, etc).

Remarks

To set individual values, use the corresponding methods (i.e. SetColHidden(Int32, Int32, Boolean)) Use this method only to copy the options from one column to another.

Syntax

Namespace: FlexCel.Core

public abstract void SetColOptions(Int32 col, Int32 options)

Parameters

<->	Parameter	Type	Description
	col	Int32	Column Index (1 based)
	options	Int32	A flag with all column options.

Examples

To copy all the column options from column 1 to 2, use

    xls.SetColOptions(2, xls.GetColOptions(1));

This is faster and simpler than assigning each option alone.

See also

• ExcelFile