using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;

// Access the table collection.
TableCollection tables = workbook.Worksheets[0].Tables;

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

Imports DevExpress.Spreadsheet
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document

' 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)

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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)

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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)

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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"

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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])"

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
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
' ...

Dim workbook As IWorkbook = spreadsheetControl1.Document
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