php读取excel文件的实例代码。
代码:
<?php
/* *
* php读取excel文件
* by www.jbxue.com
*/
$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< $sheetCount; $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();
}
}
}
/* *
* php读取excel文件
* by www.jbxue.com
*/
$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< $sheetCount; $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();
}
}
}
后面就是对数组的操作了--不过要先下载好phpexcel,并包含进来。