/*** 讀取excel* @$filename 絕對路徑* @return array*/function read_excel($filename){try {vendor('PHPExcel.PHPExcel');//兼容2003和2007版本$objReader = PHPExcel_IOFactory::createReader('Excel5');if (!$objReader->canRead($filename)) {$objReader = PHPExcel_IOFactory::createReader('Excel2007');if (!$objReader->canRead($filename)) {return false;}}$objReader->setReadDataOnly(true);$objPHPExcel = $objReader->load($filename);$objWorksheet = $objPHPExcel->getActiveSheet();$highestRow = $objWorksheet->getHighestRow();$highestColumn = $objWorksheet->getHighestColumn();$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);$excelData = array();if ($highestRow > 20001) {throw new Exception('至多一次導入20000條數據');}for ($row = 1; $row <= $highestRow; $row++) {for ($col = 0; $col < $highestColumnIndex; $col++) {$excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();}}} catch (Exception $e) {$msg = $e->getLine() . ' ' . $e->getMessage() . ' ' . $e->getFile();return $msg;}return $excelData;}

總結

以上是生活随笔為你收集整理的php 读取excel表数据的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。