php读取execl 实例,php读取excel的实例代码

之前我们介绍了php写excel文件的实现代码，今天我们介绍使用PHPExcel读取excel文件，读取出的文件包含标题栏等信息的方法。

注意：单元格第一行以1开始，第一列以0开始

代码：

/**

* php 读取excel文件

* edit by www.jbxue.com

*/

require_once 'PHPExcel.php';

require_once 'PHPExcel/IOFactory.php';

class ExcelHelper{

public function importFileContacts($filename){

try {

//解决文件中文名问题

$filename = iconv("UTF-8","GB2312",$filename);

if (!file_exists($filename)) {

return false;

}

//chmod($filename, 0750);linux下改变文件权限

$filetype = $this->getFileType($filename);

//根据文件类型读取excel文件

if ($filetype == "xlsx") {

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

$objReader->setReadDataOnly(true);

} elseif ($filetype == "xls") {

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

$objReader->setReadDataOnly(true);

} else {

return false;

}

$mems = NULL;

$objPHPExcel = $objReader->load($filename);

$objWorksheet = $objPHPExcel->getActiveSheet();

$highestRow = $objWorksheet->getHighestRow(); // e.g. 10

$highestColumn = $objWorksheet->getHighestColumn(); // e.g 'F'

$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5

for ($row = 1; $row <= $highestRow; $row++) {

for ($col = 0; $col < $highestColumnIndex; $col++) {

$mem[$col] = trim($objWorksheet->getCellByColumnAndRow($col, $row)->getValue());

}

$mems[$row - 1] = $mem;

}

return $mems;

} catch (Exception $e) {

echo 'EXCEL ERROR:' . $e->getMessage();

$errText = "Read excel error:Please retry later!";

return $errText;

}

}

/**

* 获取文件类型

* @param $filenamePath 文件路径或者文件名

*/

private function getFileType($filenamePath){

if (!$filenamePath){

return false;

}

$filenameArr = explode('/', $filenamePath);

$count = count($filenameArr);

$filename = $filenameArr[$count-1];

$filetypeArr = explode('.', $filename);

$count = count($filetypeArr);

$filetype = $filetypeArr[$count-1];

return $filetype;

}

}

?>