IXlTableStyleInfo.Name Property

Gets or sets the name of the built-in style applied to a table.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

string Name { get; set; }

VB.NET

Property Name As String

Property Value

Type	Description
String	A string specifying the built-in table style name.

Remarks

Use this property to apply one of the Microsoft® Excel® built-in table styles to the table. Note that the built-in table style names can be obtained as constant fields of the XlBuiltInTableStyleId class.

If the style name is not valid, the table will be formatted using the None table style that specifies no formatting for the table.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

TableActions.cs

IXlTable table;
// Specify an array containing column headings for a table.
string[] columnNames = new string[] { "Product", "Category", "Amount" };

// Create the first row in the worksheet from which the table starts.
using (IXlRow row = sheet.CreateRow())
{
    // Start generating the table with a header row displayed.
    table = row.BeginTable(columnNames, true);

    // Apply the table style.
    table.Style.Name = XlBuiltInTableStyleId.Dark7;
}

// Generate table rows and populate them with data.
using (IXlRow row = sheet.CreateRow())
    row.BulkCells(new object[] { "Camembert Pierrot", "Dairy Products", 17000 }, null);
using (IXlRow row = sheet.CreateRow())
    row.BulkCells(new object[] { "Gnocchi di nonna Alice", "Grains/Cereals", 15500 }, null);
using (IXlRow row = sheet.CreateRow())
    row.BulkCells(new object[] { "Mascarpone Fabioli", "Dairy Products", 15000 }, null);
// Create the last table row and finish the table.
// The total row is not displayed for the table. 
using (IXlRow row = sheet.CreateRow())
{
    row.BulkCells(new object[] { "Ravioli Angelo", "Grains/Cereals", 12500 }, null);
    row.EndTable(table, false);
}

TableActions.vb

Dim table As IXlTable
' Specify an array containing column headings for a table.
Dim columnNames() As String = { "Product", "Category", "Amount" }

' Create the first row in the worksheet from which the table starts.
Using row As IXlRow = sheet.CreateRow()
    ' Start generating the table with a header row displayed.
    table = row.BeginTable(columnNames, True)

    ' Apply the table style.
    table.Style.Name = XlBuiltInTableStyleId.Dark7
End Using

' Generate table rows and populate them with data.
Using row As IXlRow = sheet.CreateRow()
    row.BulkCells(New Object() { "Camembert Pierrot", "Dairy Products", 17000 }, Nothing)
End Using
Using row As IXlRow = sheet.CreateRow()
    row.BulkCells(New Object() { "Gnocchi di nonna Alice", "Grains/Cereals", 15500 }, Nothing)
End Using
Using row As IXlRow = sheet.CreateRow()
    row.BulkCells(New Object() { "Mascarpone Fabioli", "Dairy Products", 15000 }, Nothing)
End Using
' Create the last table row and finish the table.
' The total row is not displayed for the table. 
Using row As IXlRow = sheet.CreateRow()
    row.BulkCells(New Object() { "Ravioli Angelo", "Grains/Cereals", 12500 }, Nothing)
    row.EndTable(table, False)
End Using

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Name property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-data-grid-export-data-to-native-excel-table/CS/WpfApplication80/MainWindow.xaml.cs#L30

void options_BeforeExportTable(BeforeExportTableEventArgs e) {
    e.Table.Style.Name = XlBuiltInTableStyleId.Light4;
}

VB.NET

wpf-data-grid-export-data-to-native-excel-table/VB/WpfApplication80/MainWindow.xaml.vb#L31

Private Sub options_BeforeExportTable(ByVal e As BeforeExportTableEventArgs)
    e.Table.Style.Name = XlBuiltInTableStyleId.Light4
End Sub