获取sheet 有效效值行列数
$maxCell = $objWorksheet->getHighestRowAndColumn();
$data = $objWorksheet->rangeToArray('A1:' . $maxCell['column'] . $maxCell['row']);获取单个单元格的值
方式1
$objPHPExcel->getActiveSheet()->getCellByColumnAndRow(1, 8)->getValue();方式2
$objPHPExcel->getActiveSheet()->getCell('B8')->getValue();获取区域单元格的值
$objPHPExcel->setActiveSheetIndex(0)->rangeToArray('A1:C3');