function filterEmoji($str)
{
$str = preg_replace_callback(
'/./u',
function (array $match) {
return strlen($match[0]) >= 4 ? '' : $match[0];
},
$str);
return $str;
}
由于excel中以=开头会报错,所以还需要再一步处理
function startWith($str, $needle)
{
return strpos($str, $needle) === 0;
}
$nickname = $this->filterEmoji(urldecode($mydata["nickname"]));
$objActSheet->setCellValue('D' . ($i+2), $this->startWith($nickname,"=")?str_replace("=","-",$nickname):$nickname);
网友评论