corelibraries-devexpress-dot-export-dot-xl-b481c433.md
A collection of columns in a table.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public interface IXlTableColumnCollection :
IXlReadonlyCollection<IXlTableColumn>,
IEnumerable<IXlTableColumn>,
IEnumerable
Public Interface IXlTableColumnCollection
Inherits IXlReadonlyCollection(Of IXlTableColumn),
IEnumerable(Of IXlTableColumn),
IEnumerable
The following members return IXlTableColumnCollection objects:
The IXlTableColumnCollection collection contains the IXlTableColumn objects and is populated automatically when you start generating a table by calling the IXlRow.BeginTable method.
To access a collection of table columns, use the IXlTable.Columns property. An individual table column represented by an IXlTableColumn object can be accessed by its name or zero-based index in the IXlTableColumnCollection collection.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples
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);
// Specify the total row label.
table.Columns[0].TotalRowLabel = "Total";
// Specify the function to calculate the total.
table.Columns[2].TotalRowFunction = XlTotalRowFunction.Sum;
// Specify the number format for the "Amount" column and its total cell.
XlNumberFormat accounting = @"_([$$-409]* #,##0.00_);_([$$-409]* \(#,##0.00\);_([$$-409]* ""-""??_);_(@_)";
table.Columns[2].DataFormatting = accounting;
table.Columns[2].TotalRowFormatting = accounting;
}
// 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);
using (IXlRow row = sheet.CreateRow())
row.BulkCells(new object[] { "Ravioli Angelo", "Grains/Cereals", 12500 }, null);
// Create the total row and finish the table.
using (IXlRow row = sheet.CreateRow())
row.EndTable(table, true);
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)
' Specify the total row label.
table.Columns(0).TotalRowLabel = "Total"
' Specify the function to calculate the total.
table.Columns(2).TotalRowFunction = XlTotalRowFunction.Sum
' Specify the number format for the "Amount" column and its total cell.
Dim accounting As XlNumberFormat = "_([$$-409]* #,##0.00_);_([$$-409]* \(#,##0.00\);_([$$-409]* ""-""??_);_(@_)"
table.Columns(2).DataFormatting = accounting
table.Columns(2).TotalRowFormatting = accounting
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
Using row As IXlRow = sheet.CreateRow()
row.BulkCells(New Object() { "Ravioli Angelo", "Grains/Cereals", 12500 }, Nothing)
End Using
' Create the total row and finish the table.
Using row As IXlRow = sheet.CreateRow()
row.EndTable(table, True)
End Using
See Also
IXlTableColumnCollection Members
Use the Excel Export API to Create a Table
Use the Excel Export API to Apply a Table Style
Use the Excel Export API to Apply Custom Formatting to a Table