Table of Contents

TExcelFile.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(Integer, Integer, Boolean)) Use this method only to copy the options from one column to another.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColOptions(const col: Integer; const options: Integer); virtual; abstract;

Parameters

<-> Parameter Type Description
const col Integer Column Index (1 based)
const options Integer 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