Partager via


_Worksheet.ConsolidationOptions Property

Returns a three-element array of consolidation options, as shown in the following table. If the element is True, that option is set. Read-only Object.

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

Syntax

'Declaration
ReadOnly Property ConsolidationOptions As Object
    Get
'Usage
Dim instance As _Worksheet
Dim value As Object

value = instance.ConsolidationOptions
Object ConsolidationOptions { get; }

Property Value

Type: System.Object

Remarks

Element

Meaning

1

Use labels in top row.

2

Use labels in left column.

3

Create links to source data.

See Also

Reference

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace