Table of Contents

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