Xceed Workbooks for .NET v1.4 Documentation
Add(String,String,String,TableStyle,Boolean) Method


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > TableCollection Class > Add Method : Add(String,String,String,TableStyle,Boolean) Method
The name of the table.
The top-left cell of the range of cells that defines the table.
The bottom-right cell 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 cell addresses.
Syntax
'Declaration

 

Public Overloads Function Add( _

   ByVal tableName As String, _

   ByVal startCellAddress As String, _

   ByVal endCellAddress As String, _

   Optional ByVal tableStyle As TableStyle, _

   Optional ByVal showHeaderRow As Boolean _

) As Table
'Usage

 

Dim instance As TableCollection

Dim tableName As String

Dim startCellAddress As String

Dim endCellAddress As String

Dim tableStyle As TableStyle

Dim showHeaderRow As Boolean

Dim value As Table

 

value = instance.Add(tableName, startCellAddress, endCellAddress, tableStyle, showHeaderRow)

Parameters

tableName
The name of the table.
startCellAddress
The top-left cell of the range of cells that defines the table.
endCellAddress
The bottom-right cell 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