HotXLS Docs
Home Contents Overview

Orientation property

The text orientation. Can be an Integer value from - 90 to 90 degrees or xlVertical. Read/write OleVariant.

Syntax

property Orientation: OleVariant;

Example

This example sets orientation property for the merged ranges A1:A5 and B1:B5 

With Workbook.Sheets[1].Range['A1','A5'] do begin
  Merge;
  Value := 'Text';
  Orientation := 90;
end;

With Workbook.Sheets[1].Range['B1','B5'] do begin
  Merge;
  Value := 'Vertical';
  Orientation := xlVertical;
end;