Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / TableCollection Class / Add Method / Add(Int32,Int32,Int32,Int32,TableStyle,Boolean) Method
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.


In This Topic
    Add(Int32,Int32,Int32,Int32,TableStyle,Boolean) Method
    In This Topic
    Adds a new Table to the TableCollection using a range of cells defined by indexes. The indexes start at (0, 0).
    Syntax
    'Declaration
     
    
    Public Overloads Function Add( _
       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 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(startRowId, startColumnId, endRowId, endColumnId, tableStyle, showHeaderRow)

    Parameters

    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