XlYesNoGuess Enumeration

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)

public enum XlYesNoGuess

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.