NYCPHP Meetup

[Dell Sala]

Hi Nelly,

Have you looked into PEAR's Spreadsheet_Excel_Writer? I haven't used  
it myself, but perhaps you can have more control over cell types if  
you generate a native excel file rather than a csv file.

http://pear.php.net/package/Spreadsheet_Excel_Writer

-- Dell


On Nov 14, 2006, at 12:32 PM, Nelly Yusupova wrote:

> Hello Everyone,
>
> I wrote an application in PHP to export all of the data into a CSV  
> document
> so my client can view the data.  Everything works great except the  
> Zip Code
> fields.  For the zip codes that start with a zero, the zero is  
> removed.
>
> I know this is done by Excel because it is treating the contents of  
> the cell
> as a number.
>
> Is there any way to tell excel to treat the content of the cell as  
> text
> automatically?
>
> Thank you in advance for your insights.
>
> Sincerely,
> Nelly Yusupova
> http://www.digitalwoman.com
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php