Xceed Workbooks for .NET v2.0 Documentation
Add(String,Int32,Int32,Int32,Int32,TableStyle,Boolean) Method


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > TableCollection Class > Add Method : Add(String,Int32,Int32,Int32,Int32,TableStyle,Boolean) Method
The name of the table.
The Id for the first row of the range of cells that defines the table.
The Id for the first column of the range of cells that defines the table.
The Id for the last row of the range of cells that defines the table.
The Id for the last column of the range of cells that defines the table.
The built-in style used to format the new table. The default style is TableStyleLight9.
Determines if the header row should be displayed. The default setting is true.
Adds a new Table to the TableCollection using its name and a range of cells defined by indexes. The indexes start at (0, 0).
Syntax
'Declaration
 
Public Overloads Function Add( _
   ByVal tableName As String, _
   ByVal startRowId As Integer, _
   ByVal startColumnId As Integer, _
   ByVal endRowId As Integer, _
   ByVal endColumnId As Integer, _
   Optional ByVal tableStyle As TableStyle, _
   Optional ByVal showHeaderRow As Boolean _
) As Table
'Usage
 
Dim instance As TableCollection
Dim tableName As String
Dim startRowId As Integer
Dim startColumnId As Integer
Dim endRowId As Integer
Dim endColumnId As Integer
Dim tableStyle As TableStyle
Dim showHeaderRow As Boolean
Dim value As Table
 
value = instance.Add(tableName, startRowId, startColumnId, endRowId, endColumnId, tableStyle, showHeaderRow)

Parameters

tableName
The name of the table.
startRowId
The Id for the first row of the range of cells that defines the table.
startColumnId
The Id for the first column of the range of cells that defines the table.
endRowId
The Id for the last row of the range of cells that defines the table.
endColumnId
The Id for the last column of the range of cells that defines the table.
tableStyle
The built-in style used to format the new table. The default style is TableStyleLight9.
showHeaderRow
Determines if the header row should be displayed. The default setting is true.

Return Value

The Table added to the TableCollection.
Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

TableCollection Class
TableCollection Members
Overload List