PhpExcel Error if the data is having "=" symbol at the start

Topics: Developer Forum
Aug 12, 2011 at 8:51 AM

Hi , I am using PHP Excel to download the data into excel in PHP.

The data is dynamic.We cannot predict what the data may come.But some times while downloading data into Excel , it is throwing error,

When we dig into the root cause, we found that the data is starting with = symbol.

Please provide me a solution , to handle these type of situations.

Aug 12, 2011 at 9:09 AM

are you explicitely setting the data type of the cell to string? otherwise the = may result in the parser thinking it is a formula, which probably is not correct.

Aug 12, 2011 at 12:24 PM
borft wrote:

are you explicitely setting the data type of the cell to string? otherwise the = may result in the parser thinking it is a formula, which probably is not correct.

Thank you,

The problem is solved.

No, Now I explicitly converted the data type to string .And I can able to download data now.

Thank you so much.