$objReader = PHPExcel_IOFactory::createReader('Excel2007' ); //创建一个2007的读取对象
$objPHPExcel = $objReader->load ("05featuredemo.xlsx" ); //读取一个xlsx文件
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { //遍历工作表
echo 'Worksheet - ' , $worksheet->getTitle() , PHP_EOL;
foreach ($worksheet->getRowIterator() as $row) { //遍历行
echo ' Row number - ' , $row->getRowIndex() , PHP_EOL;
$cellIterator = $row->getCellIterator(); //得到所有列
$cellIterator->setIterateOnlyExistingCells( false); // Loop all cells, even if it is not set
foreach ($cellIterator as $cell) { //遍历列
if (!is_null($cell)) { //如果列不给空就得到它的坐标和计算的值
echo ' Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue() , PHP_EOL;
}
}
}
}
phpexcel读取文件
最新推荐文章于 2024-02-01 11:50:50 发布