如何利用PHP导入Excel数据到数据库

 /** * 导入excel * @throws /PHPExcel_Exception * @throws /PHPExcel_Reader_Exception html' target='_blank'>public function impExcel($filename,$data){ if (!empty($_FILES)) { $config = array( exts = array( xlsx , xls ), rootPath = ./ , savePath = Public/Uploads/$filename/ , subName = array( date , Ymd ), $upload = new /Think/Upload($config); if (!$info=$upload- upload()) { $this- error($upload- getError()); vendor( PHPExcel.PHPExcel  $file_name = $info[ excel ][ savepath ].$info[ excel ][ savename  //$objReader = /PHPExcel_IOFactory::createReader( Excel5  $Excel_name = getcwd() . / .$file_name; //$aaa = is_readable($Excel_name); // $objPHPExcel = $objReader- load($Excel_name,$encode= utf-8  $extension = strtolower( pathinfo($Excel_name, PATHINFO_EXTENSION) ); if ($extension == xlsx ) { $objReader = new /PHPExcel_Reader_Excel2007(); $objPHPExcel = $objReader - load($Excel_name); } else if ($extension == xls ) { $objReader = new /PHPExcel_Reader_Excel5(); $objPHPExcel = $objReader - load($Excel_name); } else if ($extension== csv ) { $PHPReader = new /PHPExcel_Reader_CSV(); //默认输入字符集 $PHPReader- setInputEncoding( GBK  //默认的分隔符 $PHPReader- setDelimiter( ,  //载入文件 $objPHPExcel = $PHPReader- load($Excel_name); $sheet = $objPHPExcel- getSheet(0); $highestRow = $sheet- getHighestRow(); // 取得总行数 $highestColumn = $sheet- getHighestColumn(); // 取得总列数 for($i=2;$i =$highestRow;$i++) $data[ name ] = $objPHPExcel- getActiveSheet()- getCell( A .$i)- getValue(); $data[ tel ] = $objPHPExcel- getActiveSheet()- getCell( B .$i)- getValue(); $data[ zjh ] = $objPHPExcel- getActiveSheet()- getCell( C .$i)- getValue(); $data[ sheng ] = $objPHPExcel- getActiveSheet()- getCell( D .$i)- getValue(); $data[ shi ] = $objPHPExcel- getActiveSheet()- getCell( E .$i)- getValue(); $data[ address ]= $objPHPExcel- getActiveSheet()- getCell( F .$i)- getValue(); $data[ money ]= $objPHPExcel- getActiveSheet()- getCell( G .$i)- getValue(); $data[ hk_time ]= $objPHPExcel- getActiveSheet()- getCell( H .$i)- getValue(); $data[ nanyi ]= $objPHPExcel- getActiveSheet()- getCell( I .$i)- getValue(); $data[ uid ] = $_SESSION[ user ][ id  $data[ time ] = date( Y-m-d H:i:s  M( release )- add($data); $this- success( 导入成功！ exit(); }else $this- error( 请选择上传的文件 
 // $data[ qixian ] = I( post.qixian , , trim  // $data[ comm ] = I( post.comm , , trim  if(!empty($_FILES)){ $this- impExcel( batch_release ,$data); }

以上就是本文的全部内容，希望对大家的学习有所帮助，更多相关内容请关注PHP ！

相关推荐：

利用PHPEXCEL 导出数据和图片的代码

以上就是如何利用PHP导入Excel数据到数据库的详细内容，PHP教程

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。