ExcelFile.SetColFormat Method
Overloads
- ExcelFile.SetColFormat(Int32, Int32)
- ExcelFile.SetColFormat(Int32, Int32, Boolean)
- ExcelFile.SetColFormat(Int32, Int32, Int32)
- ExcelFile.SetColFormat(Int32, Int32, Int32, Boolean)
- ExcelFile.SetColFormat(Int32, TFlxFormat, TFlxApplyFormat, Boolean)
ExcelFile.SetColFormat(Int32, Int32)
Sets the format for an entire column.
Syntax
Namespace: FlexCel.Core
public void SetColFormat(Int32 col, Int32 XF)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
col | Int32 | Column to set. | |
XF | Int32 | XF Format index. |
See also
ExcelFile.SetColFormat(Int32, Int32, Boolean)
Sets the format for an entire column. If you want to set the format for more than one column, use SetColFormat(Int32, Int32, Int32, Boolean) instead.
Syntax
Namespace: FlexCel.Core
public abstract 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
ExcelFile.SetColFormat(Int32, Int32, Int32)
Sets the format for a range of columns.
Syntax
Namespace: FlexCel.Core
public void SetColFormat(Int32 col1, Int32 col2, Int32 XF)
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. |
See also
ExcelFile.SetColFormat(Int32, Int32, Int32, Boolean)
Sets the format for a range of columns.
Syntax
Namespace: FlexCel.Core
public abstract 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
ExcelFile.SetColFormat(Int32, TFlxFormat, TFlxApplyFormat, Boolean)
Sets the format characteristics specified in ApplyFormat for the entire column.
Syntax
Namespace: FlexCel.Core
public abstract 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. |