XmlMappedRange.ReadingOrder Property

Gets or sets the reading order for the XmlMappedRange control.

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

Syntax

'Declaration
Property ReadingOrder As Integer
    Get
    Set
int ReadingOrder { get; set; }

Property Value

Type: System.Int32
One of the following values: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext.

Remarks

Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed.

Examples

The following code example uses the ReadingOrder property to reverse the reading order of an XmlMappedRange, if the current language that is selected or installed supports it. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub ReverseReadingOrder()
    If Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlRTL Then
        Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlLTR
    Else
        Me.CustomerLastNameCell.ReadingOrder = Excel.Constants.xlRTL
    End If
End Sub
private void ReverseReadingOrder()
{
    if (this.CustomerLastNameCell.ReadingOrder == 
        (int)Excel.Constants.xlRTL)
    {
        this.CustomerLastNameCell.ReadingOrder = 
            (int)Excel.Constants.xlLTR;
    }
    else
    {
        this.CustomerLastNameCell.ReadingOrder = 
            (int)Excel.Constants.xlRTL;
    }
}

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace