Excel Win32ole text rotate

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

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/
http://rubyonwindows.blogspot.com/search/label/excel

David M. wrote in post #1002085:

http://rubyonwindows.blogspot.com/

“Automating Windows Applications with Ruby”

Any news on your book?

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/
http://rubyonwindows.blogspot.com/search/label/excel

Thanks.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs