PHPExcel按单元格读取数据
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 import('ORG.Util.PHPExcel.PHPExcel'); 2 $objReader = new PHPExcel_Reader_Excel2007(); //use excel2007 3 $objPHPExcel = $objReader->load($filename); //指定的文件 4 $sheet = $objPHPExcel->getSheet(0); 5 $highestRow = $sheet->getHighestRow(); // 取得总行数 6 $highestColumn = $sheet->getHighestColumn(); // 取得总列数 7 8 for($j = 1;$j <= $highestRow; $j++) { 9 $cell = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue(); 10 $data[] = array('typeid'=>$ggtid, 'serverid'=>$ggsid, 'cardno'=>$cell); 11 }