1 <?php  
 2 set_include_path(get_include_path() . PATH_SEPARATOR . '../Classes/');  
 3 include 'PHPExcel.php';   
 4 include 'PHPExcel/IOFactory.php';  
 5 /**对excel里的日期进行格式转化*/   
 6 function GetData($val){   
 7 $jd = GregorianToJD(1, 1, 1970);   
 8 $gregorian = JDToGregorian($jd+intval($val)-25569);   
 9 return $gregorian;/**显示格式为 “月/日/年” */   
10 }   
11 $filePath = 'Book1.xls';   
12 $PHPExcel = new PHPExcel();   
13 $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)  
14 //$PHPExcel = $PHPReader->load($filePath);   
15 $PHPExcel = $reader->load($filePath);   
16 /**读取excel文件中的第一个工作表*/   
17 $currentSheet = $PHPExcel->getSheet(0);   
18 /**取得最大的列号*/   
19 $allColumn = $currentSheet->getHighestColumn();   
20 /**取得一共有多少行*/   
21 $allRow = $currentSheet->getHighestRow();   
22 /**从第一行开始输出，因为excel表中第一行为列名*/   
23 for($currentRow = 1;$currentRow <= $allRow;$currentRow++){   
24 /**从第A列开始输出*/     
25 for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){   
26 $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();/**ord()将字符转为十进制数*/   
27 if($currentColumn == 'A')   
28 {   
29 echo GetData($val)."\t";   
30 }else{   
31 //echo $val;   
32 /**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将gb2312编码转为utf-8编码输出*/   
33 echo iconv('utf-8','gb2312', $val)."\t";   
34 }   
35 }   
36 echo "</br>";   
37 }   
38 echo "\n";   
39 ?>