From: David Mullet <david.mullet@...>
Date: 2008-07-04T06:53:34+09:00
Subject: Re: How to wrap text in an Excel cell?

Alex ... wrote:
> Hello,
> could you pls suggest how i can wrap text in Excel cell (row, column
> also)? I'm using win32ole library for working with excel format.
> Thanks.

Set the WrapText property for the range object in question. Examples:

worksheet.Rows(1).WrapText = true
worksheet.Columns(5).WrapText = true
worksheet.Cells(10, 25).WrapText = true
worksheet.Range("A2:K30").WrapText = true

David

http://rubyonwindows.blogspot.com

http://rubyonwindows.blogspot.com/search/label/excel
-- 
Posted via http://www.ruby-forum.com/.