Table of Contents

TExcelFile.SetColHidden Method

Overloads

TExcelFile.SetColHidden(Integer, Boolean)

Hides or shows a specific column. Note: If you are hiding many columns at the same time, you can call SetColHidden(Integer, Integer, Boolean) as it is faster.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColHidden(const col: Integer; const hide: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const col Integer Column index (1 based).
const hide Boolean If true, column will be hidden, if false it will be visible.

See also

TExcelFile.SetColHidden(Integer, Integer, Boolean)

Hides or shows a range of columns.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColHidden(const col1: Integer; const col2: Integer; const hide: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const col1 Integer Column index of the first column in the range. (1 based)
const col2 Integer Column index of the last column in the range. (1 based)
const hide Boolean If true, column will be hidden, if false it will be visible.

See also