Xceed Workbooks for .NET v1.4 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