XmlMappedRange.Consolidate(Object, Object, Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Consolidates data from multiple ranges on multiple worksheets into an XmlMappedRange control.

public object Consolidate (object Sources, object Function, object TopRow, object LeftColumn, object CreateLinks);

abstract member Consolidate : obj * obj * obj * obj * obj -> obj

Public Function Consolidate (Optional Sources As Object, Optional Function As Object, Optional TopRow As Object, Optional LeftColumn As Object, Optional CreateLinks As Object) As Object

Parameters

Sources: Object

The sources of the consolidation as an array of text reference strings in R1C1-style notation. The references must include the full path of sheets to be consolidated.

Function: Object

Can be one of the following XlConsolidationFunction constants: xlAverage xlCount xlCountNums xlMax xlMin xlProduct xlStDev xlStDevP xlSum xlVar xlVarP

TopRow: Object

true to consolidate data based on column titles in the top row of the consolidation ranges; false to consolidate data by position. The default value is false.

LeftColumn: Object

true to consolidate data based on row titles in the left column of the consolidation ranges; false to consolidate data by position. The default value is false.

CreateLinks: Object

true to have the consolidation use worksheet links; false to have the consolidation copy the data. The default value is false.

Returns

Object

Examples

The following code example uses the Consolidate method to consolidate the values of cell A1 on Sheet2 and cell A1 on Sheet3 into an XmlMappedRange on Sheet1. The example consolidates the values by adding the values together. This code example assumes that Sheet1 contains an XmlMappedRange named CustomerLastNameCell.

private void ConsolidateCells()
{
    Globals.Sheet2.Range["A1"].Value2 = 1710;
    Globals.Sheet3.Range["A1"].Value2 = 1240;

    string[] source = new string[] { "Sheet2!R1C1", "Sheet3!R1C1" };
    Globals.Sheet1.CustomerAddress1Cell.Consolidate(source, 
        Excel.XlConsolidationFunction.xlSum,
        false, false, false);
}

Private Sub ConsolidateCells()
    Globals.Sheet2.Range("A1").Value2 = 1710
    Globals.Sheet3.Range("A1").Value2 = 1240

    Dim Source As String() = {"Sheet2!R1C1", "Sheet3!R1C1"}
    Globals.Sheet1.CustomerAddress1Cell.Consolidate(Source, _
        Excel.XlConsolidationFunction.xlSum, False, False, False)
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to

Share via