php 数组 excel,PHPExcel文件如何导入成数组（选择指定的列）？

$dir=dirname(__FILE__);//找到当前脚本所在路径

require $dir."/PHPExcel/PHPExcel/IOFactory.php";//引入读取excel的类文件

$filename=$dir."/lang.xlsx";

$objReader = PHPExcel_IOFactory::createReader('Excel5');

$objPHPExcel = $objReader->load($file_name,$encode='utf-8');

$sheet = $objPHPExcel->getSheet(0);

$highestRow = $sheet->getHighestRow(); // 取得总行数

$highestColumn = $sheet->getHighestColumn(); // 取得总列数

for($i=1;$i<=$highestRow;$i++)

{

$data=array();

$data['A']=$objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();

$data['A']=$this->geshihua($data['A']);

$data['B']=$objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();

$data['B']=$this->geshihua($data['B']);

$data['C']=$objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();

$data['C']=$this->geshihua($data['C']);

$data['D']=$objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();

$data['D']=$this->geshihua($data['D']);

$data['E']=$objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue();

$data['E']=$this->geshihua($data['E']);

$data['F']=$objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue();

$data['F']=$this->geshihua($data['F']);

$data['G']=$objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue();

$data['G']=$this->geshihua($data['G']);

$data['H']=$objPHPExcel->getActiveSheet()->getCell("H".$i)->getValue();

$data['H']=$this->geshihua($data['H']);

$data['I']=$objPHPExcel->getActiveSheet()->getCell("I".$i)->getValue();

$data['I']=$this->geshihua($data['I']);

$data['J']=$objPHPExcel->getActiveSheet()->getCell("J".$i)->getValue();

$data['J']=$this->geshihua($data['J']);

$data['K']=$objPHPExcel->getActiveSheet()->getCell("K".$i)->getValue();

$data['K']=$this->geshihua($data['K']);

if(trim($data['A'])<>''){

$_data[]=$data;

}

}

$_data就是遍历的数组，你看着模仿就可以ABCD代表对应的行