- <?php
- require_once( FCPATH.'vendor/Excel/excel/PHPExcel/IOFactory.php');
- function readexcel( $filePath) {
- $PHPReader = new PHPExcel_Reader_Excel5();
- if(!$PHPReader->canRead($filePath)){
- $PHPReader = new PHPExcel_Reader_Excel5();
- if(!$PHPReader->canRead($filePath)){
- echo 'no Excel';
- return ;
- }
- }
- $PHPExcel = $PHPReader->load($filePath);
- $currentSheet = $PHPExcel->getSheet(0); /**取得一共有多少列*/
- $allColumn = $currentSheet->getHighestColumn(); /**取得一共有多少行*/
- $allRow = $currentSheet->getHighestRow();
- $all = array();
- for( $currentRow = 1 ; $currentRow <= $allRow ; $currentRow++){
- $flag = 0;
- $col = array();
- for($currentColumn='A'; getascii($currentColumn) <= getascii($allColumn) ; $currentColumn++){
- $address = $currentColumn.$currentRow;
- $string = $currentSheet->getCell($address)->getValue();
- $col[$flag] = $string;
- $flag++;
- }
- $all[] = $col;
- }
- return $all;
- }
- function getascii( $ch) {
- if( strlen( $ch) == 1)
- return ord( $ch)-65;
- return ord($ch[1])-38;
- }
- //该片段来自于http://www.codesnippet.cn/detail/020120148366.html
来源: http://www.codesnippet.cn/detail/020120148366.html