PHP 获取EXCEL中富文本中的文字

示例:

public function getExeclContent($param,$arr=['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']){
        $filePath = $param['file_url'];
        if(!file_exists($filePath)){
            throw new BusinessException(ErrorCode::FILE_DOES_NOT_EXIST);
        }
        $extension = strtolower(pathinfo($filePath, PATHINFO_EXTENSION));//判断导入表格后缀格式
        //根据不同的格式采用不同的读取方式
        if ($extension == 'xlsx') {
            $objReader =\PHPExcel_IOFactory::createReader('Excel2007');
        }else if ($extension == 'xls'){
            $objReader =\PHPExcel_IOFactory::createReader('Excel5');
        }else{
            throw new BusinessException(ErrorCode::THIS_FORMAT_TEXT_IMPORT_IS_NOT_SUPPORTED_AT_THE_MOMENT);
        }
        $objPHPExcel =$objReader->load($filePath, $encode = 'utf-8');
        $sheet =$objPHPExcel->getSheet(0);//激活第一个sheet表
        $highestRow = $sheet->getHighestRow();//取得总行数
        for($i=2;$i<=$highestRow;$i++)
        {
            foreach ($arr as $value){
                $text = $objPHPExcel->getActiveSheet()->getCell($value .$i)->getValue();
                if (is_object($text)){
                    $text = (string)($text);
                }
                $row[] =$text;
            }
            $data[] = $row;
            unset($row);
        }
        header("Content-type: text/html; charset=utf-8");
        return $data;
    } 

强转成字符串类型即可!

 

posted @ 2021-12-22 17:06  瑾琛  阅读(313)  评论(0)    收藏  举报