PHP导出Excel去掉微信昵称中的特殊字符

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);