Partager via


_QueryTable.AdjustColumnWidth Property

True if the column widths are automatically adjusted for the best fit each time you refresh the specified query table or XML map. False if the column widths aren’t automatically adjusted with each refresh. The default value is True. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property AdjustColumnWidth As Boolean
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As Boolean

value = instance.AdjustColumnWidth

instance.AdjustColumnWidth = value
bool AdjustColumnWidth { get; set; }

Property Value

Type: System.Boolean

Remarks

The maximum column width is two-thirds the width of the screen.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace