ira19 Posted January 18, 2010 Share Posted January 18, 2010 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!! Link to comment https://forums.phpfreaks.com/topic/188882-convert-string-to-number-in-excel/ Share on other sites More sharing options...
Buddski Posted January 18, 2010 Share Posted January 18, 2010 And what is actually stored in $col? Link to comment https://forums.phpfreaks.com/topic/188882-convert-string-to-number-in-excel/#findComment-997396 Share on other sites More sharing options...
taquitosensei Posted January 18, 2010 Share Posted January 18, 2010 if $col is actually a whole number you could do this fwrite($this->fp,"<td class=xl24 width=64 >".(int)$col."</td>"); Link to comment https://forums.phpfreaks.com/topic/188882-convert-string-to-number-in-excel/#findComment-997582 Share on other sites More sharing options...
simshaun Posted January 18, 2010 Share Posted January 18, 2010 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. Link to comment https://forums.phpfreaks.com/topic/188882-convert-string-to-number-in-excel/#findComment-997586 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.