XlsFile.SetColFormat Method

Overloads

• XlsFile.SetColFormat(Int32, Int32, Boolean)
• XlsFile.SetColFormat(Int32, Int32, Int32, Boolean)
• XlsFile.SetColFormat(Int32, TFlxFormat, TFlxApplyFormat, Boolean)

XlsFile.SetColFormat(Int32, Int32, Boolean)

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

Syntax

Namespace: FlexCel.XlsAdapter

public override void SetColFormat(Int32 col, Int32 XF, Boolean resetColumn)

Parameters

<->	Parameter	Type	Description
	col	Int32	Column to set.
	XF	Int32	XF Format index.
	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

• XlsFile

XlsFile.SetColFormat(Int32, Int32, Int32, Boolean)

Sets the format for a range of columns.

Syntax

Namespace: FlexCel.XlsAdapter

public override void SetColFormat(Int32 col1, Int32 col2, Int32 XF, Boolean resetColumn)

Parameters

<->	Parameter	Type	Description
	col1	Int32	First column in the range to set.
	col2	Int32	Last column in the range to set.
	XF	Int32	XF Format index.
	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

• XlsFile

XlsFile.SetColFormat(Int32, TFlxFormat, TFlxApplyFormat, Boolean)

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

Syntax

Namespace: FlexCel.XlsAdapter

public override void SetColFormat(Int32 col, TFlxFormat newFormat, TFlxApplyFormat applyNewFormat, Boolean resetColumn)

Parameters

<->	Parameter	Type	Description
	col	Int32	Column to set.
	newFormat	TFlxFormat	Format to apply.
	applyNewFormat	TFlxApplyFormat	Indicates which properties of newFormat will be applied to the cells.
	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

• XlsFile