tp3.2excel表格中出现数字+字符+汉字 导入是空的值 怎么解决。
下面是代码
if (!empty($_FILES)) {
$upload = new \Think\Upload(); // 实例化上传类
$upload->maxSize = 30145728; // 设置附件上传大小
$upload->exts = array('xlsx','xls'); // 设置附件上传类型
$upload->savePath = '/'; // 设置附件上传根目录
$info = $upload->uploadOne($_FILES['import']);
vendor("PHPExcel.PHPExcel");
vendor("PHPExcel.PHPExcel.IOFactory");
$file_name="Uploads".$info['savepath'].$info['savename'];
$objReader = \PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load($file_name,$encode='utf-8');
////*****************评先选优开始***********************////
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
for($i=1;$i<=$highestRow;$i++){
//数据添加数据库
$data['name'] = iconv("gb2312","utf-8",$objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue());
$data['time'] = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
// $data2['area'] = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();
$data['area'] = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();
$data['apellation'] = $objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue();

$data['remarks'] = $objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue();
$data['destatus'] = $objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue();
// dump($data2['area']);
// dump($data2['apellation']);die;
$selection = M("selection");

// $selection->create();
$dao = $selection->add($data);

}