Re: text format problem with spreadsheet_excel_writer
| From: | Valery Krizhevich | Date: | Wed, 15 Dec 2004 13:57:43 +0000 |
| Subject: | Re: text format problem with spreadsheet_excel_writer | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16256@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Francisc Simon" <franciscsimon@yahoo.de>
To: "Valery Krizhevich" <krizhevich@metalurgs.lv>
Cc: <pear-general@lists.php.net>
Sent: Wednesday, December 15, 2004 12:36 PM
Subject: [PEAR] text format problem with spreadsheet_excel_writer
> Hi,
>
> I haven an nice problem with
> spreadsheet_excel_writer,
> I want to write the number 0145 in a cell but i get
> always the number 145 so how can i write 0145 ?
Hello,
do like this:
$worksheet->write(0, 0, 'Name');
$worksheet->write(0, 1, 'Age');
$worksheet->write(1, 0, 'John Smith');
$worksheet->writeString(1, 1, "030");
$worksheet->write(2, 0, 'Johann Schmidt');
$worksheet->write(2, 1, 31);
$worksheet->write(3, 0, 'Juan Herrera');
$worksheet->write(3, 1, 32);
set alignment using addformat, and I hope, it will do.
You're welcome,
Valeriy Krizhevich