[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

How to wrap text in an Excel cell?

Leshak Leshak

7/2/2008 4:39:00 PM

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.
--
Posted via http://www.ruby-....
4 Answers

Damjan Rems

7/3/2008 5:46:00 AM

0

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.

Here you can find a lot of usefull win32ole tips:
http://rubyonwindows.blo...


by
TheR
--
Posted via http://www.ruby-....

Leshak Leshak

7/3/2008 7:06:00 AM

0

Thanks TheR,
yes i know it's very useful resource but i didn't find any info about
wrapping in excel :(
--
Posted via http://www.ruby-....

David Mullet

7/3/2008 9:54:00 PM

0

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.bl...

http://rubyonwindows.bl.../search/label/excel
--
Posted via http://www.ruby-....

Leshak Leshak

7/4/2008 7:12:00 AM

0

Thanks David!
--
Posted via http://www.ruby-....