Gets or sets the text orientation for the specified range.
[Visual Basic] Property Orientation As Integer [C#] int Orientation { get; set; } [C++] __property int get_Orientation(); __property void set_Orientation(int ); [JScript] function get Orientation() : int function set Orientation(int);
Can be an integer value from -90 to 90 degrees or one of the XlOrientation values.
This example sets orientation property for the merged ranges A1:A5 and B1:B5
[C#]
IRange range;
range = book.Worksheets[1].Range["A1:A5"];
range.Merge();
range.Value = "Text";
range.Orientation = 90;
range = book.Worksheets[1].Range["B1:B5"];
range.Merge();
range.Value = "Vertical";
range.Orientation = XlOrientation.xlVertical;
[Visual Basic]
Dim range As IRange
range = book.Worksheets(1).Range("A1:A5")
range.Merge()
range.Value = "Text"
range.Orientation = 90
range = book.Worksheets(1).Range("B1:B5")
range.Merge()
range.Value = "Vertical"
range.Orientation = XlOrientation.xlVertical
[C++]
IRange* range;
range = book->Worksheets->Item[1]->Range->Item[S"A1:A5"];
range->Merge();
range->Value = S"Text";
range->Orientation = 90;
range = book->Worksheets->Item[1]->Range->Item[S"B1:B5"];
range->Merge();
range->Value = S"Vertical";
range->Orientation = XlOrientation::xlVertical;
IRange Interface | NativeExcel Namespace | XlOrientation Class