Set serials properties to specified columns.
Syntax
'Declaration
Sub SetColumnInfo( _
ByVal As Short, _
ByVal columnFirst As Short, _
ByVal columnLast As Short, _
ByVal As Short, _
ByVal As Double, _
ByVal As Boolean, _
ByVal As Byte, _
ByVal As Boolean _
)
'Usage
Dim instance As IExcelReader
Dim sheet As Short
Dim columnFirst As Short
Dim columnLast As Short
Dim formatIndex As Short
Dim width As Double
Dim hidden As Boolean
Dim outlineLevel As Byte
Dim collapsed As Boolean
instance.SetColumnInfo(sheet, columnFirst, columnLast, formatIndex, width, hidden, outlineLevel, collapsed)
Parameters
- sheet
- The zero based sheet index used to locate the IExcelWorksheet instance
- columnFirst
- The zero based first column index
- columnLast
- The zero based last column index
- formatIndex
- The zero based index used to locate format settings stored in a global section
- width
- The column width
- hidden
- A flag used to indicate whether the column is hidden
- outlineLevel
- A byte value used to set the column outline level.
- collapsed
- A flag used to indicate whether the column is collapsed.
See Also