Table of Contents

TExcelFile.SetColFormat Method

Overloads

TExcelFile.SetColFormat(Integer, Integer)

Sets the format for an entire column.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColFormat(const col: Integer; const XF: Integer); overload;

Parameters

<-> Parameter Type Description
const col Integer Column to set.
const XF Integer XF Format index.

See also

TExcelFile.SetColFormat(Integer, Integer, Boolean)

Sets the format for an entire column. If you want to set the format for more than one column, use SetColFormat(Integer, Integer, Integer, Boolean) instead.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColFormat(const col: Integer; const XF: Integer; const resetColumn: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const col Integer Column to set.
const XF Integer XF Format index.
const resetColumn Boolean When true, all existing cells on the column will be reset to this format.
This is the standard Excel behavior and the recommended option. If you don't care about existing cells, you can speed up this method by setting it to false.

See also

TExcelFile.SetColFormat(Integer, Integer, Integer)

Sets the format for a range of columns.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColFormat(const col1: Integer; const col2: Integer; const XF: Integer); overload;

Parameters

<-> Parameter Type Description
const col1 Integer First column in the range to set.
const col2 Integer Last column in the range to set.
const XF Integer XF Format index.

See also

TExcelFile.SetColFormat(Integer, Integer, Integer, Boolean)

Sets the format for a range of columns.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColFormat(const col1: Integer; const col2: Integer; const XF: Integer; const resetColumn: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const col1 Integer First column in the range to set.
const col2 Integer Last column in the range to set.
const XF Integer XF Format index.
const resetColumn Boolean When true, all existing cells on the column will be reset to this format.
This is the standard Excel behavior and the recommended option. If you don't care about existing cells, you can speed up this method by setting it to false.

See also

TExcelFile.SetColFormat(Integer, TFlxFormat, TFlxApplyFormat, Boolean)

Sets the format characteristics specified in ApplyFormat for the entire column.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColFormat(const col: Integer; const newFormat: TFlxFormat; const applyNewFormat: TFlxApplyFormat; const resetColumn: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const col Integer Column to set.
const newFormat TFlxFormat Format to apply.
const applyNewFormat TFlxApplyFormat Indicates which properties of newFormat will be applied to the cells.
const resetColumn Boolean When true, all existing cells on the column will be reset to this format.
This is the standard Excel behavior and the recommended option. If you don't care about existing cells, you can speed up this method by setting it to false.

See also