public function excel()
{
$ids = $this->request->param('order_id/a');
// print_r($ids);exit;
if (!$ids) {
$this->error('数据异常');
}
$list = Db::name('pig_order')->where('id','in',$ids)->select();
vendor("PHPExcel.PHPExcel");
$objPHPExcel = new \PHPExcel();
// 设置sheet
$objPHPExcel->setActiveSheetIndex(0);
// 设置列的宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
// 设置表头
$objPHPExcel->getActiveSheet()->SetCellValue('A1', '订单号');
$objPHPExcel->getActiveSheet()->SetCellValue('B1', '买家手机号');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', '卖家手机号');
$objPHPExcel->getActiveSheet()->SetCellValue('D1', '价格');
$objPHPExcel->getActiveSheet()->SetCellValue('E1', '宠物名称');
$num = 2;
foreach ($list as $k => $v) {
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $num, $v['order_no']);
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $num, $v['buy_mobile']);
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $num, $v['sell_mobile']);
$objPHPExcel->getActiveSheet()->SetCellValue('D' . $num, $v['price']);
$objPHPExcel->getActiveSheet()->SetCellValue('E' . $num, $v['pig_name']);
$num++;
}
// 文件名称
$fileName = "订单信息" . date('Y-m-d', time()) . rand(1, 1000);
$xlsName = iconv('utf-8', 'gb2312', $fileName);
// 设置工作表名
$objPHPExcel->getActiveSheet()->setTitle('订单表');
//下载 excel5与excel2007
$objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
ob_end_clean(); // 清除缓冲区,避免乱码
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl;charset=UTF-8");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header("Content-Disposition:attachment;filename=" . $xlsName . ".xls");
header("Content-Transfer-Encoding:binary");
//$objWriter->save("worker.xls");
$objWriter->save('php://output');
return json(['code'=>1,'msg'=>'成功']);
}
php导出excel简便版
最新推荐文章于 2023-07-02 13:35:19 发布