YII使用PHPExcel導入匯出 - CSDN博客

1.將phpexcel解壓縮到protected/vendor目錄當中。目錄結構為vendor/PHPExcel/PHPExcel.php

2.修改index.php檔案

require_once($yii);
$app=Yii::createWebApplication($config);//->run();
// adding PHPExcel autoloader
Yii::import('application.vendor.*');
require_once "PHPExcel/PHPExcel.php";
require_once "PHPExcel/PHPExcel/Autoloader.php";
Yii::registerAutoloader(array('PHPExcel_Autoloader','Load'), true);
$app->run();

3.匯出Excel檔案

 public function actionExcel(){
  $objPHPExcel = new PHPExcel();
  $objPHPExcel->setActiveSheetIndex(0)
   ->setCellValue('A1', 'Hello')
   ->setCellValue('B2', 'world!')
   ->setCellValue('C1', 'Hello')
   ->setCellValue('D2', 'world!');
  $objPHPExcel->getActiveSheet()->setTitle('Simple');
  $objPHPExcel->setActiveSheetIndex(0);
  ob_end_clean();
  ob_start();
  header('Content-Type: application/vnd.ms-excel');
  header('Content-Disposition: attachment;filename="test.xls"');
  header('Cache-Control: max-age=0');
  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  $objWriter->save('php://output');
 }

4.匯入Excel文件的。

   $file = CUploadedFile::getInstance($model,'brand_model_file');
   var_dump($file->getType());
   if(in_array($file->getType(),array('application/vnd.ms-excel','application/excel','application/msexcel','application/kset')) )
   {
    $excelFile = $file->getTempName();
    //$phpexcel = new PHPExcel;
    $excelReader = PHPExcel_IOFactory::createReader('Excel5');
    $phpexcel = $excelReader->load($excelFile)->getSheet(0);
    $total_line = $phpexcel->getHighestRow();
    $total_column = $phpexcel->getHighestColumn();
    $allData = array();
    for ($row = 1; $row <= $total_line; $row++) {
     $data = array();
     for ($column = &#39;A&#39;; $column <= $total_column; $column++) {
      $data[] = trim($phpexcel->getCell($column.$row) -> getValue());
     }
     array_push($allData, $data);
    }
    print_r($allData);

以上就是本篇文章的全部內容了，感謝大家閱讀。

相關推薦：

PHP使用PHPExcel實作批次上傳到資料庫

如何解決IE瀏覽器使用PHPExcel匯出檔案時檔案名中文亂碼的問題

以上是YII使用PHPExcel導入匯出 - CSDN博客的詳細內容。更多資訊請關注PHP中文網其他相關文章！