【代码段】PHP读取excel文件内容、获取单元格数据

/*读取excel文件，并进行相应处理*/

$fileName = "url.xls";

if (!file_exists($fileName)) {

    exit("文件".$fileName."不存在");

}

$startTime = time(); //返回当前时间的Unix 时间戳

require_once './PHPExcel/IOFactory.php';

$objPHPExcel = PHPExcel_IOFactory::load($fileName);

//获取sheet表格数目

$sheetCount = $objPHPExcel->getSheetCount();

//默认选中sheet0表

$sheetSelected = 0;$objPHPExcel->setActiveSheetIndex($sheetSelected);

//获取表格行数

$rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();

//获取表格列数

$columnCount = $objPHPExcel->getActiveSheet()->getHighestColumn();

echo "
Sheet Count : ".$sheetCount."　　行数： ".$rowCount."　　列数：".$columnCount."
";

$dataArr = array();

 

/* 循环读取每个单元格的数据 */

//行数循环

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

//列数循环 , 列数是以A列开始

for ($column = 'A'; $column <= $columnCount; $column++) {

    $dataArr[] = $objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue();

    echo $column.$row.":".$objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue()."
";

}

echo "
消耗的内存为：".(memory_get_peak_usage(true) / 1024 / 1024)."M";

$endTime = time();

echo "
解析完后，当前的时间为：".date("Y-m-d H:i:s")."　　　

总共消耗的时间为：".(($endTime - $startTime))."秒
";

var_dump($dataArr);

$dataArr = NULL;}