次の方法で共有


XmlMappedRange.Errors Property

Definition

Gets an Errors object that enables you to access error checking options of an XmlMappedRange control.

public:
 property Microsoft::Office::Interop::Excel::Errors ^ Errors { Microsoft::Office::Interop::Excel::Errors ^ get(); };
public Microsoft.Office.Interop.Excel.Errors Errors { get; }
member this.Errors : Microsoft.Office.Interop.Excel.Errors
Public ReadOnly Property Errors As Errors

Property Value

An Errors object that enables you to access error checking options of an XmlMappedRange control.

Examples

The following code example inserts a number written as text into an XmlMappedRange, and then uses the Errors property to determine whether the number is written as text. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void CheckForErrors()
{
    this.CustomerLastNameCell.Formula = "'12";

    if (this.CustomerLastNameCell.Errors[
        Excel.XlErrorChecks.xlNumberAsText].Value)
    {
         MessageBox.Show("The number is written as text.");
    }
    else
    {
        MessageBox.Show("The number is not written as text.");
    }
}
Private Sub CheckForErrors()
    Me.CustomerLastNameCell.Formula = "'12"

    If Me.CustomerLastNameCell.Errors( _
        Excel.XlErrorChecks.xlNumberAsText).Value Then
        MsgBox("The number is written as text.")
    Else
        MsgBox("The number is not written as text.")
    End If
End Sub

Remarks

Reference the Errors object to view a list of index values associated with error checking options.

Applies to