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__));