PHPExcel 导出Excel报错:PHPExcel_IOFactory::load()

本文介绍: 近期在做 excel 文件数据导出时，遇到如下报错： icon v(): De t e cte d an ille g al char a cte r in input string 场景：计划任务后台，分步导出大数据 excel 文件发现在加载文件时，会有报错，且只有在Linux 环境才会出问题！！

`背景`

近期在做 excel 文件数据导出时，遇到如下报错： iconv(): Detected an illegal character in input string
场景：计划任务后台，分步导出大数据 excel文件
发现在加载文件时，会有报错

报错信息 如下：

{
	"name": "PHP Notice",
	"message": "iconv(): Detected an illegal character in input string",
	"code": 8,
	"type": "yii\base\ErrorException",
	"file": "/usr/share/nginx/html/ycsh_automat/Classes/PHPExcel/Shared/String.php",
	"line": 490,
	"stack-trace": [
	  "#0 [internal function]: yii\base\ErrorHandler->handleError(8, 'iconv(): Detect...', '/usr/share/ngin...', 493, Array)", 
	  "#1 /usr/share/nginx/html/ycsh_automat/Classes/PHPExcel/Shared/String.php(490): iconv('CP1252', 'UTF-8', '\xE8\xAE\xA2\xE5\x8D\x95\xE5\x88\x97\xE8\xA1\xA8\x00\x00\x00...')", 
	  "#2 /usr/share/nginx/html/ycsh_automat/Classes/PHPExcel/Reader/Excel5.php(1362): PHPExcel_Shared_String::ConvertEncoding('\xE8\xAE\xA2\xE5\x8D\x95\xE5\x88\x97\xE8\xA1\xA8\x00\x00\x00...', 'UTF-8', 'CP1252')", 
	  "#3 /usr/share/nginx/html/ycsh_automat/Classes/PHPExcel/Reader/Excel5.php(633): PHPExcel_Reader_Excel5->readSummaryInformation()", 
	  "#4 /usr/share/nginx/html/ycsh_automat/Classes/PHPExcel/IOFactory.php(192): PHPExcel_Reader_Excel5->load('/usr/share/ngin...')", 
	  "#5 /usr/share/nginx/html/ycsh_automat/common/services/ExcelMzService.php(154): PHPExcel_IOFactory::load('/usr/share/ngin...')", 
	  "#6 /usr/share/nginx/html/ycsh_automat/common/models/ExportTask.php(306): common\services\ExcelMzService->cronCreateExportFile(Array, Array, '/usr/share/ngin...', Array, '\xE8\xAE\xA2\xE5\x8D\x95\xE5\x88\x97\xE8\xA1\xA8')", 
	  "#7 /usr/share/nginx/html/ycsh_automat/api/controllers/CronController.php(54): common\models\ExportTask::execExportTask(Object(common\models\ExportTask), 1, '{"search_params...')", 
	  "#8 [internal function]: api\controllers\CronController->actionRunExportTask()", 
	  ...
}