本文實例講述了PHPExcel簡單讀取excel文件的方法。分享給大家供大家參考,具體如下:
PHP Excel 2007 classes
Project providing a set of classes for the PHP programming language, which allow you to write to and read from different file formats, like Excel 2007, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.
下載地址:
http://phpexcel.codeplex.com/
讀取某excel文件,得到其每行每列的內容的一個示例:
set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');include 'PHPExcel/IOFactory.php';$reader = PHPExcel_IOFactory::createReader('Excel2007'); // 讀取 excel 文檔$PHPExcel = $reader->load($excelfilename); // 文檔名稱$sheet = $PHPExcel->getSheet(0); // 讀取第一個工作表(編號從 0 開始)$highestRow = $sheet->getHighestRow(); // 取得總行數$highestColumn = $sheet->getHighestColumn(); // 取得總列數$arr = array(1=>'A',2=>'B',3=>'C',4=>'D',5=>'E',6=>'F',7=>'G',8=>'H',9=>'I',10=>'J',11=>'K',12=>'L',13=>'M', 14=>'N',15=>'O',16=>'P',17=>'Q',18=>'R',19=>'S',20=>'T',21=>'U',22=>'V',23=>'W',24=>'X',25=>'Y',26=>'Z');//echo $highestRow.$highestColumn;// 一次讀取一列for ($row = 5; $row <= $highestRow; $row++) { for ($column = 0; $arr[$column] != 'T'; $column++) { $val = $sheet->getCellByColumnAndRow($column, $row)->getValue(); echo $val; }}