Excel Win32ole text rotate

Ruby
1

How to rotate the text to 90 degrees on the excel with win32ole?

2

Gavin C. wrote in post #1002041:

How to rotate the text to 90 degrees on the excel with win32ole?

Set the Orientation property of a Cell or Range object to a value
between -90 and 90.

Where ws is your worksheet object:

ws.Range(‘A1:B3’).Orientation = 90
ws.Cells(1,1).Orientation = -90

David

3

David M. wrote in post #1002085:

http://rubyonwindows.blogspot.com/

“Automating Windows Applications with Ruby”

Any news on your book?

4

David M. wrote in post #1002085:

Gavin C. wrote in post #1002041:

How to rotate the text to 90 degrees on the excel with win32ole?

Set the Orientation property of a Cell or Range object to a value
between -90 and 90.

Where ws is your worksheet object:

ws.Range(‘A1:B3’).Orientation = 90
ws.Cells(1,1).Orientation = -90

David

http://rubyonwindows.blogspot.com/
Ruby on Windows: excel

Thanks.