PHPExcel读取excel的多个sheet存入数据库

//批量导入文章 excel读取public function importdata ( $filename, $tmp_name ) {//设置超时时间set_time_limit(0);$rootPath = OA_FILES_ROOT.'/' ;//引入phpexcel// $_SERVER["WL_OA"] = 'E:/www/2.151/oa/web';$_SERVER["WL_OA"] = '/opt/wwwroot/wl/oa/web';require($_SERVER["WL_OA"] . "/Classes/PHPExcel.php");require($_SERVER["WL_OA"] . "/Classes/PHPExcel/IOFactory.php");require($_SERVER["WL_OA"] . "/Classes/PHPExcel/Reader/Excel5.php");//判断文件格式$path_parts = pathinfo($filename) ;$extension = strtolower($path_parts['extension']) ;if ( !in_array($extension, array('xls','xlsx'))) {wl_set_operation_msg ( "文件格式不正确,请重新选择", 2, bd_oa_url ( 'helpcenter/manage_article' ), 3 );}//上传后的文件名$randName = substr(md5(rand(10,99)), 0,4) ;$name = date('YmdHis').$randName.'.'.$extension ;$realFile = $rootPath.$name; //上传后的文件名地址 //移动上传文件$result = move_uploaded_file( $tmp_name, $realFile );if ( $result ) {$PHPExcel = new PHPExcel() ;$PHPReader = new PHPExcel_Reader_Excel();if( !$PHPReader->canRead($realFile) ){$PHPReader = new PHPExcel_Reader_Excel5();if( !$PHPReader->canRead( $realFile ) ){wl_set_operation_msg ( "文件不可读,请重新选择", 2, bd_oa_url ( 'helpcenter/manage_article' ), 3 );return false;}}$_excelData = array() ;//读取excel$PHPExcel = $PHPReader->load( $realFile );//获取工作表的数目$sheetCount = $PHPExcel->getSheetCount();for ( $i = 0; $i < $sheetCount; $i++ ) {$_currentSheet = $PHPExcel->getSheet( $i ) ;$_allRow = $_currentSheet->getHighestRow(); //获取Excel中信息的行数$_allColumn = $_currentSheet->getHighestColumn();//获取Excel的列数$highestRow = intval( $_allRow ) ;$highestColumn = PHPExcel_Cell::columnIndexFromString($_allColumn);//有效总列数for( $row = 2; $row <= $highestRow; $row++ ) {$_excelData['onecatalog'] = $_currentSheet->getCellByColumnAndRow(0, $row)->getValue() ;$_excelData['twocatalog'] = $_currentSheet->getCellByColumnAndRow(1, $row)->getValue() ;$_excelData['threecatalog'] = $_currentSheet->getCellByColumnAndRow(2, $row)->getValue() ;$_excelData['title'] = $_currentSheet->getCellByColumnAndRow(3, $row)->getValue() ;$_excelData['content']= $_currentSheet->getCellByColumnAndRow(4, $row)->getValue() ;if ( empty($_excelData['onecatalog']) || empty($_excelData['twocatalog']) || empty($_excelData['threecatalog']) ) {self::add_log( array('sType'=>"导入失败",'doContent'=>$filename." 下 Sheet".($i+1)." 中第 ".$row." 行导入失败",'iUid'=>$this->loginedUid,'doTime'=>date("Y-m-d H:i:s"))) ;unset( $_excelData ) ;continue ;}if ( !is_string( $_excelData['title'] ) || !is_string( $_excelData['content'] ) || empty($_excelData['title']) || empty($_excelData['content']) ) {self::add_log( array('sType'=>"导入失败",'doContent'=>$filename." 下 Sheet".($i+1)." 中第 ".$row." 行导入失败",'iUid'=>$this->loginedUid,'doTime'=>date("Y-m-d H:i:s"))) ;unset( $_excelData ) ;continue ;}

//插入数据库if ( !self::doData( $_excelData ) ) {unset( $_excelData ) ;continue ;}unset($_excelData);}}return true ;}else{wl_set_operation_msg ( "文件上传失败,请重新选择", 2, bd_oa_url ( 'helpcenter/manage_article' ), 3 );}}