PHP系列 | PHPexcel导入xls格式，提示错误：iconv(): Wrong charset, conversion from `CP936' to `UTF-8' is not allowed

时间：2019-09-23 20:54:56 收藏：0 阅读：1633

导入xls格式（2003版本）时会报错提示错误信息

iconv(): Wrong charset, conversion from `CP936‘ to `UTF-8‘ is not allowed[/var/www/web/vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/String.php:490]

解决办法：

if (self::getIsIconvEnabled()) {
    return iconv($from, $to, $value);
}

修改为

if (self::getIsIconvEnabled()) {
    if ($to==‘UTF-8‘ && $from==‘CP936‘) {
        return iconv(‘UTF-8‘, ‘latin1‘, $value);
    }
    return iconv($from, $to, $value);
}

修改后

技术分享图片

原文：https://www.cnblogs.com/tinywan/p/11574206.html

PHP系列 | PHPexcel导入xls格式 ，提示错误：iconv(): Wrong charset, conversion from `CP936&#39; to `UTF-8&#39; is not allowed

PHP系列 | PHPexcel导入xls格式，提示错误：iconv(): Wrong charset, conversion from `CP936' to `UTF-8' is not allowed