Table of Contents

TXlsFile.GetColOptions Method

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

Remarks

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

Syntax

Unit: FlexCel.XlsAdapter

function TXlsFile.GetColOptions(const col: Integer): Integer; override;

Parameters

<-> Parameter Type Description
const col Integer Column Index (1 based)

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