[Excel-Spreadsheet-Writer] Problem with Numbers
| From: | Webmaster | Date: | Fri, 29 Apr 2005 01:42:54 +0000 |
| Subject: | [Excel-Spreadsheet-Writer] Problem with Numbers | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-19008@lists.php.net to get a copy of this message | ||
Hi,
I am using Excel-Spreadsheet-Writer(ESW) sucsessfully for outputting data
from a Database to Excel and it works fine by now, with 1 exeption.
I have a lot of "strings" in the Database that look like a Number with 1 or
more 0 in front of it.
For example 0012122 or 010000.
Now that comes out as 12122 and 10000 in the Excel Sheet, wich is wrong.
I wonder if ist possible to tell the ESW that it should use text as cell
format, not standard, so it prints out the missing 0's.
I tried $worksheet->writestring(0, $key, $farr[1]); but that also brings
out the above problem.
I havent found anything in the documentation about that, probably you can
help me.
Thank you very much
Mirco Blitz