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

mac2025-03-18  12

本文参考转载链接: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] => .琳琳 )

转码后就可以正常导出了

最新回复(0)