PHP spreadsheet writer writing variables to excel -
i trying write variables array excel cannot write in instances
code below
$workbook =new spreadsheet_excel_writer(); $workbook->send("response.xls"); $row=1; $col=1; $workbook->setversion(8); $worksheet =& $workbook->addworksheet('my sheet '); $allquestions = $questions->getquestions(); foreach ($allquestions $qkey=>$qval) { foreach ($studentresponses $rval){ $astresp= $rval->getresponse($qkey); //$worksheet->write($row,$col,'hiii'); $worksheet->write($row, $col, $astresp); $col++; } $row++; $col=1; } $workbook->close();
the $astresp when changed 'hihi' prints hihi in excel when remains $astresp fails open excel.
Comments
Post a Comment