PHPExcel 读取Excel以xlsx格式的文件

(1)首先从github上下载PHPExcel,
(2)拷贝到本地服务器运行的文件夹下
(3)载入PHPExcel类和IOFactory类
(4)读取excel文件
(5)读取行列对应的数值即可

<?phprequire_once dirname(__FILE__) . '/Classes/PHPExcel.php';require_once dirname(__FILE__) . '/Classes/PHPExcel/IOFactory.php';$path = "./data.xlsx";$fileType = PHPExcel_IOFactory::identify($path);$objReader = PHPExcel_IOFactory::createReader($fileType);$objPHPExcel = $objReader->load($path);$currentSheet = $objPHPExcel->getSheet(0);for ($i = 10; $i <= 17; $i++){    $result = (string) ($currentSheet->getCell('I'.$i)->getValue());    echo $result . "</br>";}

参考文章链接