Manjiri - 2010-01-18 14:29:44
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 because of this!!