public function read($filename,$encode='utf-8')
{
$objReader=PHPExcel_IOFactory::createReader('Excel5');
$objReader=setReadDataOnly(true);//只读取指定的sheet
$objPHPExcel=$objReader->load($filename);//读取excel文件
$objWorksheet=$objPHPExcel->getActiveSheet();
$objWorksheet->getHighestRow(); //这一行出现问题?????????
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$excelData = array();
for ($row = 1; $row <= $highestRow; $row++) {
for ($col = 0; $col < $highestColumnIndex; $col++) {
$excelData[$row][] =(string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
}
}
return $execlData;
}
}
Parse error: syntax error, unexpected '$objWorksheet' (T_VARIABLE) in ;(出问题的行已标出)
答案:2 悬赏:80
解决时间 2021-04-27 22:41
- 提问者网友:纹身骑士
- 2021-04-27 06:28
最佳答案
- 二级知识专家网友:初心未变
- 2021-04-27 07:34
在$objPHPExcel=$objReader->load($filename);
之前加上
$objPHPExcel = new PHPExcel();
之前加上
$objPHPExcel = new PHPExcel();
全部回答
- 1楼网友:桃花别处起长歌
- 2021-04-27 08:20
试试这个:
$inquery = "insert into '@__member' ('mtype' ,'userid' ,'pwd' ,'uname' ,'sex' ,'rank' ,'money' ,'email' ,'scores' , 'matt', 'spacesta' ,'face','safequestion','safeanswer' ,'jointime' ,'joinip' ,'logintime' ,'loginip' ) values ('$mtype','$userid','$pwd','$uname','$sex','10','$dfmoney','$email','$dfscores', '0','$spacesta','','$safequestion','$safeanswer','$jointime','$joinip','$logintime','$loginip'); ";
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息!
大家都在看
推荐信息