PHPExcel、PHPPresentation、PHP_XLSXWriter操作数据

PHPExcel(官方早停维护)导入数据

   $config=C('FILE_UPLOAD_CONFIG');

   $config['exts'] =array("xls","xlsx");

   $config['rootPath']=$config['rootPath'].strtolower(MODULE_NAME).'/';

   $config['maxSize']=10485760;//最大10M

   $upload = new \Think\Upload($config);

   $info=$upload->upload();

   if($info)

   {

      $file_path=$config['rootPath'].$info['file_path']['savepath'].$info['file_path']['savename'];

      //导入phpexcel

      Vendor("PHPExcel.PHPExcel");

      Vendor("PHPExcel.IOFactory.PHPExcel_IOFactory");

      if(strtolower($info['file_path']['ext'])=='xls')

      {

        $objReader=new \PHPExcel_Reader_Excel5();

       }

       else

      {

          $objReader=new \PHPExcel_Reader_Excel2007();

      }

      $objPHPExcel = $objReader->load($file_path);

      $project_excel  = $objPHPExcel->getActiveSheet();

      $projects = $project_excel->toArray();  //取得总数

}

else

{

$this->ajaxReturn(array('status'=>false,'info'=>$upload->getError()));

}