Spread Windows Forms 12.0 Product Documentation
Add(Int32,Int32,Int32,Int32,YesNoGuess,String,String) Method


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > ITables Interface > Add Method : Add(Int32,Int32,Int32,Int32,YesNoGuess,String,String) Method
An integer value indicates the top row index.
An integer value indicates the left column index.
An integer value indicates the bottom row index.
An integer value indicates the right column index.
An YesNoGuess constant that indicates whether the data has column labels. If the source range does not contain headers, Spread will automatically generate headers. Default value: YesNoGuess.Guess.
A string value indicates the table style. Default value is TableStyleMedium2.
A string value indicates the table name. If you won't provide, table name will be generated automatically.
Creates the ITable at the specified cell range.
Syntax
'Declaration
 
Overloads Function Add( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal row2 As Integer, _
   ByVal column2 As Integer, _
   Optional ByVal tableHasHeaders As YesNoGuess, _
   Optional ByVal tableStyle As String, _
   Optional ByVal name As String _
) As ITable
'Usage
 
Dim instance As ITables
Dim row As Integer
Dim column As Integer
Dim row2 As Integer
Dim column2 As Integer
Dim tableHasHeaders As YesNoGuess
Dim tableStyle As String
Dim name As String
Dim value As ITable
 
value = instance.Add(row, column, row2, column2, tableHasHeaders, tableStyle, name)
ITable Add( 
   int row,
   int column,
   int row2,
   int column2,
   YesNoGuess tableHasHeaders,
   string tableStyle,
   string name
)

Parameters

row
An integer value indicates the top row index.
column
An integer value indicates the left column index.
row2
An integer value indicates the bottom row index.
column2
An integer value indicates the right column index.
tableHasHeaders
An YesNoGuess constant that indicates whether the data has column labels. If the source range does not contain headers, Spread will automatically generate headers. Default value: YesNoGuess.Guess.
tableStyle
A string value indicates the table style. Default value is TableStyleMedium2.
name
A string value indicates the table name. If you won't provide, table name will be generated automatically.

Return Value

A Table value represents the created table. null if the table cannot be created.
Remarks
When the table has headers, the first row of cells will be converted to Text , if not already set to text. The conversion will be based on the visible text for the cell. This means that if there is a date value with a Date format that changes with locale, the conversion to a list might produce different results depending on the current system locale. Moreover, if there are two cells in the header row that have the same visible text, an incremental Integer will be appended to make each column header unique.
See Also

Reference

ITables Interface
ITables Members
Overload List