phpexecl 导出

header("Content-type:text/html;charset=utf-8"); 
require APPPATH. "./libraries/PHPExcel/Classes/PHPExcel.php";
$PHPExcel = new PHPExcel();

$success_data = array( array( 'id' => 12, 'name'=> '121' ), array( 'id' => 12, 'name'=> '121' ) );

$PHPExcel->getProperties()->setCreator("kangbo1") ->setLastModifiedBy("kangbo2") ->setTitle("标题") ->setSubject("主题") ->setDescription("描述") ->setKeywords("标记") ->setCategory("类别");

$PHPExcel->setActiveSheetIndex(0);

$PHPExcel->getActiveSheet()->setCellValue('A1', "商品编号");

$PHPExcel->getActiveSheet()->setTitle('1');

$count = count($success_data);

$j = 0;

for ($i = 2; $i <= ($count+2); $i++) {

　　if (isset($success_data[$j])) {

　　　　$PHPExcel->getActiveSheet()->setCellValue('A' . $i, $success_data[$j]['name']);

      }

      $j++;

}

ob_end_clean();

header('Content-Type: application/vnd.ms-excel');

header('Content-Disposition: attachment;filename="success.xls"');//文件名，不需加后缀

header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel5');

$objWriter->save('php://output');

exit;