XmlMappedRange.HorizontalAlignment Property
Gets or sets the horizontal alignment for the XmlMappedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property HorizontalAlignment As Object
Get
Set
Object HorizontalAlignment { get; set; }
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
- 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.