当前位置:网站首页>Phpexcel export Emoji symbol error
Phpexcel export Emoji symbol error
2022-07-26 09:48:00 【Color the sky】
original text :http://blog.csdn.net/SakuraLLj/article/details/72823765
phpexcel Export user data into excel when , If the nickname contains an expression , It can lead to incomplete data .
Filter or replace emoji. because emoji adopt json_encode after , Most of them are u[ed] The code at the beginning , So first, the nickname json_encode Then use regular filtering or replace with *, The following is the relevant code :
$value = json_encode($value);
$value = preg_replace("/\\\u[ed][0-9a-f]{3}\\\u[ed][0-9a-f]{3}/","*",$value);// Replace with *
$value = json_decode($value);
边栏推荐
- JS 一行代码 获取数组最大值与最小值
- 开发转测试:从0开始的6年自动化之路...
- SSG框架Gatsby访问数据库,并显示到页面上
- 小白搞一波深拷贝 浅拷贝
- 配置ADCS后访问certsrv的问题
- (2) Hand eye calibration of face scanner and manipulator (eye out of hand: nine point calibration)
- Application of Gauss elimination
- 编写一个在bash / shell 和 PowerShell中均可运行的脚本
- 在Blazor 中自定义权限验证
- 面试突击68:为什么 TCP 需要 3 次握手?
猜你喜欢
2019 ICPC Asia Yinchuan Regional(水题题解)
Server and client dual authentication (2)
【Mysql数据库】mysql基本操作集锦-看得会的基础(增删改查)
解决ProxyError: Conda cannot proceed due to an error in your proxy configuration.
Fuzzy PID control of motor speed
Qt随手笔记(三)在vs中使用QtCharts画折线图
Solve NPM -v sudden failure and no response
配置ADCS后访问certsrv的问题
阿里云技术专家郝晨栋:云上可观测能力——问题的发现与定位实践
Login module use case writing
随机推荐
JS判断数据类型 Object.prototype.toString.call和typeof
POJ 1012 Joseph
Gauss elimination for solving XOR linear equations
matlab simulink实现模糊pid对中央空调时延温度控制系统控制
Unstoppable, pure domestic PCs have been in place, and the monopoly of the U.S. software and hardware system has been officially broken
Explain automatic packing and unpacking?
[MySQL database] a collection of basic MySQL operations - the basis of seeing (adding, deleting, modifying, and querying)
2022 zhongkepan cloud - server internal information acquisition and analysis flag
莫队学习总结(二)
在同一conda环境下先装Pytroch后装TensorFlow
[datawhale] [machine learning] Diabetes genetic risk detection challenge
Logical architecture of MySQL
【荧光字效果】
[fluorescent character effect]
Customize permission validation in blazor
(2) Hand eye calibration of face scanner and manipulator (eye out of hand: nine point calibration)
After attaching to the process, the breakpoint displays "currently will not hit the breakpoint, and no symbols have been loaded for this document"
m进制数str转n进制数
V-permission add permission
服务发现原理分析与源码解读