THINKPHP3.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("utf-8","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); }