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

/*讀取excel文件，并進(jìn)行相應(yīng)處理*/


$fileName = "url.xls";


if (!file_exists($fileName)) {


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


}


$startTime = time(); //返回當(dāng)前時(shí)間的Unix 時(shí)間戳


require_once './PHPExcel/IOFactory.php';


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


//獲取sheet表格數(shù)目


$sheetCount = $objPHPExcel->getSheetCount();


//默認(rèn)選中sheet0表


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


//獲取表格行數(shù)


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


//獲取表格列數(shù)


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


echo " ";


$dataArr = array();


 


/* 循環(huán)讀取每個(gè)單元格的數(shù)據(jù) */


//行數(shù)循環(huán)


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


//列數(shù)循環(huán) , 列數(shù)是以A列開(kāi)始


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


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


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


}


echo "
消耗的內(nèi)存為：".(memory_get_peak_usage(true) / 1024 / 1024)."M";


$endTime = time();


echo " ";


var_dump($dataArr);


$dataArr = NULL;}

以上是由福州網(wǎng)站建設(shè)的小編為你分享了"phpexcel讀取excel文件內(nèi)容 phpexcel下載地址"文章，如果你在這方面有什么問(wèn)題，隨時(shí)聯(lián)系我們