浏览器正常导出文件phpecxel

      header("Content-type: text/html; charset=utf-8");
      require "./plugin/phpexcel-1.8/Classes/PHPExcel/IOFactory.php";
      require_once './plugin/phpexcel-1.8/Classes/PHPExcel.php';
      require_once './plugin/phpexcel-1.8/Classes/PHPExcel/Writer/Excel2007.php';
      /**
       * 创建(导出)Excel数据表格
       * @param array $list 要导出的数组格式的数据
       * @param string $filename 导出的Excel表格数据表的文件名
       * @param array $indexKey $list数组中与Excel表格表头$header中每个项目对应的字段的名字(key值)
       * @param array $startRow 第一条数据在Excel表格中起始行
       * @param [bool] $excel2007 是否生成Excel2007(.xlsx)以上兼容的数据表
       * 比如: $indexKey与$list数组对应关系如下:
       * $indexKey = array('id','username','sex','age');
       * $list = array(array('id'=>1,'username'=>'YQJ','sex'=>'男','age'=>24));
       */
      /*function exportExcel($list,$filename,$indexKey,$startRow=1,$excel2007=false){
       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();
       //设置保存版本格式
       if($excel2007){
       $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
       $filename = $filename.'.xlsx';
       }else{
       $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
       $filename = $filename.'.xls';
       }
       //接下来就是写数据到表格里面去
       $objActSheet = $objPHPExcel->getActiveSheet();
       $objActSheet->setCellValue('A2', "活动名称：江南极客");
       $objActSheet->setCellValue('C2', "导出时间：".date('Y-m-d H:i:s'));
       //$startRow = 1;
       foreach ($list as $row) {
       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");
       $res=$objWriter->save('php://output');
       return $res;
      }*/
      function exportExcel2($list,$filename,$indexKey=array()){
     	$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');
     	//$objPHPExcel = new PHPExcel(); //初始化PHPExcel(),不使用模板
     	$template = 'D:/Download/test.xlsx';          //使用模板
      // $template = dirname(__FILE__).'/template.xls'; //使用模板
     	$objPHPExcel = PHPExcel_IOFactory::load($template);     //加载excel文件,设置模板
     	$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);  //设置保存版本格式
     	//接下来就是写数据到表格里面去
     	$objActSheet = $objPHPExcel->getActiveSheet();
     	$objActSheet->setCellValue('A2',  "活动名称：江南极客");
     	$objActSheet->setCellValue('C2',  "导出时间：".date('Y-m-d H:i:s'));
     	$i = 4;
     	foreach ($list as $row) {
     		foreach ($indexKey as $key => $value){
     			//这里是设置单元格的内容
     			$objActSheet->setCellValue($header_arr[$key].$i,$row[$value]);
      		}
     		$i++;
      	}
     	// 1.保存至本地Excel表格
     	//$objWriter->save($filename.'.xls');
     	// 2.接下来当然是下载这个表格了，在浏览器输出就好了
      	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.'.xls"');
      	header("Content-Transfer-Encoding:binary");
     	$objWriter->save('php://output');
      }
      $indexKey = array('id','username','sex','age');
      $data = array(array('id'=>1,'username'=>'YQJ','sex'=>'男','age'=>24));
       exportExcel2($data,$filename='test',$indexKey);
      // exportExcel($data,$filename='test',$indexKey,$startRow=1,$excel2007=true);
  
 

文章来源: blog.csdn.net，作者：lxw1844912514，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/lxw1844912514/article/details/120788409