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.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.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. |