php读取execl 实例,php读取excel文件的简单实例

$this->loadexcel();//半酣phpexcel文件

$_ReadExcel = new PHPExcel_Reader_Excel2007();

if(!$_ReadExcel->canRead('link.xls')){

$_ReadExcel = new PHPExcel_Reader_Excel5();

}

$_phpExcel = $_ReadExcel->load('link.xls');

$sheetCount = $_phpExcel->getSheetCount();

$newExcel = array();

$excelData = array();

for($s = 0;$s

$currentSheet = $_phpExcel->getSheet($s);

$allColumn = $currentSheet->getHighestColumn();

$allRow = $currentSheet->getHighestRow();

for($r = 1;$r<=$allRow;$r++){

for($currentColumn='A';$currentColumn<=$allColumn;$currentColumn++){

$address = $currentColumn.$r;

$newExcel[] = $currentSheet->getCell($address)->getValue();

}

}

}