require '/home/public/yinxiao/webroot/yii/vendor/phpoffice/phpexcel/Classes/PHPExcel.php';
public function actiondownloadUserExcel()
{
$model = new Para();
$request = Yii::$app->request;
judgeParameter();
$token = $request->get('token');
if ($token == '') {
echo "token不能为空";
}
$checkTrue = checkRule($token);
if ($checkTrue == false) {
return;
}
if(!is_array($dateSection)) {
return false;
}
$companyId = (int)$companyId;
$showOuterUser = $model->showUser();
$objPHPExcel = new \PHPExcel();
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
header('Pragma:public');
header('Content-Type:application/x-msexecel;name="output.xls"');
header('Content-Disposition:inline;filename=output.xls');
$objPHPExcel->createSheet();
$array = ['姓名', '公司', '平台', '管理员', '创建时间'];
$x = ['A', 'B', 'C', 'D', 'E'];
$line = 1;
$count = count($x);
for ($i = 0; $i < $count; $i++) {
$objPHPExcel->getActiveSheet()->setCellValue($x[$i] . $line, $array[$i]);
}
foreach ($showOuterUser as $key => $value) {
$line += 1;
if ($value['isAdmin'] ==1 )
{
$isAdmin = '是';
} else {
$isAdmin = '否';
}
$array = [$value['username'], $value['company'], $value['platform'], $isAdmin, $value['date']];
$x = ['A', 'B', 'C', 'D', 'E'];
$c = count($x);
for ($i = 0; $i < $c; $i++) {
$objPHPExcel->getActiveSheet()->setCellValue($x[$i] . $line, $array[$i]);
}
}
$path = NEWEVA_PARA . "/output.xls";
$objWriter->save($path);
download(NEWEVA_PARA, 'output.xls');
}
yii框架php获取execl数据
最新推荐文章于 2024-09-13 12:27:16 发布