<?php
$data = "./data/1.xls";
vendor('PHPExcel');
$objReader = \PHPExcel_IOFactory::identify($data);
$obj_PHPExcel = \PHPExcel_IOFactory::createReader($objReader);
$objPHPExcel = $obj_PHPExcel->load($data);
$sheet_count = $objPHPExcel->getSheetCount(); // 获取excel 的sheet个数
for($i=0;$i<=$sheet_count-1;$i++){
$sheet = $objPHPExcel->getSheet($i);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
for($row=3;$row<$highestRow;$row++){ // 从第三行开始查询
$rowdata = $sheet->rangeToArray('B'. $row . ":" . $highestColumn . $row, NULL,TRUE,FALSE);
var_dump($rowdata);
}
}