PHP如何读取Excel类文件的图文解析

$path="/wamp/www/xiong/hadf";

    if(is_dir($path)){

      echo"存在";

    }else{

      mkdir($path, 0777, true);

      echo"chuangji";

    }

    require_once"./PHPExcel.php";

    $filePath="./1233.xlsx";

    $PHPReader=newPHPExcel_Reader_Excel2007();

          if(!$PHPReader->canRead($filePath)) {

            $PHPReader=newPHPExcel_Reader_Excel5();

            if(!$PHPReader->canRead($filePath)) {

              echo'no Excel'

              exit;

            }

          }

    $PHPExcel=$PHPReader->load($filePath);

          /**读取excel文件中的第一个工作表*/

          $currentSheet=$PHPExcel->getSheet(0);

          /**取得最大的列号*/

          $allColumn=$currentSheet->getHighestColumn();

          // echo $allColumn;exit;

          /**取得一共有多少行*/

          $allRow=$currentSheet->getHighestRow();

          /**从第二行开始输出，因为excel表中第一行为列名*/

          $val=''

          for($currentRow= 1;$currentRow<=$allRow;$currentRow++) {

          /**从第A列开始输出*/

            for($currentColumn='A'$currentColumn<=$allColumn;$currentColumn++) {

              $val.=$currentSheet->getCellByColumnAndRow(ord($currentColumn)  - 65,$currentRow);//->getValue();/**ord()将字符转为十进制数*/

              $val.="&%|%&";

              /**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将GBK编码转为UTF-8编码输出*/

              //$val .= iconv('GBK','UTF-8', $val);

            }

            $val.="n";

          }$member_info_arr=explode("n",$val);

          unset($member_info_arr[count($member_info_arr) - 1]);

          $present_time=date("Y-m-d H:i:s");

          if(count($member_info_arr) <= 0) {

            sys_msg_json(0,"会员信息文件中无数据，请添加");

          }

          unset($member_info_arr[0]);

          // var_dump($member_info_arr);exit;

          foreach($member_info_arras$key=>$val) {

            $arr[$key] =explode("&%|%&",$val);

          }

          // var_dump($arr);exit;

          foreach($arras$key=>$val) {

            unset($arr[$key][2]);

          }

          var_dump($arr);