public function explo(){
$obj = new \PHPExcel();
$q =查询需要到出的数据;
$data= [];
foreach($q as $k=>$v){
$data[$k]['category']=$v->category->name;
$question=str_replace(' ','',$v->question);
$question=trim(strip_tags($question));
$question=htmlspecialchars($question);
$data[$k]['title']=$question;
$data[$k]['answer']=$v->answer;
$reference=str_replace(' ','',$v->reference);
$reference=trim(strip_tags($reference));
$reference=htmlspecialchars($reference);
$data[$k]['reference']=$reference;
$level=str_replace(' ','',$v->difficult->name);
$level=trim(strip_tags($level));
$level=htmlspecialchars($level);
$data[$k]['level']=$level;
foreach ($v->options as $kk=>$vv){
$options=str_replace(' ','',$vv->content);
$options=str_replace('"','',$options);
$options=trim(strip_tags($options));
$options=htmlspecialchars($options);
$data[$k][$kk]=$options;
}
}
foreach ($data as $k => $v) {
$obj->setActiveSheetIndex(0)
->setCellValue('A'.$k, $v['category'])
->setCellValue( 'B'.$k, $v['title'])
->setCellValue( 'C'.$k, $v['answer'])
->setCellValue( 'D'.$k, $v['reference'])
->setCellValue( 'E'.$k, $v['level']);
if(isset($v[0])){
$obj->setActiveSheetIndex(0)
->setCellValue('F'.$k, $v[0]);
}
if(isset($v[1])){
$obj->setActiveSheetIndex(0)
->setCellValue('G'.$k, $v[1]);
}
if(isset($v[2])){
$obj->setActiveSheetIndex(0)
->setCellValue('H'.$k, $v[2]);
}
if(isset($v[3])){
$obj->setActiveSheetIndex(0)
->setCellValue('I'.$k, $v[3]);
}
if(isset($v[4])){
$obj->setActiveSheetIndex(0)
->setCellValue('J'.$k, $v[4]);
}
}
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="732.xlsx"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0
$objWriter = \PHPExcel_IOFactory::createWriter($obj, 'Excel2007');
$objWriter->save('php://output');
exit;
}
fastadmin导出excel,去除标签
最新推荐文章于 2023-05-11 09:05:51 发布