php - phpexcel cannot pass ~ -


somewhere in program phpexcel looks this:

$objphpexcel = new phpexcel();  foreach($arrayrawdata $hwkeycolumn => $arrayhwdata){         $objphpexcel->setactivesheetindex($counter)                     -> setcellvalue($header2 . $headercol , $hwkeycolumn);         $objphpexcel->getactivesheet()->settitle($mode); }  foreach($arrayrawdata $hwkeycolumn => $arrayhwdata){          foreach($arrayhwdata $id => $value){                 $objphpexcel->setactivesheetindex($counter)                             -> setcellvalue($header . $headercol2,$value);         } }  $objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel2007'); $objwriter->save('report.xlsx'); 

i removed incrementing of cell. working correctly. manage save excel data intact , no errors in placement.

my problem in inner loop. $value example have value physically defective˜. when saves in excel. displayed physically defective. ~ missing. need grab error trapping purpose.

i tried echo $value , surely echoes physically defective˜. tried getting original value of $value , passed new variable. new variable value of physically defective˜ still when saves becomes physically defective.

//edit when hardcode $value = 'physically defective˜'; excell display correctly. if leave loop change value of $value removes ~


Comments