php - PHPExcel writing issue -


i need write .xls file data mysql database. fine, except when there's field string: "false n¦ not use".

in case, in specific cell writes "false n" , stops there, without writing "¦" , comes after.

this issues come other characters such "Ï"

this piece of code writes file.

while (!$rs->eof){       $objphpexcel->setactivesheetindex(0)                 ->setcellvalueexplicit('a'.$i, $rs->fields["nr_id"], phpexcel_cell_datatype::type_string2)                 ->setcellvalue('b'.$i, $rs->fields["descrizione"]) //this field gives me problem                 ->setcellvalue('c'.$i, number_format($rs->fields["prezzo_eur"], 2, ",", "")); $rs->movenext(); $i++; } 

is there way write everything?

it nothing html entities!

update: encoded in utf8 , fine, everybody!


Comments