AW: [PEAR] [Excel-Spreadsheet-Writer] Problem with Numbers

Hi, sorry to say so, but that didn't work it out. Best regards Mirco Blitz ----- Original Message ----- From: "Webmaster" <webmaster@lindworm.de> To: <pear-general@lists.php.net> Sent: Thursday, April 28, 2005 7:42 PM Subject: [PEAR] [Excel-Spreadsheet-Writer] Problem with Numbers > 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. > When working in excel, you would enter '0012122 (note the single quote.) to leave the leading zeros and have the number regarded as text. Does the same thing apply here? Ray > 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 > > -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php