php excel导出

	
	import("Org.Util.PHPExcel");
	import("Org.Util.PHPExcel.Reader.Excel2007");
	
		import("Org.Util.PHPExcel.Writer.Excel2007");
		import("Org.Util.PHPExcel.IOFactory.php");
               
		$users=M("users")->select();
		

$objexcel=new \PHPExcel();//创建phpexcel
$objexcel
      ->getProperties()  //获得文件属性对象，给下文提供设置资源
      ->setCreator( "Maarten Balliauw")                 //设置文件的创建者
      ->setLastModifiedBy( "Maarten Balliauw")          //设置最后修改者
      ->setTitle( "Office 2007 XLSX Test Document" )    //设置标题
      ->setSubject( "Office 2007 XLSX Test Document" )  //设置主题
      ->setDescription( "Test document for Office 2007 XLSX, generated using PHP classes.") //设置备注
      ->setKeywords( "office 2007 openxml php")        //设置标记
      ->setCategory( "Test result file");      
$objexcel->setActiveSheetIndex(0)             //设置第一个内置表（一个xls文件里可以有多个表）为活动的
            ->setCellValue( 'A1', iconv('gb2312','utf-8','用户ID') )         //给表的单元格设置数据
            ->setCellValue( 'B1', iconv('gb2312','utf-8','用户名') )      //数据格式可以为字符串
            ->setCellValue( 'C1', iconv('gb2312','utf-8','最后登录时间'))            //数字型
            ->setCellValue( 'D1', iconv('gb2312','utf-8','用户ip'));         //
           foreach ($users as $k=>$v) {
      	
      	$rs=$k+2;
     	$objexcel->setActiveSheetIndex(0)
                   //设置表的名称标题
                  ->setCellValue('A'.$rs,$v["uid"])
                   ->setCellValue('B'.$rs,$v["uname"])
                   ->setCellValue('C'.$rs,date("Y:m:d H:i:s",$v["logintime"]))
                  ->setCellValue('D'.$rs,$v["loginip"]);
                 // $objexcel->getActiveSheet()->getStyle('C'.$rs)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD); 
                  
     }  
            $objActSheet = $objexcel->getActiveSheet();
// 位置bbb  *为下文代码位置提供锚
// 给当前活动的表设置名称

$objexcel->setActiveSheetIndex(0);
		    ob_end_clean(); 
  header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename=\"my.xlsx\"");
header('Cache-Control: max-age=0');

$objwriter=\PHPExcel_IOFactory::createWriter($objexcel,'Excel2007');
$objwriter->save('php://output');