PHPEXCEL导出,存在特殊字符遇到的问题

本文参考转载链接：https://blog.csdn.net/Su_Xingyu/article/details/84233728

1.打印内容发现中文昵称带了表情特殊字符，导致phpexcel导出时无法识别，会出现部分字段数据丢失的问题

[13] => Array
    (
        [payment_success_at] => 
        [user_name] => 💋.琳琳💃
        [remarks] => 
        [product_name] => 香菇
        [sku_name] => 斤
        [product_property] => 斤
        [price_original] => 5.50
        [price_current] => 5.50
        [consignee] => 💋.琳琳💃
    )

2.解决需要做字符集转码

conv('gb2312//ignore', 'utf-8', iconv('utf-8', 'gb2312//ignore', $value));

打印内容：
[13] => Array
(
[user_name] => .琳琳
[remarks] =>
[product_name] => 香菇
[sku_name] => 斤
[product_property] => 斤
[price_original] => 5.50
[price_current] => 5.50
[product_quantity] => 2
[consignee] => .琳琳
)

转码后就可以正常导出了