TXlsFile.SetColFormat Method

Overloads

TXlsFile.SetColFormat(Integer, Integer, Boolean)

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

Syntax

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetColFormat(const col: Integer; const XF: Integer; const resetColumn: Boolean); overload; override;

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

TXlsFile.SetColFormat(Integer, Integer, Integer, Boolean)

Sets the format for a range of columns.

Syntax

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetColFormat(const col1: Integer; const col2: Integer; const XF: Integer; const resetColumn: Boolean); overload; override;

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

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

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

Syntax

Unit: FlexCel.XlsAdapter

procedure TXlsFile.SetColFormat(const col: Integer; const newFormat: TFlxFormat; const applyNewFormat: TFlxApplyFormat; const resetColumn: Boolean); overload; override;

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