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!! Quote Link to comment Share on other sites More sharing options...
Buddski Posted January 18, 2010 Share Posted January 18, 2010 And what is actually stored in $col? Quote Link to comment 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>"); Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.