TXlsFile.SetColHidden Method

Overloads

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

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetColHidden(const col: Integer; const hide: Boolean); overload; override;

<->	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.

Hides or shows a range of columns.

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetColHidden(const col1: Integer; const col2: Integer; const hide: Boolean); overload; override;

<->	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.