0) { returnJSON(ERROR_INVALID, $_FILES["file"]["error"]); }"/> 0) { returnJSON(ERROR_INVALID, $_FILES["file"]["error"]); }">

Home  >  Article  >  Backend Development  >  php Excel import multiple tables

php Excel import multiple tables

伊谢尔伦
伊谢尔伦Original
2016-11-29 10:28:381619browse

//参数初始化
     $filePath = '';
  
     if ($_FILES["file"]["error"] > 0) {
       returnJSON(ERROR_INVALID, $_FILES["file"]["error"]);
     }
      //建立reader对象
        $this->load->library('PHPExcel');
        $PHPReader = new PHPExcel_Reader_Excel2007();
        if (!$PHPReader->canRead($filePath)) {//如果不是excel2007,尝试使用excel5
            $PHPReader = new PHPExcel_Reader_Excel5();
            if (!$PHPReader->canRead($filePath)) {
                returnJSON(ERROR_INVALID, 'excel not existing');
            }
        }
  
        //建立excel对象,此时你即可以通过excel对象读取文件,也可以通过它写入文件
        $PHPExcel = $PHPReader->load($filePath);
  
        //导入第一个工作表的数据
        $this->db->truncate('dzg_card_info'); //清理表
        $currentSheet = $PHPExcel->getSheet(0); //读取excel文件中的第一个工作表
        $columnCount = $currentSheet->getHighestColumn(); //取得最大的列号
        $rowCount = $currentSheet->getHighestRow(); //取得一共有多少行
        for ($rowIndex = 2; $rowIndex <= $rowCount; $rowIndex++) {
            $name = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $currentSheet->getCell(&#39;B&#39; . $rowIndex)->getValue());
            $skill = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $currentSheet->getCell(&#39;C&#39; . $rowIndex)->getValue());
            $create_time = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $currentSheet->getCell(&#39;D&#39; . $rowIndex)->getValue());
            $this->admin_model->insertCardInfo($name, $skill, $create_time);
        }
  
        //导入第二个工作表
        $this->db->truncate(&#39;dzg_card_message&#39;); //清理表
        $currentSheet = $PHPExcel->getSheet(1); //读取excel文件中的第一个工作表
        $columnCount = $currentSheet->getHighestColumn(); //取得最大的列号
        $rowCount = $currentSheet->getHighestRow(); //取得一共有多少行
        for ($rowIndex = 2; $rowIndex <= $rowCount; $rowIndex++) {
            $uid = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $currentSheet->getCell(&#39;B&#39; . $rowIndex)->getValue());
            $message = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $currentSheet->getCell(&#39;C&#39; . $rowIndex)->getValue());
            $this->admin_model->insertCardMsg($uid, $message);
	}
<form action="index.php?c=admin&m=importExcel&d=admin"method="post"enctype="multipart/form-data">
<labelfor="file">导入excel:</label>
<input type="file"name="file"id="file"/>
<input type="submit"name="submit"value="提交"/>
</form>


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn