GrapeCity.Xaml.Excel
SetColumnInfo Method


GrapeCity.Excel Namespace > IExcelReader Interface : SetColumnInfo Method
The zero based sheet index used to locate the IExcelWorksheet instance
The zero based first column index
The zero based last column index
The zero based index used to locate format settings stored in a global section
The column width
A flag used to indicate whether the column is hidden
A byte value used to set the column outline level.
A flag used to indicate whether the column is collapsed.
Set serials properties to specified columns.
Syntax
'Declaration
 
Sub SetColumnInfo( _
   ByVal sheet As Short, _
   ByVal columnFirst As Short, _
   ByVal columnLast As Short, _
   ByVal formatIndex As Short, _
   ByVal width As Double, _
   ByVal hidden As Boolean, _
   ByVal outlineLevel As Byte, _
   ByVal collapsed 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)
void SetColumnInfo( 
   short sheet,
   short columnFirst,
   short columnLast,
   short formatIndex,
   double width,
   bool hidden,
   byte outlineLevel,
   bool 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

Reference

IExcelReader Interface
IExcelReader Members