php excel读取,phpexcel
Jun 13, 2016 am 08:40 AM
excel表格
php excel读取,phpexcel
当然首先要判断是否有文件和文件类型,接着把文件保存到某个路径中
<span>/*</span><span>* * 读取excel数据 * @author Red * @date * @param $filename 文件所在路径+文件名 * @param string $encode * @param $file_type * @return array </span><span>*/</span> <span>function</span> readExcel(<span>$filename</span>, <span>$encode</span> = 'utf-8', <span>$file_type</span><span>) { </span><span>include</span> './plugins/excel/PHPExcel.php'<span>; </span><span>include</span> './plugins/excel/PHPExcel/Reader/Excel2007.php'<span>; </span><span>include</span> './plugins/excel/PHPExcel/Writer/Excel5.php'<span>; </span><span>include</span> './plugins/excel/PHPExcel/Writer/Excel2007.php'<span>; </span><span>if</span> (<span>$file_type</span> == 'xlsx'<span>) { </span><span>$objReader</span> = PHPExcel_IOFactory::createReader('Excel2007'<span>); } </span><span>else</span><span> { </span><span>$objReader</span> = PHPExcel_IOFactory::createReader('Excel5'<span>); } </span><span>$objReader</span>->setReadDataOnly(<span>true</span><span>); </span><span>$objPHPExcel</span> = <span>$objReader</span>->load(<span>$filename</span><span>); </span><span>$objWorksheet</span> = <span>$objPHPExcel</span>-><span>getActiveSheet(); </span><span>$hightestrow</span> = <span>$objWorksheet</span>-><span>getHighestRow(); </span><span>$highestColumn</span> = <span>$objWorksheet</span>-><span>getHighestColumn(); </span><span>$highestColumnIndex</span> = PHPExcel_Cell::columnIndexFromString(<span>$highestColumn</span><span>); </span><span>$excelData</span> = <span>array</span><span>(); //从第二行开始 </span><span>for</span> (<span>$row</span> = 2; <span>$row</span> <= <span>$hightestrow</span>; <span>$row</span>++<span>) { </span><span>for</span> (<span>$col</span> = 0; <span>$col</span> < <span>$highestColumnIndex</span>; <span>$col</span>++<span>) { </span><span>$excelData</span>[<span>$row</span>][] = (<span>string</span>)<span>$objWorksheet</span>->getCellByColumnAndRow(<span>$col</span>, <span>$row</span>)-><span>getValue(); } } </span><span>return</span> <span>$excelData</span><span>; }</span>
登入後複製
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn

熱門文章
擊敗分裂小說需要多長時間?
3 週前
By DDD
倉庫:如何復興隊友
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
1 週前
By 尊渡假赌尊渡假赌尊渡假赌
公眾號網頁更新緩存難題:如何避免版本更新後舊緩存影響用戶體驗?
3 週前
By 王林

熱門文章
擊敗分裂小說需要多長時間?
3 週前
By DDD
倉庫:如何復興隊友
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
1 週前
By 尊渡假赌尊渡假赌尊渡假赌
公眾號網頁更新緩存難題:如何避免版本更新後舊緩存影響用戶體驗?
3 週前
By 王林

熱門文章標籤

記事本++7.3.1
好用且免費的程式碼編輯器

SublimeText3漢化版
中文版,非常好用

禪工作室 13.0.1
強大的PHP整合開發環境

Dreamweaver CS6
視覺化網頁開發工具

SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)