XmlMappedRange.Text Property
Gets the text for the XmlMappedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property Text As Object
Get
Object Text { get; }
Property Value
Type: System.Object
The text for the XmlMappedRange control.
Examples
The following code example compares how the Text and Value2 properties differ for cells that contain formatted numbers. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.
Private Sub CompareTextAndValue2()
Me.CustomerAddress1Cell.Value2 = 1198.3
Me.CustomerAddress1Cell.NumberFormat = "$#,##0"
' Displays "1198.3".
MsgBox("The Value2 value is: " & Me.CustomerAddress1Cell.Value2.ToString())
' Displays "$1,198".
MsgBox("The Text value is: " & Me.CustomerAddress1Cell.Text.ToString())
End Sub
private void CompareTextAndValue2()
{
this.CustomerAddress1Cell.Value2 = 1198.3;
this.CustomerAddress1Cell.NumberFormat = "$#,##0";
// Displays "1198.3".
MessageBox.Show("The Value2 value is: " +
this.CustomerAddress1Cell.Value2.ToString());
// Displays "$1,198".
MessageBox.Show("The Text value is: " +
this.CustomerAddress1Cell.Text.ToString());
}
.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.