php导出excel

  include_once ‘./lib/phpexcel/PHPExcel.class.php‘;
  include_once ‘./lib/phpexcel/phpexcel/IOFactory.php‘;

  $inputFileName=‘./dispute.xls‘;
  $excel = PHPExcel_IOFactory::load($inputFileName);
  $excel->getProperties()->setCreator("sxg")
     ->setLastModifiedBy("sxg")
     ->setTitle("矛盾纠纷导出数据")
     ->setSubject("矛盾纠纷导出数据")
     ->setDescription("dispute矛盾纠纷导出数据");
  $excel->setActiveSheetIndex(0);
  $objActSheet = $excel->getActiveSheet();

  $SQL = "SELECT * FROM dispute order by dispId limit 0,2";
  
  $rst = DB::Execute($SQL, 20011, ‘dispute‘, ‘admin‘, ‘‘, ‘‘,"query");
  $arr = split("\1",$rst);
  $row=2;
  foreach($arr as $rs){
    $col=0;
    $valArr = split("\2",$rs);
    foreach($valArr as $val) {
     $objActSheet->setCellValueByColumnAndRow($col,$row,$val);
     $col++;
    }
    $row++;
  }
  $objWriter = PHPExcel_IOFactory::createWriter($excel, ‘Excel5‘);
  $objWriter->save(str_replace(‘.php‘, ‘.xls‘, __FILE__));