using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    // Access the table collection.
    TableCollection tables = workbook.Worksheets[0].Tables;

    // Access the first table in the collection.
    Table table1 = tables[0];
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    ' Access the table collection.
    Dim tables As TableCollection = workbook.Worksheets(0).Tables

    ' Access the first table in the collection.
    Dim table1 As Table = tables(0)
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];

    // Access the table collection.
    TableCollection tables = worksheet.Tables;

    // Return tables contained in the "B2:F7" cell range.
    CellRange range = worksheet.Range["B2:F7"];
    IList<Table> tablesFromRange = tables.GetTables(range);
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)

    ' Access the table collection.
    Dim tables As TableCollection = worksheet.Tables

    ' Return tables contained in the "B2:F7" cell range.
    Dim range As CellRange = worksheet.Range("B2:F7")
    Dim tablesFromRange As IList(Of Table) = tables.GetTables(range)
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];

    // Specify a cell range that contains table data.
    CellRange range = worksheet["B2:F6"];

    // Insert a table with the default headers.
    Table table = worksheet.Tables.Add(range, false);
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)

    ' Specify a cell range that contains table data.
    Dim range As CellRange = worksheet("B2:F6")

    ' Insert a table with the default headers.
    Dim table As Table = worksheet.Tables.Add(range, False)
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];

    // Obtain table columns and specify their names.
    TableColumn productColumn = table.Columns[0];
    productColumn.Name = "Product";
    TableColumn priceColumn = table.Columns[1];
    priceColumn.Name = "Price";
    TableColumn quantityColumn = table.Columns[2];
    quantityColumn.Name = "Quantity";
    TableColumn discountColumn = table.Columns[3];
    discountColumn.Name = "Discount";
    TableColumn amountColumn = table.Columns[4]; 
    amountColumn.Name = "Amount";
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)

    ' Obtain table columns and specify their names.
    Dim productColumn As TableColumn = table.Columns(0)
    productColumn.Name = "Product"
    Dim priceColumn As TableColumn = table.Columns(1)
    priceColumn.Name = "Price"
    Dim quantityColumn As TableColumn = table.Columns(2)
    quantityColumn.Name = "Quantity"
    Dim discountColumn As TableColumn = table.Columns(3)
    discountColumn.Name = "Discount"
    Dim amountColumn As TableColumn = table.Columns(4)
    amountColumn.Name = "Amount"
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];
    // Return the "Amount" table column.
    TableColumn amountColumn = table.Columns[4];

    // Specify the formula to calculate the amount for each product 
    // and display the result in the "Amount" column.
    amountColumn.Formula = "=[Price]*[Quantity]*(1-[Discount])";
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)
    ' Return the "Amount" table column.
    Dim amountColumn As TableColumn = table.Columns(4)

    ' Specify the formula to calculate the amount for each product 
    ' and display the result in the "Amount" column.
    amountColumn.Formula = "=[Price]*[Quantity]*(1-[Discount])"
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];
    // Return the "Discount" column.
    TableColumn discountColumn = table.Columns[3];
    // Return the "Amount" column.
    TableColumn amountColumn = table.Columns[4];

    // Display the total row for the table.
    table.ShowTotals = true;

    // Use the SUM function to calculate the total value for the "Amount" column.
    discountColumn.TotalRowLabel = "Total";
    amountColumn.TotalRowFunction = TotalRowFunction.Sum;
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)
    ' Return the "Discount" column.
    Dim discountColumn As TableColumn = table.Columns(3)
    ' Return the "Amount" column.
    Dim amountColumn As TableColumn = table.Columns(4)

    ' Display the total row for the table.
    table.ShowTotals = True

    ' Use the SUM function to calculate the total value for the "Amount" column.
    discountColumn.TotalRowLabel = "Total"
    amountColumn.TotalRowFunction = TotalRowFunction.Sum
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];
    // Return the "Price" column.
    TableColumn priceColumn = table.Columns[1];
    // Return the "Discount" column.
    TableColumn discountColumn = table.Columns[3];
    // Return the "Amount" column.
    TableColumn amountColumn = table.Columns[4];

    // Specify the number format for each column.
    priceColumn.DataRange.NumberFormat = "$#,##0.00";
    discountColumn.DataRange.NumberFormat = "0.0%";
    amountColumn.Range.NumberFormat = "$#,##0.00;$#,##0.00;\"\";@";

    // Specify horizontal alignment for the header and total rows.
    table.HeaderRowRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
    table.TotalRowRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

    // Specify horizontal alignment 
    // for all columns except the first column.
    for (int i = 1; i < table.Columns.Count; i++) {
        table.Columns[i].DataRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
    }

    // Set the width of table columns.
    table.Range.ColumnWidthInCharacters = 10;
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)
    ' Return the "Price" column.
    Dim priceColumn As TableColumn = table.Columns(1)
    ' Return the "Discount" column.
    Dim discountColumn As TableColumn = table.Columns(3)
    ' Return the "Amount" column.
    Dim amountColumn As TableColumn = table.Columns(4)

    ' Specify the number format for each column.
    priceColumn.DataRange.NumberFormat = "$#,##0.00"
    discountColumn.DataRange.NumberFormat = "0.0%"
    amountColumn.Range.NumberFormat = "$#,##0.00;$#,##0.00;"""";@"

    ' Specify horizontal alignment for the header and total rows.
    table.HeaderRowRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center
    table.TotalRowRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center

    ' Specify horizontal alignment 
    ' for all columns except the first column.
    For i As Integer = 1 To table.Columns.Count - 1
        table.Columns(i).DataRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center
    Next i

    ' Set the width of table columns.
    table.Range.ColumnWidthInCharacters = 10
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];

    // Access the workbook's collection of table styles.
    TableStyleCollection tableStyles = workbook.TableStyles;

    // Access the built-in table style by its Id.
    TableStyle tableStyle = tableStyles[BuiltInTableStyleId.TableStyleDark9];

    // Apply the style to the table.
    table.Style = tableStyle;

    // Enable banded column formatting for the table.
    table.ShowTableStyleRowStripes = false;
    table.ShowTableStyleColumnStripes = true;
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)

    ' Access the workbook's collection of table styles.
    Dim tableStyles As TableStyleCollection = workbook.TableStyles

    ' Access the built-in table style by its Id.
    Dim tableStyle As TableStyle = tableStyles(BuiltInTableStyleId.TableStyleDark9)

    ' Apply the style to the table.
    table.Style = tableStyle

    ' Enable banded column formatting for the table.
    table.ShowTableStyleRowStripes = False
    table.ShowTableStyleColumnStripes = True
End Using

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    Worksheet worksheet = workbook.Worksheets[0];
    // Access a table. 
    Table table = worksheet.Tables[0];

    String styleName = "testTableStyle";

    // If a style with the specified name exists in the collection,
    // apply this style to the table.
    if (workbook.TableStyles.Contains(styleName)) {
            table.Style = workbook.TableStyles[styleName];
    }
    else {
        // Add a new style under the "testTableStyle" name to the table style collection.
        TableStyle customTableStyle = workbook.TableStyles.Add("testTableStyle");

        // Modify table style formatting. 
        // Specify format characteristics for different table elements.
        customTableStyle.BeginUpdate();
        try {
            customTableStyle.TableStyleElements[TableStyleElementType.WholeTable].Font.Color = 
                Color.FromArgb(107, 107, 107);

            // Format the header row. 
            TableStyleElement headerRowStyle = 
                customTableStyle.TableStyleElements[TableStyleElementType.HeaderRow];
            headerRowStyle.Fill.BackgroundColor = Color.FromArgb(64, 66, 166);
            headerRowStyle.Font.Color = Color.White;
            headerRowStyle.Font.Bold = true;

            // Format the total row. 
            TableStyleElement totalRowStyle = 
                customTableStyle.TableStyleElements[TableStyleElementType.TotalRow];
            totalRowStyle.Fill.BackgroundColor = Color.FromArgb(115, 193, 211);
            totalRowStyle.Font.Color = Color.White;
            totalRowStyle.Font.Bold = true;

            // Specify banded row formatting for the table.
            TableStyleElement secondRowStripeStyle = 
                customTableStyle.TableStyleElements[TableStyleElementType.SecondRowStripe];
            secondRowStripeStyle.Fill.BackgroundColor = Color.FromArgb(234, 234, 234);
            secondRowStripeStyle.StripeSize = 1;
        }
        finally {
            customTableStyle.EndUpdate();
        }
        // Apply the custom style to the table.
        table.Style = customTableStyle;
    }
}

Imports DevExpress.Spreadsheet
' ...

Using workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets(0)

    ' Access a table. 
    Dim table As Table = worksheet.Tables(0)

    Dim styleName As String = "testTableStyle"

    ' If a style with the specified name exists in the collection,
    ' apply this style to the table.
    If workbook.TableStyles.Contains(styleName) Then
        table.Style = workbook.TableStyles(styleName)
    Else
        ' Add a new table style under the "testTableStyle" name to the table style collection.
        Dim customTableStyle As TableStyle = workbook.TableStyles.Add("testTableStyle")

        ' Modify table style formatting.
        ' Specify format characteristics for different table elements.
        customTableStyle.BeginUpdate()
        Try
            customTableStyle.TableStyleElements(TableStyleElementType.WholeTable).Font.Color = 
                Color.FromArgb(107, 107, 107)

            ' Format the header row.
            Dim headerRowStyle As TableStyleElement = 
                customTableStyle.TableStyleElements(TableStyleElementType.HeaderRow)
            headerRowStyle.Fill.BackgroundColor = Color.FromArgb(64, 66, 166)
            headerRowStyle.Font.Color = Color.White
            headerRowStyle.Font.Bold = True

            ' Format the total row.
            Dim totalRowStyle As TableStyleElement = 
                customTableStyle.TableStyleElements(TableStyleElementType.TotalRow)
            totalRowStyle.Fill.BackgroundColor = Color.FromArgb(115, 193, 211)
            totalRowStyle.Font.Color = Color.White
            totalRowStyle.Font.Bold = True

            ' Specify banded row formatting for the table.
            Dim secondRowStripeStyle As TableStyleElement = 
                customTableStyle.TableStyleElements(TableStyleElementType.SecondRowStripe)
            secondRowStripeStyle.Fill.BackgroundColor = Color.FromArgb(234, 234, 234)
            secondRowStripeStyle.StripeSize = 1
        Finally
            customTableStyle.EndUpdate()
        End Try
        ' Apply the custom style to the table.
        table.Style = customTableStyle
    End If
End Using