php读excel统计多少条数据,如何找到从PHPExcel的Excel文件中读取多少行和列？

使用以下代码，我可以从PHPExcel的Excel文件中读取单元格。

我目前手动定义要读取多少行和列。

有一种方法PHPExcel可以告诉我有多少行和列我必须阅读，以获取所有的数据从工作表，例如。即使某些行和列留空吗？

$file_name = htmlentities($_POST['file_name']);

$sheet_name = htmlentities($_POST['sheet_name']);

$number_of_columns = htmlentities($_POST['number_of_columns']);

$number_of_rows = htmlentities($_POST['number_of_rows']);

$objReader = PHPExcel_IOFactory::createReaderForFile("data/" . $file_name);

$objReader->setLoadSheetsOnly(array($sheet_name));

$objReader->setReadDataOnly(true);

$objPHPExcel = $objReader->load("data/" . $file_name);

echo '

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

echo '

';

for ($column = 0; $column < $number_of_columns; $column++) {

$value = $objPHPExcel->setActiveSheetIndex(0)->getCellByColumnAndRow($column, $row)->getValue();

echo '

';

echo $value . ' ';

echo '

';

}

echo '

';

}

echo '

';

解：

谢谢，马克，这里是这些功能的完整解决方案：

$file_name = htmlentities($_POST['file_name']);

$sheet_name = htmlentities($_POST['sheet_name']);

$number_of_columns = htmlentities($_POST['number_of_columns']);

$number_of_rows = htmlentities($_POST['number_of_rows']);

$objReader = PHPExcel_IOFactory::createReaderForFile("data/" . $file_name);

$objReader->setLoadSheetsOnly(array($sheet_name));

$objReader->setReadDataOnly(true);

$objPHPExcel = $objReader->load("data/" . $file_name);

$highestColumm = $objPHPExcel->setActiveSheetIndex(0)->getHighestColumn();

$highestRow = $objPHPExcel->setActiveSheetIndex(0)->getHighestRow();

echo 'getHighestColumn() = [' . $highestColumm . ']
';

echo 'getHighestRow() = [' . $highestRow . ']
';

echo '

foreach ($objPHPExcel->setActiveSheetIndex(0)->getRowIterator() as $row) {

$cellIterator = $row->getCellIterator();

$cellIterator->setIterateOnlyExistingCells(false);

echo '

';

foreach ($cellIterator as $cell) {

if (!is_null($cell)) {

$value = $cell->getCalculatedValue();

echo '

';

echo $value . ' ';

echo '

';

}

}

echo '

';

}

echo '

';