convert string to number in excel

[ira19]

Hello,

  I hve the excelwriter.inc.php which writes data into excel sheet. I have a few columns that are numbers but the entire data is written as string & I get "The number in this cell is formatted as text or preced by an apostrophe" message in the sheet . This is the line which writes data into the sheet:

fwrite($this->fp,"<td class=xl24 width=64 >".$col."</td>");

I hve tried using intval

fwrite($this->fp,"<td class=xl24 width=64 >".intval($col)."</td>");

but it still gives me the same message.

 

Please help, i m stuck becaouse of this!!

[Buddski]

And what is actually stored in $col?

[taquitosensei]

if $col is actually a whole number you could do this

fwrite($this->fp,"<td class=xl24 width=64 >".(int)$col."</td>");

[simshaun]

I can't offer a solution to your problem, as I don't/haven't used ExcelWriter, but you should check out PHPExcel in the future.