Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / ITables Interface / Add Method / Add(String,YesNoGuess,String,String) Method
An A1-style notation address 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.


In This Topic
Add(String,YesNoGuess,String,String) Method
In This Topic
Creates the ITable at the specified cell range.
Syntax
'Declaration
 

Overloads Function Add( _
   ByVal srcRange As String, _
   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 String
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 A1-style notation address 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

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page