换了一种方法做的,没有用laravel封装好的代码写,贴上自己的php代码:
$excel = new PHPExcel();
$file = $_FILES'excelImport';
$filename =time().substr($_FILES['excelImport'['name'],strrpos($_FILES'excelImport','.'));
if(move_uploaded_file($_FILES['excelImport']['tmp_name'], $filename)) {
$objReader =PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel= $objReader->load($filename);
$objWorksheet= $objPHPExcel->getActiveSheet();
$highestRow =$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();
}
}
var_dump($excelData);
这样就能打印出自己想要的数据了!