Add(IRange,YesNoGuess,String,String) Method

In This Topic

Creates the ITable at the specified cell range.

Syntax

Visual Basic
C#

'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)

ITable Add( 
   IRange srcRange,
   YesNoGuess tableHasHeaders,
   string tableStyle,
   string 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.

Reference

ITables Interface
ITables Members
Overload List

Product Support Forum | Print this page