Note by: user@example.com
Thanks for the ' $workbook->setVersion(8); ' tip. It really solved my problem, now I can export long strings into cells for .csv files!!
Note by: user@example.com
For working on strings longer than 255 chars:
$workbook->setVersion(8); // Use Excel97/2000 Format
$worksheet->writeString(0, 0, $str);
Note by: marisa@datasmithconsulting.net
Is there any way around the 255 limit on a cell? If I have a file open in Excel, I can paste more than 255 characters into a cell, but I can't seem to accomplish this when generating a spreadsheet with this package. I could do it as a Note, but I really want to have the text in a cell.
Note by: basstradamus@trygues.com
To break a line use: $twoLines = "line1".chr(10)."line2".
Note by: chris@chris-hughes.net
You need to define a wrap format for Excel
e.g.
$wrap_format =& $xls->addFormat();
$wrap_format->setTextWrap();
$sheet->writeString(0,4,"Count \n Items, $wrap_format");
Note by: kirh
Hi,
just write \x0a for the new line.
Note by: mrjoops@yahoo.no
I tried to write a string with some line breaks in. So I add some "\n" to my string.
The result in Openoffice looks exactly like I want, however in Excel, all the text appear on the same line but when I edit the cell, the text appears with the line breaks and I have to effectively "enter" the edited text to make it display correctly on the worksheet.
Is there a method to make the text display correctly on Excel opening ?
mrjoops linebreak question: Try including DOS-style line breaks. Instead of adding the newline character ("\n") to your string, try adding the CARRIAGE-RETURN/NEWLINE character pair ("\r\n").
| 