PHP實現Excel匯入執行個體

本文主要和大家分享PHP實現Excel匯入執行個體，首先需要下載PHPexcel傳送門。希望能協助到大家。

檔案解壓後把它放在ThinkPHP\Library\Vendor目錄下

HTML代碼

<div class="form-group">   <!-- <a class="button input-file" style="text-align: center;vertical-align: middle;" href="javascript:void(0);">上傳要發送的號碼檔案<input  size="80" type="file" name="file1" id="file1" onchange="check1()" /></a>!-->    <h3>匯入Excel表：</h3><input  type="file" name="file_stu" />    <input type="submit"  value="匯入" /></div>

PHP代碼

ThinkPHP\Library\Org\Util\下建立一個ExcelToArrary.class.php

<?php/** * Created by PhpStorm. * User: Administrator * Date: 2016/12/6 0006 * Time: 下午 3:23 */namespace Org\Util;class ExcelToArrary{    public function __construct() {        Vendor("Excel.PHPExcel");//引入phpexcel類(注意你自己的路徑)        Vendor("Excel.PHPExcel.IOFactory");    }    public function read($filename,$encode,$file_type)    {        if (strtolower($file_type) == 'xls')//判斷excel表類型為2003還是2007        {            Vendor("Excel.PHPExcel.Reader.Excel5");            $objReader = \PHPExcel_IOFactory::createReader('Excel5');        } elseif (strtolower($file_type) == 'xlsx') {            Vendor("Excel.PHPExcel.Reader.Excel2007");            $objReader = \PHPExcel_IOFactory::createReader('Excel2007');        }        $objReader->setReadDataOnly(true);        $objPHPExcel = $objReader->load($filename);        $objWorksheet = $objPHPExcel->getActiveSheet();        $highestRow = $objWorksheet->getHighestRow();        $highestColumn = $objWorksheet->getHighestColumn();        $highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);        $excelData = array();        for ($row = 1; $row <= $highestRow; $row++) {            for ($col = 0; $col < $highestColumnIndex; $col++) {                $excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();            }        }        return $excelData;    }}

PHP代碼

記得在開頭引入

use Org\Util\ExcelToArrary ;

public function uploadxsl(){    /******************匯入檔案處理*******************/    $tmp_file = $_FILES ['file_stu'] ['tmp_name'];    $file_types = explode(".", $_FILES ['file_stu'] ['name']);    $file_type = $file_types [count($file_types) - 1];    /*判別是不是.xls檔案，判別是不是excel檔案*/    if (strtolower($file_type) != "xlsx" && strtolower($file_type) != "xls") {        $this->error('不是Excel檔案，重新上傳');    }    /*設定上傳路徑*/    $savePath = C('UPLOAD_DIR');    /*以時間來命名上傳的檔案*/    $str = date('Ymdhis');    $file_name = $str . "." . $file_type;    /*是否上傳成功*/    if (!copy($tmp_file, $savePath . $file_name)) {        $this->error('上傳失敗');    }    $ExcelToArrary = new ExcelToArrary();//執行個體化    $res = $ExcelToArrary->read(C('UPLOAD_DIR') . $file_name, "UTF-8", $file_type);//傳參,判斷office2007還是office2003       foreach ($res as $k => $v) //迴圈excel表    {        $k = $k - 1;//addAll方法要求數組必須有0索引        $data[$k]['user_id'] = $_SESSION['admin_id'];        $data[$k]['mobile_user'] = $v [0];//建立二維數組        $data[$k]['mobile'] = $v [1];    }    $db = M('user_db');//資料庫    $db->addAll($data);}

最後可能出現的問題

Fatal error: Class 'PHPExcel_IOFactory' not found

解決方案：PHPExcel_IOFactory前面加個\