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