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
Post a Comment