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下載地址"文章，如果你在這方面有什么問題，隨時聯系我們