PHP Spreadsheet_Excel_Reader imports excel Chinese display garbled_PHP tutorial

This article will introduce to you the solution to the problem that PHP Spreadsheet_Excel_Reader imports Excel into Chinese and displays garbled characters and cannot read files in .xlsx format. Students who have encountered such problems can refer to it.

Spreadsheet_Excel_Reader is a commonly used php class for importing excel files.
Under normal circumstances, the code to import excel using this class is as follows

$data->read('20110630_ctms.xls'); //Print output sheet array, single or multiple

The code is as follows  代码如下 复制代码 //引入系统公共文件。 require_once ('../global.php'); //引入excel读取功能类 require_once ('./excel/reader.php'); //实例化 $data = new Spreadsheet_Excel_Reader(); //设置输出类型（可以是“GBK”或者“UTF-8”）,注意插入数据库时的编码转换 $data->setOutputEncoding('CP936'); //读取excel文件地址 $data->read('20110630_ctms.xls'); //打印输出sheet数组，单个或多个 print_r($data->sheets); echo ' '; //打印输出每个sheet的行数，$k从零开始 $k = 0; echo $data->sheets[$k]['numRows'];

Copy code

//Introduce system public files. require_once ('../global.php'); //Introduce excel reading function class require_once ('./excel/reader.php'); //Instantiation $data = new Spreadsheet_Excel_Reader(); //Set the output type (can be "GBK" or "UTF-8"), pay attention to the encoding conversion when inserting into the database $data->setOutputEncoding('CP936'); //Read excel file address

print_r($data->sheets); echo '
';

//Print out the number of rows in each sheet, $k starts from zero

2. Encoding problem. Chinese characters appear garbled. http://www.bkjia.com/PHPjc/632103.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632103.htmlTechArticleThis article will introduce to you how to solve the problem of garbled Chinese characters when imported into excel using PHP Spreadsheet_Excel_Reader and the inability to read files in .xlsx format. Methods, students who have encountered such problems can enter for reference. ...