Worksheet::writeString -- Write a string to the specified row and column (zero indexed).
Description
Write a string to the specified row and column (zero indexed). NOTE: there is an Excel 5 defined limit of 255 characters. $format is optional. Returns 0 : normal termination -1 : insufficient number of arguments -2 : row or column out of range -3 : long string truncated to 255 chars
Parameter
integer $row -
Zero indexed row
integer $col -
Zero indexed column
string $str -
The string to write
mixed $format -
The XF format for the cell
Note
This function can not be called
statically.
|
Worksheet::writeNumber (Previous)
|
(Next) Worksheet::writeNote
|
|
|
Download Documentation
|
Last updated: Sun, 28 Sep 2008 |
|
Do you think that something on this page is wrong? Please file a bug report or add a note.
|
| User Notes: |
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").
|
|
