Php excel change particular cell only numeric to text

Hi,
I have one big doubt i’m using phpexcel in my project i export all data in excel xlsx format.All data export properly but B column value only not properly
for example:
i have a value in my database 0000001 like that but i export excel means i got a value only 1
i don’t know to change the property numeric to Text using PHPExcel.

did you try setting the type?

You would get the same problem if you did that in Excel itself. In Excel you can precede the 0000001 with a single quote/apostrophe to preserve the value.

please explain me clearly

Try '0000001 rather than just 0000001

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.