Can you format columns when loading rows using fromArray() ?

Topics: Developer Forum
Apr 19, 2012 at 7:19 PM

I am having trouble applying formatting to my columns when loading via fromArray as follows:


I try and format a column but it appears to either not work, or be too late [by too late I mean that (1)cells with a zero value are replaced w/ blanks, and (2)cells that I want formatted as text but contain only digits are converted to numbers w/ decimal places - I have a string like 0176 which is a store number, it gets converted to 176.00]


Can the two work together?  I have tried to format before and after using fromArray but neither seems to work.


PHP Version: 5.2.12

PHPExcel version: lastest SVN (downloaded today)

OS: CentOS 5.4