使用phpEmail 类实现导入并解析

首先下载PHPEXCEL 下载地址：https://github.com/PHPOffice/PHPExcel

require $_SERVER['DOCUMENT_ROOT']."/addons/shop/core/web/sale/promotion/PHPExcel-1.8/Classes/PHPExcel.php";//引入PHPExcel加载文件  要绝对路径
        $file = $_FILES['uploadFile'];
        $filename = $file['name'];
        $file_temp_name =$file['tmp_name'];
        $type = strstr($filename,'.');
        if($type != '.xls' && $type != '.xlsx'){
            show_json(0,"规格错误");//错误提示
        }
        if(is_uploaded_file($file_temp_name)){
        //保存的路径  需要绝对路径
            $full_name = $_SERVER['DOCUMENT_ROOT']."/addons/shop/core/web/sale/promotion/excel/".$filename;
            $result = move_uploaded_file($file_temp_name, $full_name);
        }else{
            show_json(0,"上传方式错误,请重新上传!");//错误提示
        }
        //如果上传文件成功，就执行导入 excel操作
        $objReader = PHPExcel_IOFactory::createReaderForFile($full_name);
        $objPHPExcel = $objReader->load($full_name);
        $objPHPExcel->setActiveSheetIndex(0);
        $sheet = $objPHPExcel->getSheet(0);
        $highestRow = $sheet->getHighestRow(); // 取得总行数
        $highestColumn_num = PHPExcel_Cell::columnIndexFromString($sheet->getHighestDataColumn());	//列数
        //$columns = PHPExcel_Cell::getColumn($highestColumn_num);
        $columns = array('A','B','C','D');
        $arr_result = array();
        $dealer_element = array();
        for ($j = 2; $j <= $highestRow; $j++) {
            for ($k = 0; $k < count($columns); $k++) {
                //读取单元格
                $value = $objPHPExcel->getActiveSheet()->getCell($columns[$k] . $j)->getValue();//这个就是获取每个单元格的值
                $value = trim($value);
                if (empty($value)) {
                    $value = NULL;
                }
                $dealer_element[$k] = $value;
                //这里可以根据要求，做一些数据的验证
            }
            $arr_result[$j] = $dealer_element;
        }
var_dump($arr_result);

注意事项：上传保存的地址和引入的地址都需要使用绝对路径