php读入excel时出现乱码,怎么处理?
时间:2011-07-25
来源:互联网
php读入excel时出现乱码,怎么处理?
$this->load->library('Spreadsheet_Excel_Reader');
$data = new Spreadsheet_Excel_Reader();
$addr = './upload/import/train_plan.xls';
$data->read($addr);
$data->setOutputEncoding('utf-8'); //解决中文乱码
print_r($data->sheets[0]['cells']);
for( $i = 2; $i <= $data->sheets[0]['numRows']; $i++ ){
$type = @$data->sheets[0]['cells'][$i][1];//工号
}
Array ( [1] => Array ( [1] => z{|+R [2] => z T饄 [3] => z?u鵞a? [4] => 矉^ [5] => zb__ [6] => 篘pe [7] => 10g [8] => 11g [9] => 12g ) [2] => Array ( [1] => NN€b齹 [2] => LINU [3] => 鹼邁_裇篘XT [4] => Ng\ h [5] => 匭瓔 [6] => 40 [7] => g+g [8] => 1 [9] => 2 ) )
$this->load->library('Spreadsheet_Excel_Reader');
$data = new Spreadsheet_Excel_Reader();
$addr = './upload/import/train_plan.xls';
$data->read($addr);
$data->setOutputEncoding('utf-8'); //解决中文乱码
print_r($data->sheets[0]['cells']);
for( $i = 2; $i <= $data->sheets[0]['numRows']; $i++ ){
$type = @$data->sheets[0]['cells'][$i][1];//工号
}
Array ( [1] => Array ( [1] => z{|+R [2] => z T饄 [3] => z?u鵞a? [4] => 矉^ [5] => zb__ [6] => 篘pe [7] => 10g [8] => 11g [9] => 12g ) [2] => Array ( [1] => NN€b齹 [2] => LINU [3] => 鹼邁_裇篘XT [4] => Ng\ h [5] => 匭瓔 [6] => 40 [7] => g+g [8] => 1 [9] => 2 ) )
作者: lili19851121 发布时间: 2011-07-25
http://tieba.baidu.com/p/1136190421
作者: za083z 发布时间: 2011-07-25
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28