php程序对微信你昵称的表情处理导出excel文件

php程序对微信昵称的表情处理,若转义存数据库,怎么读出并导出成excel文件.

<?php

include(dirname(__FILE__) .'/phpexcel-1.7.7/Classes/PHPExcel.php');
include(dirname(__FILE__) .'/phpexcel-1.7.7/Classes/PHPExcel/IOFactory.php');

    $name2 = "[[EMOJI:%F0%9F%91%BF]]李[[EMOJI:%F0%9F%8C%B9]]李[[EMOJI:%F0%9F%8D%92]]李[[EMOJI:%F0%9F%90%B0]] [[EMOJI:%F0%9F%87%A8]] [[EMOJI:%F0%9F%87%B3]] ";
    $name2_emoji = emoji_decode($name2);
    $name1_emoji = emoji_decode("汉字");
    //var_dump($name2_emoji);
    //var_dump($name1_emoji);exit;

    $objPHPExcel = new PHPExcel();
    //在激活的工作区写入数据 (单条写入数据演示)
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $name2_emoji);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', $name1_emoji);
    $objPHPExcel->getActiveSheet()->setCellValue('A3', "aa

标签：aa,php,objPHPExcel,微信,excel,哈兹,setCellValue,getActiveSheet,emoji	

From： https://www.cnblogs.com/fps2tao/p/18352569