excel的匯入匯出

匯入

    public function excel_put(){          //先做一個檔案上傳，儲存檔案          $path=$_FILES['file'];          $filePath = "uploads/".$path["name"];          move_uploaded_file($path["tmp_name"],$filePath);          //預設用excel2007讀取excel，若格式不對，則用之前的版本進行讀取          //表格欄位名字          $data=array('B'=>'name','C'=>'pwd','D'=>'money1','E'=>'salt');          $tablename='user1';//表名字          $this->excel_fileput($filePath,$data,$tablename);          }      private function excel_fileput($filePath,$data,$tablename){          $this->load->library("phpexcel");//ci架構中引入excel類          $PHPExcel = new PHPExcel();          $PHPReader = new PHPExcel_Reader_Excel2007();          if(!$PHPReader->canRead($filePath)){              $PHPReader = new PHPExcel_Reader_Excel5();              if(!$PHPReader->canRead($filePath)){                  echo 'no Excel';                  return ;              }          }          // 載入excel檔案          $PHPExcel = $PHPReader->load($filePath);                // 讀取excel檔案中的第一個工作表          $currentSheet = $PHPExcel->getSheet(0);          // 取得最大的列號          $allColumn = $currentSheet->getHighestColumn();          // 取得一共有多少行          $allRow = $currentSheet->getHighestRow();                // 從第二行開始輸出，因為excel表中第一行為列名          for($currentRow = 2;$currentRow <= $allRow;$currentRow++){              /**從第A列開始輸出*/              //echo $allColumn;                            for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){                    $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();                  //print_r($val);                  //die;                                    if($currentColumn == 'A')                  {                      //echo $val."\t";                  }else if($currentColumn <= $allColumn){                      $data1[$currentColumn]=$val;                  }              }              foreach($data as $key=>$val){                  $data2[$val]=$data1[$key];              }              $this->db->insert($tablename,$data2);              //print_r($data2);              //echo "
";                 }          //echo "\n";          echo "匯入成功";      }  

匯出

    header("Content-type:application/vnd.ms-excel");      header("Content-Disposition:attachment;filename=123.xls");            $array=$this->db->get("shop_address")->result_array();      $str = "Id\tName\tPid\n";      foreach ($array as $val) {          $str .=  $val['id'] . "\t" .$val['name'] . "\t" . $val['pid'] . "\n";      }      echo $str;    

以上就介紹了 excel的匯入匯出，包括了方面的內容，希望對PHP教程有興趣的朋友有所協助。

