TExcelFile.SetColWidth Method

Overloads

• TExcelFile.SetColWidth(Integer, Integer)
• TExcelFile.SetColWidth(Integer, Integer, Integer)

TExcelFile.SetColWidth(Integer, Integer)

Sets the current Column width, in Excel internal units. (Character width of font 0 / 256) Note: if possible, set many column widths at once by calling SetColWidth(Integer, Integer, Integer). It is faster. See Excel Internal Units for more information in Excel internal units.

Remarks

Use TExcelMetrics.ColMult to convert the internal units to pixels.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColWidth(const col: Integer; const width: Integer); overload; virtual; abstract;

Parameters

<->	Parameter	Type	Description
const	col	Integer	Column index (1 based)
const	width	Integer	Column width, in Excel internal units. (Character width of font 0 / 256). See TExcelMetrics.ColMult

Examples

  ColWidthInPixels := xls.GetColWidth(Col) / TExcelMetrics.ColMult(xls);

See also

• TExcelFile

TExcelFile.SetColWidth(Integer, Integer, Integer)

Sets the width of a range of columns, in Excel internal units. (Character width of font 0 / 256) See Excel Internal Units for more information in Excel internal units.

Remarks

Use TExcelMetrics.ColMult to convert the internal units to pixels.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.SetColWidth(const col1: Integer; const col2: Integer; const width: Integer); 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	width	Integer	Column width, in Excel internal units. (Character width of font 0 / 256). See TExcelMetrics.ColMult

Examples

  ColWidthInPixels := xls.GetColWidth(Col) / TExcelMetrics.ColMult(xls);

See also

• TExcelFile