TXlsFile.SetColFormat Method
Overloads
- TXlsFile.SetColFormat(Integer, Integer, Boolean)
- TXlsFile.SetColFormat(Integer, Integer, Integer, Boolean)
- TXlsFile.SetColFormat(Integer, TFlxFormat, TFlxApplyFormat, Boolean)
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. |