完美解决邮件中excel乱码问题<mac 附件乱码>

最新推荐文章于 2023-05-25 16:58:39 发布

stark张宇

最新推荐文章于 2023-05-25 16:58:39 发布

阅读量4.9k

点赞数

分类专栏： # PHP 文章标签：乱码 excel

本文链接：https://blog.csdn.net/xuezhiwu001/article/details/60966745

版权

PHP 专栏收录该内容

72 篇文章 4 订阅

订阅专栏

之前在前期的开发过程中也发送过excel 后来自己使用mac以后发现有乱码所以有必要记录下来

    /**
     * 格式化表格
     */
    public function formatTable($sign_data){
        $table = 'ID'."\t".'姓名打卡'."\t".'时间'."\n";
        foreach($sign_data as $key => $val){
            $table .= $val['id']."\t".$val['name']."\t".$val['sign_time']."\n";
        }                
        return $table;
    }

PHP中程序使用\t制表符生成的excel 以前也是这么使用的但是发现有乱码如下图:
这里写图片描述

第一时间当时心里找了很多办法比如说iconv 和 mb_convert_encoding 进行编码转换然后在win上没有问题在mac上依然乱码

$content = iconv("GBK", "UTF-8", $content); 
$content = mb_convert_encoding($content, "UTF-8","GBK");

最后使用phpexcel插件代码如下：

/**
 * 使用phpexcel生成excel表格
 * @param unknown $data
 */
public function generateExcel($data){

    $objPHPExcel = new PHPExcel();
    //保存excel—2007格式
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    //设置当前的sheet
    $objPHPExcel->setActiveSheetIndex(0);
    //设置sheet的name
    $objPHPExcel->getActiveSheet()->setTitle('广州区打开记录');
    //设置单元格的值
    //垂直居中
    $objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    $objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);


    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'ID')->setCellValue('B1', '姓名')->setCellValue('C1', '签到时间');
    $number = 2;

    $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(15);

    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);

    foreach ($data as $key => $val){
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$number, $val['id'])->setCellValue('B'.$number,$val['name'])->setCellValue('C'.$number, $val['sign_time']);
        $number++;
    }
    $objWriter->save(self::SAVE_FILE_DIR);
}