|Problems? Is your data what you think it is?|
Spreadsheet::WriteExcel: How to create a line breaks in a single cell?by pat_mc (Pilgrim)
|on Sep 22, 2011 at 15:47 UTC||Need Help??|
pat_mc has asked for the
wisdom of the Perl Monks concerning the following question:
I have finally given Spreadsheet::WriteExcel a chance and am liking it a lot. Basically, I am populating cells like so:
$worksheet1 -> write( $row, $column, "$content", $format );
There was one thing, however, I was unable to do: I want to include a line break between entries in a single cell. In Excel, this would be done with ALT + ENTER ... but I have no idea what to write into a cell using Spreadsheet::WriteExcel. I already tried
$cell = "Line \n Line"
but that didn't work.
Anyone got any help for me?
Thanks in advance and kind regards -