phpexcel下载地址  https://github.com/PHPOffice/PHPExcel

/*读取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 " ";


$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 " ";


var_dump($dataArr);


$dataArr = NULL;}

以上是由福州网站建设的小编为你分享了"phpexcel读取excel文件内容 phpexcel下载地址"文章，如果你在这方面有什么问题，随时联系我们