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;
}
强转成字符串类型即可!

浙公网安备 33010602011771号