pat_mc has asked for the wisdom of the Perl Monks concerning the following question:
Hi, Monks!
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 -
Pat
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 -
Pat
Back to
Seekers of Perl Wisdom