$v) { if ($v) { $data[] = explode(",", trim($v)); } } return $data; } /** * 读取EXCEL文件 * @param string $filePath * @return array */ public static function readEXCEL($filePath) { $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { return "Invalid File."; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); /**取得一共有多少列*/ $maxColumn = $currentSheet->getHighestColumn(); /**取得一共有多少行*/ $rowCount = $currentSheet->getHighestRow(); $result = array(); //$ColumnArr = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP'); if(strlen($maxColumn)==1){ for($i="A";$i<=$maxColumn;$i++){ $ColumnArr[] = $i; } }elseif(strlen($maxColumn)==2){ $firstZimu = $maxColumn{0}; $secondZimu = $maxColumn{1}; if($firstZimu=='A'){ //第一个字母为A $ColumnArr = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); for($i='A';$i<=$secondZimu;$i++){ $ColumnArr[]='A'.$i; } }else{ //第一个字母大于A $ColumnArr = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); /*for($i='A';$i<=$firstZimu;$i++){ $ColumnArr[]='A'.$i; }*/ for($i="A";$i<=$firstZimu;$i++){ if($i==$firstZimu){ for($k=ord("A");$k<=ord($secondZimu);$k++){ $ColumnArr[] = $i.chr($k); } }else{ for($j=65;$j<=90;$j++){ $ColumnArr[] = $i.chr($j); } } } //第一个字母不为A情况 //return array(); } }else{ //错误 return array(); } for ($row = 1; $row <= $rowCount; $row++) { $totalLen = 0; //记录行总长度 //for ($column = "A"; $column <= $maxColumn; $column++) { for ($c_Column= 0;$c_Column < count($ColumnArr); $c_Column++) { //echo $column.'
'; //$currentSheet->getCell($ColumnArr[$c_Column].$row)->setDataType(); $value = $currentSheet->getCell($ColumnArr[$c_Column].$row)->getValue(); if (is_object($value)) { $value = $value->__toString(); } $result[$row][] = $value; $totalLen += strlen(trim($value)); } if ($totalLen == 0) unset($result[$row]); //去掉空行 } return array_values($result); } }