XlYesNoGuess enumeration

Office 2013 and later

Specifies whether or not the first row contains headers.

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
xlGuessExcel determines whether there’s a header, and to determine where it is, if there is one.
xlNodefault. (The entire range should be sorted).
xlYes(The entire range should not be sorted).

Cannot be used when sorting PivotTable reports.

Show: