XmlMappedRange.Calculate Method
Calculates the value of the XmlMappedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Function Calculate As Object
Object Calculate()
Return Value
Type: System.Object
Examples
The following code example uses the Calculate method to calculate the value of the formula in the EmployeeSeniorityCellXmlMappedRange control on Sheet1. To run this code example, you must add an XML map to your workbook based on the Employee XML schema and map the schema elements from this XML map to cells on a worksheet. For example, you can use the schema from Walkthrough: Binding Content Controls to Custom XML Parts and modify it by adding a seniority element of type integer to the employee element.
Note
Typically, you populate the XmlMappedRange control from an XML file. This example hard-codes the value of the control for simplicity.
Private Sub CalculateXMLMappedRange()
Globals.Sheet1.EmployeeNameCell.Value2 = "Karina Leal"
Globals.Sheet1.EmployeeHireDateCell.Value2 = "1999-04-01"
Globals.Sheet1.EmployeeTitleCell.Value2 = "Manager"
Dim hireDateCellAddress As String = _
Globals.Sheet1.EmployeeHireDateCell.Cells.Address
Globals.Sheet1.EmployeeSeniorityCell.Value2 = "=YEAR(TODAY())-YEAR(" _
+ hireDateCellAddress + ")"
Globals.Sheet1.EmployeeSeniorityCell.Calculate()
End Sub
private void CalculateXMLMappedRange()
{
Globals.Sheet1.EmployeeNameCell.Value2 = "Karina Leal";
Globals.Sheet1.EmployeeHireDateCell.Value2 = "1999-04-01";
Globals.Sheet1.EmployeeTitleCell.Value2 = "Manager";
string hireDateCellAddress =
Globals.Sheet1.EmployeeHireDateCell.Cells.get_Address(
Excel.XlReferenceStyle.xlA1);
Globals.Sheet1.EmployeeSeniorityCell.Value2 = "=YEAR(TODAY())-YEAR("
+ hireDateCellAddress + ")";
Globals.Sheet1.EmployeeSeniorityCell.Calculate();
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.