// import("ORG.Util.Upload");
if(!empty($_FILES['file']['name']))
{
$upload = new \Think\Upload();// 实例化上传类
$upload->maxSize = 93145728 ;
$upload->saveRule =time;
$upload->exts = array('xls','xlsx');
$upload->rootPath = './Uploads/';
$upload->savePath = '';
$upload->saveName = array('uniqid', '');
//$upload->savePath = 'excel/'; // 设置附件上传(子)目录
$info = $upload->upload();
//var_dump($info);exit;
if(!$info)
{
$this->error($upload->getError());
}
//$objPHPExcel = new \PHPExcel();
import("Org.Util.PHPExcel");
import("Org.Util.PHPExcel.IOFactory");
$file_name=$info['file']['savepath'].$info['file']['savename'];
//var_dump($file_name);exit;
$objPHPExcel = \PHPExcel_IOFactory::load($file_name);
$objPHPExcel->setActiveSheetIndex(0);
//$sheet0=$objPHPExcel->getSheet(0);
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
for($i=3;$i<=$highestRow;$i++)
{
$sex = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
$data['sex']=$sex=='男'?1:0;
M('Member')->add($data);
}
$this->success('导入成功!');
}else
{
$this->error("请选择上传的文件");
}
}
总是报错。Could not open 2016-08-18/Array for reading! File does not exist.请各位高手看看怎么回事
最佳答案