php 读取 excel 文件的简单实例

这篇文章介绍了

php 读取 excel 文件的简单实例，有需要的朋友可以参考一下

代码如下

:

 

     

$this

->loadexcel();

//半酣 phpexcel 文件

            

$_ReadExcel

 = 

new

 PHPExcel_Reader_Excel2007();

            

if

(!

$_ReadExcel

->canRead('link.xls')){

            

$_ReadExcel

 = 

new

 PHPExcel_Reader_Excel5();

            

}

            

$_phpExcel

 = 

$_ReadExcel

->load('link.xls');

            

$sheetCount

 = 

$_phpExcel

->getSheetCount();

            

$newExcel

 = 

array

();

            

$excelData

 = 

array

();

            

for

(

$s

 = 0;

$s

<

$sheetCount

;

$s

++) {

                

$currentSheet

 = 

$_phpExcel

->getSheet(

$s

);

                

$allColumn

 = 

$currentSheet

->getHighestColumn();

                

$allRow

 = 

$currentSheet

->getHighestRow();

                

for

(

$r

 = 1;

$r

<=

$allRow

;

$r

++){

 

                    

for

(

$currentColumn

='A';

$currentColumn

<=

$allColumn

;

$currentColumn

++){

                        

$address

 = 

$currentColumn

.

$r

;

                        

$newExcel

[] = 

$currentSheet

->getCell(

$address

)->getValue();

                    

}

                

}

            

}

 
后面就是对数组的操作了

--不过要先下载好 phpexcel，并包含进来