目錄
php excel读取,phpexcel
首頁 php教程 php手册 php excel读取,phpexcel

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 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前 By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
1 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱門文章

倉庫:如何復興隊友
3 週前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前 By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
1 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱門文章標籤

記事本++7.3.1

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

SublimeText3漢化版

中文版,非常好用

禪工作室 13.0.1

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

SublimeText3 Mac版

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

Excel表格中明明有資料但篩選空白怎麼辦? Excel表格中明明有資料但篩選空白怎麼辦? Mar 13, 2024 pm 06:38 PM

Excel表格中明明有資料但篩選空白怎麼辦?

deepseek怎麼轉換pdf deepseek怎麼轉換pdf Feb 19, 2025 pm 05:24 PM

deepseek怎麼轉換pdf

Excel表格怎麼求平均值 Excel表格怎麼求平均值 Aug 07, 2023 am 11:16 AM

Excel表格怎麼求平均值

excel表格列印不全一部分印不出來怎麼處理 excel表格列印不全一部分印不出來怎麼處理 Mar 20, 2024 pm 10:26 PM

excel表格列印不全一部分印不出來怎麼處理

Excel表格不能篩選的解決辦法 Excel表格不能篩選的解決辦法 Mar 14, 2024 am 10:20 AM

Excel表格不能篩選的解決辦法

兩個excel表格怎麼同時顯示在螢幕上 兩個excel表格怎麼同時顯示在螢幕上 Mar 20, 2024 pm 01:40 PM

兩個excel表格怎麼同時顯示在螢幕上

deepseek怎麼用來算賬 deepseek怎麼用來算賬 Feb 19, 2025 pm 04:36 PM

deepseek怎麼用來算賬

垂直代理:加密原生代理的應用場景和顛覆性潛力解讀 垂直代理:加密原生代理的應用場景和顛覆性潛力解讀 Mar 04, 2025 am 10:21 AM

垂直代理:加密原生代理的應用場景和顛覆性潛力解讀

See all articles