[Excel-Spreadsheet-Writer] Problem with Numbers

From: 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

« previous php.pear.general (#19008) next »