ListObject.AutoSetDataBoundColumnHeaders Property (2007 System)

Gets or sets a value that determines whether the column headers are automatically set to match the data source.

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

Syntax

'Declaration
Public Property AutoSetDataBoundColumnHeaders As Boolean
'Usage
Dim instance As ListObject 
Dim value As Boolean 

value = instance.AutoSetDataBoundColumnHeaders

instance.AutoSetDataBoundColumnHeaders = value
public bool AutoSetDataBoundColumnHeaders { get; set; }
public:
property bool AutoSetDataBoundColumnHeaders {
    bool get ();
    void set (bool value);
}
public function get AutoSetDataBoundColumnHeaders () : boolean 
public function set AutoSetDataBoundColumnHeaders (value : boolean)

Property Value

Type: System.Boolean
true to automatically set the column names; otherwise, false. The default is false.

Remarks

When set to true, this property causes the column header of each column in the ListObject control to match the corresponding column header of the data source.

The person using the worksheet cannot change the column headers when this property is set to true. If the column header is changed, it will revert back to match the data source when the user shifts focus away from the header cell.

.NET Framework Security

See Also

Reference

ListObject Class

ListObject Members

Microsoft.Office.Tools.Excel Namespace