php excel 获取列数,利用PHPEXCEL读取EXCEL内容，主要是读取EXCEL可用列数 | 学步园...

require_once '../Classes/PHPExcel.php';

$objPHPExcel = PHPExcel_IOFactory::load('simple.xls');

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

echo 'Excel中的内容为:
';

$rows = $objActiveSheet->getHighestRow();

$cols = getExcelColByCellName($objActiveSheet->getHighestColumn());

for($row=1;$row<=$rows;$row++)

{

for($col=0;$col

{

echo $objActiveSheet->getCellByColumnAndRow($col, $row)->getValue()."       ";

}

echo '
';

}

function getExcelColByCellName($cellName)

{

$cellCol = 0;

$baseArray = getBaseArray();

$cellNameLength = strlen($cellName);

for($i=0; $i< $cellNameLength; $i++)

{

$value = $cellName["$i"];

if( $i==$cellNameLength -1 )

{

$cellCol = $cellCol + $baseArray["$value"];

}

else

{

$cellCol = $cellCol + $baseArray["$value"]*26*($cellNameLength-1);

}

}

return $cellCol-1;

}

function getBaseArray()

{

$AAscii = ord('A');

$ZAscii = ord('Z');

$baseArray = array();

$i = 1;

for($curIndex = $AAscii;$curIndex <= $ZAscii;$curIndex++)

{

$key = chr($curIndex);

$baseArray["$key"] = $i;

$i++;

}

return $baseArray;

}

?>