change column data type

Topics: User Forum
Nov 12, 2007 at 1:30 PM
I want insert into colum A values that begin to 0 as 00123 or 00234. So i have to set column A data type as string.
How can i do it.


Nov 12, 2007 at 3:49 PM
I'm intrested in this as well.
Nov 14, 2007 at 2:19 PM
Check the PHPExcel_Worksheet::setCellValueExplicit() method for this.
Nov 17, 2007 at 4:54 PM
i've done it but it doesn't work!!!
here my code:

$objPHPExcel->getActiveSheet()->setCellValueExplicit('A1', '000010','s');
Nov 19, 2007 at 9:17 AM
Are you performing any other actions on this cell? Have example code?
Feb 14, 2008 at 10:52 AM
ehhh i have the same problem

when i try to insert values like "00023232" i have "23232" in excel ;(

please help
Feb 14, 2008 at 1:11 PM
Have you tried PHPExcel_Worksheet::setCellValueExplicit() ?