require '../extend/PHPExcel/PHPExcel.php'; require '../extend/PHPExcel/PHPExcel/IOFactory.php'; require '../extend/PHPExcel/PHPExcel/Writer/Excel2007.php'; $list = Db::name('user')->field("id,mobile,pid")->select(); $PHPExcel = new \PHPExcel(); ob_end_clean(); /*$list[$k]['skuinfo_name_cn']=$list[$k]['skuinfo']['name_cn']; $list[$k]['skuinfo_barcode']=$list[$k]['skuinfo']['barcode']; $list[$k]['createtime']=date('Y-m-d H:i:s',$v['createtime']);*/ $indexKey=array( 'id', 'mobile', 'pid', ); $indextit=array( 'id', '手机号', '上级id', ); $startRow=2; if(empty($filename)) $filename = time(); if( !is_array($indexKey)) return false; $header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); //初始化PHPExcel() $objPHPExcel = new \PHPExcel(); $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel); $filename = $filename.'.xlsx'; //接下来就是写数据到表格里面去 $objActSheet = $objPHPExcel->getActiveSheet(); //$startRow = 1; foreach ($indextit as $kk=>$vv){ $ss=1; $objActSheet->setCellValue($header_arr[$kk].$ss,$vv); } foreach ($list as $row) { //$row['createtime']=date('Y-m-d H:i:s',$row['createtime']); $row['skuinfo_barcode']=" ".$row['skuinfo_barcode']; foreach ($indexKey as $key => $value){ //这里是设置单元格的内容 $objActSheet->setCellValue($header_arr[$key].$startRow,$row[$value]); } $startRow++; } // 下载这个表格,在浏览器输出 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"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download");; header('Content-Disposition:attachment;filename='.$filename.''); header("Content-Transfer-Encoding:binary"); //$objWriter=\PHPExcel_IOFactory::createWriter($objPHPExcel, 'eXCEL5'); $objWriter->save('php://output'); return 1;
上一篇: mysql 模型记录...