cormanaz has asked for the wisdom of the Perl Monks concerning the following question:
Howdy Bros. I'm trying to do two things in Excel 2010 using Win32::OLE and can't find the answer as to how.
1. How do I set the properties of a cell to wrap the text it contains? This would be the equivalent in the Excel UI of right clicking a cell and selecting Format Cells, Alignment tab, check Wrap Text. I tried $Sheet->Range("A1")->{'Alignment'}->{'WrapText'} = "True"; but that throws an error.
2. How do I boldface a single word in a range? I know you can bold a whole cell with $sheet -> Range("A1") -> Font -> {Bold} = "True"; but how do you do it for a single word in a cell?
TIA...
Steve
Back to
Seekers of Perl Wisdom