Udostępnij za pośrednictwem


XmlMappedRange.HorizontalAlignment Property (2007 System)

Gets or sets the horizontal alignment for the XmlMappedRange control.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property HorizontalAlignment As Object
'Usage
Dim instance As XmlMappedRange 
Dim value As Object 

value = instance.HorizontalAlignment

instance.HorizontalAlignment = value
[BrowsableAttribute(false)]
public Object HorizontalAlignment { get; set; }
[BrowsableAttribute(false)]
public:
property Object^ HorizontalAlignment {
    Object^ get ();
    void set (Object^ value);
}
public function get HorizontalAlignment () : Object 
public function set HorizontalAlignment (value : Object)

Property Value

Type: System.Object
One of the XlHAlign values.

Remarks

Some of the XlHAlign 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 HorizontalAlignment and VerticalAlignment properties to align the contents of XmlMappedRange to the bottom right. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

Private Sub AlignBottomRight()
    Me.CustomerLastNameCell.HorizontalAlignment = _
        Excel.XlHAlign.xlHAlignRight
    Me.CustomerLastNameCell.VerticalAlignment = _
        Excel.XlVAlign.xlVAlignBottom
    Me.CustomerLastNameCell.Value2 = "The contents " & _
        "of this cell are aligned to the bottom right." 
    Me.CustomerLastNameCell.RowHeight = 100
    Me.CustomerLastNameCell.ColumnWidth = 75
End Sub
private void AlignBottomRight()
{
    this.CustomerLastNameCell.HorizontalAlignment = 
        Excel.XlHAlign.xlHAlignRight;
    this.CustomerLastNameCell.VerticalAlignment =
        Excel.XlVAlign.xlVAlignBottom;

    this.CustomerLastNameCell.Value2 = "The contents " +
        "of this cell are aligned to the bottom right.";
    this.CustomerLastNameCell.RowHeight = 100;
    this.CustomerLastNameCell.ColumnWidth = 75;
}

.NET Framework Security

See Also

Reference

XmlMappedRange Class

XmlMappedRange Members

Microsoft.Office.Tools.Excel Namespace