Add Method

Add(int, int, int, int, YesNoGuess, string, string)

Creates the ITable at the specified cell range.

Declaration

ITable Add(int row, int column, int row2, int column2, YesNoGuess tableHasHeaders = YesNoGuess.Guess, string tableStyle = null, string name = null)

Function Add(row As Integer, column As Integer, row2 As Integer, column2 As Integer, Optional tableHasHeaders As YesNoGuess = YesNoGuess.Guess, Optional tableStyle As String = Nothing, Optional name As String = Nothing) As ITable

Parameters

Type	Name	Description
int	row	An integer value indicates the top row index.
int	column	An integer value indicates the left column index.
int	row2	An integer value indicates the bottom row index.
int	column2	An integer value indicates the right column index.
YesNoGuess	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: Guess.
string	tableStyle	A string value indicates the table style. Default value is TableStyleMedium2.
string	name	A string value indicates the table name. If you won't provide, table name will be generated automatically.

Returns

Type	Description
ITable	A GrapeCity.Spreadsheet.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.

Add(string, YesNoGuess, string, string)

Creates the ITable at the specified cell range.

Declaration

ITable Add(string srcRange, YesNoGuess tableHasHeaders = YesNoGuess.Guess, string tableStyle = null, string name = null)

Function Add(srcRange As String, Optional tableHasHeaders As YesNoGuess = YesNoGuess.Guess, Optional tableStyle As String = Nothing, Optional name As String = Nothing) As ITable

Parameters

Type	Name	Description
string	srcRange	An A1-style notation address indicates the data source.
YesNoGuess	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: Guess.
string	tableStyle	A string value indicates the table style. Default value is TableStyleMedium2.
string	name	A string value indicates the table name. If you won't provide, table name will be generated automatically.

Returns

Type	Description
ITable	A GrapeCity.Spreadsheet.Table value represents the created table. `null` if the table cannot be created.

Remarks

Add(IRange, YesNoGuess, string, string)

Creates the ITable at the specified cell range.

Declaration

ITable Add(IRange srcRange, YesNoGuess tableHasHeaders = YesNoGuess.Guess, string tableStyle = null, string name = null)

Function Add(srcRange As IRange, Optional tableHasHeaders As YesNoGuess = YesNoGuess.Guess, Optional tableStyle As String = Nothing, Optional name As String = Nothing) As ITable

Parameters

Type	Name	Description
IRange	srcRange	An IRange objbect indicates the data source.
YesNoGuess	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: Guess.
string	tableStyle	A string value indicates the table style. Default value is TableStyleMedium2.
string	name	A string value indicates the table name. If you won't provide, table name will be generated automatically.

Returns

Type	Description
ITable	A GrapeCity.Spreadsheet.Table value represents the created table. `null` if the table cannot be created.