To bind data to a ListObject control
Create a DataTable at the class level.
Dim table As DataTable = New DataTable("Employees")
System.Data.DataTable table = new System.Data.DataTable("Employees");
Add sample columns and data in the Startup event handler of the Sheet1 class (in a document-level project) or ThisAddIn class (in an application-level project).
table.Columns.Add("FirstName", GetType(String))
table.Columns.Add("LastName", GetType(String))
table.Columns.Add("Title", GetType(String))
table.Rows.Add("Nancy", "Anderson", "Sales Representative")
table.Rows.Add("Robert", "Brown", "Sales Representative")
table.Columns.Add("FirstName", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("Title", typeof(string));
table.Rows.Add("Nancy", "Anderson", "Sales Representative");
table.Rows.Add("Robert", "Brown", "Sales Representative");
Call the SetDataBinding method and pass in the column names in the order they should appear. The order of the columns in the list object can differ from the order in which they appear in the DataTable.
list1.AutoSetDataBoundColumnHeaders = True
list1.SetDataBinding(table, Nothing, "LastName", "FirstName")
list1.AutoSetDataBoundColumnHeaders = true;
list1.SetDataBinding(table, null, "LastName", "FirstName");
To disconnect the ListObject control from the data source
This code example assumes you have an existing ListObject named list1 on the worksheet in which this code appears.
Tasks
Concepts
Other Resources