Share via


ListObject.DataBoundFormatSettings Property (2007 System)

Gets or sets which FormatSettings of the specified XlRangeAutoFormat are applied to the ListObject control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Property DataBoundFormatSettings As FormatSettings
'Usage
Dim instance As ListObject 
Dim value As FormatSettings 

value = instance.DataBoundFormatSettings

instance.DataBoundFormatSettings = value
public FormatSettings DataBoundFormatSettings { get; set; }
public:
property FormatSettings DataBoundFormatSettings {
    FormatSettings get ();
    void set (FormatSettings value);
}
public function get DataBoundFormatSettings () : FormatSettings 
public function set DataBoundFormatSettings (value : FormatSettings)

Property Value

Type: Microsoft.Office.Tools.Excel.FormatSettings
A bitwise combination of the FormatSettings values.

Remarks

By default, all of the information in the XlRangeAutoFormat style is applied. However, specific items can be removed so that the style is not applied to those items. These items are:

  • Number

  • Font

  • Alignment

  • Border

  • Pattern

  • Width

To apply only selected styles, set DataboundFormatSettings before the DataboundFormat property is set. DataboundFormatSettings will not work if DataboundFormat is already set.

Examples

The following code example creates a DataTable and a ListObject, and binds the ListObject to the DataTable. It then sets the FormatSettings to apply to the ListObject and uses an XlRangeAutoFormat value to supply the format.

This example is for a document-level customization.

Private Sub ListObject_DataBoundFormatSettings()
    ' Create a new DataSet and DataTable. 
    Dim ds As New DataSet()
    Dim dt As DataTable = ds.Tables.Add("Customers")
    dt.Columns.Add(New DataColumn("LastName"))
    dt.Columns.Add(New DataColumn("FirstName"))

    ' Add a new row to the DataTable. 
    Dim dr As DataRow = dt.NewRow()
    dr("LastName") = "Chan"
    dr("FirstName") = "Gareth"
    dt.Rows.Add(dr)

    ' Create a list object. 
    Dim List1 As Microsoft.Office.Tools.Excel.ListObject = _
        Me.Controls.AddListObject(Me.Range( _
        "A1"), "List1")

    ' Bind the list object to the DataTable.
    List1.AutoSetDataBoundColumnHeaders = True
    List1.SetDataBinding(ds, "Customers", _
        "LastName", "FirstName")

    ' Specify the format settings that you want to include. 
    ' In this example, only the Font and Pattern  
    ' settings are applied.
    List1.DataBoundFormatSettings = _
        Microsoft.Office.Tools.Excel.FormatSettings.Font Or _
        Microsoft.Office.Tools.Excel.FormatSettings.Pattern

    ' Add a format to the list object.
    List1.DataBoundFormat = _
        Excel.XlRangeAutoFormat.xlRangeAutoFormatList2

End Sub
private void ListObject_DataBoundFormatSettings()
{
    // Create a new DataSet and DataTable.
    DataSet ds = new DataSet();
    DataTable dt = ds.Tables.Add("Customers");
    dt.Columns.Add(new DataColumn("LastName"));
    dt.Columns.Add(new DataColumn("FirstName"));

    // Add a new row to the DataTable.
    DataRow dr = dt.NewRow();
    dr["LastName"] = "Chan";
    dr["FirstName"] = "Gareth";
    dt.Rows.Add(dr);

    // Create a list object.
    Microsoft.Office.Tools.Excel.ListObject list1 = 
        this.Controls.AddListObject(
        this.Range["A1", missing], "list1");

    // Bind the list object to the DataTable.
    list1.AutoSetDataBoundColumnHeaders = true;
    list1.SetDataBinding(ds, "Customers", "LastName",
        "FirstName");

    // Specify the format settings that you want to include. 
    // In this example, only the Font and Pattern  
    // settings are applied.
    list1.DataBoundFormatSettings =
        Microsoft.Office.Tools.Excel.FormatSettings.Font |
        Microsoft.Office.Tools.Excel.FormatSettings.Pattern;

    // Add a format to the list object.
    list1.DataBoundFormat = 
        Excel.XlRangeAutoFormat.xlRangeAutoFormatList2;
}

.NET Framework Security

See Also

Reference

ListObject Class

ListObject Members

Microsoft.Office.Tools.Excel Namespace