PHP 导入excel
2015-07-10 11:33 Caoxt 阅读(421) 评论(0) 编辑 收藏 举报db.php为数据库操作类, $config为数据库配置,PHPExcel版本为PHPExcel_1.8.0, PHP代码:
header("Content-type:text/html;charset=utf-8"); $dir = dirname(__FILE__); require $dir . "/PHPExcel/db.php"; require $dir . "/PHPExcel/PHPExcel/IOFactory.php"; $fileName = $dir . "/export.xlsx"; //全部加载 //$object = PHPExcel_IOFactory::load($fileName); //部分加载 $fileType = PHPExcel_IOFactory::identify($fileName); $objReader = PHPExcel_IOFactory::createReader($fileType); $sheetName = "一年级"; $objReader->setLoadSheetsOnly($sheetName); $object = $objReader->load($fileName); //循环输出 foreach($object->getWorksheetIterator() as $sheet) { foreach($sheet->getRowIterator() as $row) { if($row->getRowIndex() < 2) { continue; } foreach($row->getCellIterator() as $cell) { $data = $cell->getValue(); echo $data." "; } echo "<br>"; } echo "<br>"; }
Excel :
效果图: