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


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > ITables Interface > Add Method : Add(IRange,YesNoGuess,String,String) Method
An IRange objbect indicates the data source.
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 srcRange As IRange, _
   Optional ByVal tableHasHeaders As YesNoGuess, _
   Optional ByVal tableStyle As String, _
   Optional ByVal name As String _
) As ITable
'Usage
 
Dim instance As ITables
Dim srcRange As IRange
Dim tableHasHeaders As YesNoGuess
Dim tableStyle As String
Dim name As String
Dim value As ITable
 
value = instance.Add(srcRange, tableHasHeaders, tableStyle, name)

Parameters

srcRange
An IRange objbect indicates the data source.
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