phpexcel類庫讀取excel檔案的例子

require_once('include/common.inc.php'); require_once(rootpath . 'include/phpexcel/phpexcel/iofactory.php'); $filepath = './file/xls/110713.xls'; $filetype = phpexcel_iofactory::identify($filepath); //檔案名稱自動判斷檔案類型 $objreader = phpexcel_iofactory::createreader($filetype); $objphpexcel = $objreader->load($filepath); $currentsheet = $objphpexcel->getsheet(0); //第一個活頁簿 $allrow = $currentsheet->gethighestrow(); //行數 $output = array(); $pretype = ''; #// bbs.it-home.org $qh = $currentsheet->getcell('a4')->getvalue(); //按照檔案格式從第7行開始迴圈讀取資料 for($currentrow = 7;$currentrow<=$allrow;$currentrow++){ //判斷每一行的b列是否為有效序號，如果為空白或者小於之前的序號則結束 $xh = (int)$currentsheet->getcell('b'.$currentrow)->getvalue(); if(empty($xh))break; $tmptype = (string)$currentsheet->getcell('c'.$currentrow)->getvalue(); //賽事類型 if(!empty($tmptype))$pretype = $tmptype; $output[$xh]['type'] = $pretype; $output[$xh]['master'] = $currentsheet->getcell('f'.$currentrow)->getvalue(); //主隊 $output[$xh]['guest'] = $currentsheet->getcell('h'.$currentrow)->getvalue(); //客隊 } //從當前行開始往下迴圈，取出第一個不為空白的行 for( ; ; $currentrow++){ $xh = (int)$currentsheet->getcell('b'.$currentrow)->getvalue(); if(!empty($xh))break; } for( ; $currentrow <= $allrow; $currentrow++){ $xh = (int)$currentsheet->getcell('b'.$currentrow)->getvalue(); if(empty($xh))break; $output[$xh]['rq'] = $currentsheet->getcell('i'.$currentrow)->getvalue(); } header("content-type:text/html; charset=utf-8"); echo '期號：' . $qh . "\n\n"; if(!empty($output)){ printf("%-5s\t%-15s\t%-40s\t%-40s\t%-5s\n", '序號', '賽事類型', '主隊', '客隊', '讓球值'); foreach($output as $key => $row){ $format = "%-5d\t%-15s\t%-40s\t%-40s\t%-5s\n"; printf($format, $key, $row['type'], $row['master'], $row['guest'], $row['rq']); } } ?> 複製代碼

