How to wrap text in an Excel cell?
in [Ruby]
|
Prev: [ANN/ADV] Summer Rails training courses from Ruby Power and Light,in Edison, NJ
Next: Design Pattern for RUBY Beginner Learner
From: Leshak Leshak on 2 Jul 2008 12:39 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-forum.com/.
From: Damjan Rems on 3 Jul 2008 01:45 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.blogspot.com/ by TheR -- Posted via http://www.ruby-forum.com/.
From: Alex ... on 3 Jul 2008 03:05 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-forum.com/.
From: David Mullet on 3 Jul 2008 17:53 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/.
From: Alex ... on 4 Jul 2008 03:11
Thanks David! -- Posted via http://www.ruby-forum.com/. |