YII中使用PHPExcel导入导出 - CSDN博客-tutorial php-php.cn

YII中使用PHPExcel导入导出 - CSDN博客

不言

Lepaskan： 2023-03-28 16:52:01

asal

1789 orang telah melayarinya

1.将phpexcel解压到protected/vendor目录当中。目录结构为vendor/PHPExcel/PHPExcel.php

2.修改index.php文件

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

Salin selepas log masuk

3.导出Excel文件

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

Salin selepas log masuk

4.导入Excel文件的。

   $file = CUploadedFile::getInstance($model,&#39;brand_model_file&#39;);
   var_dump($file->getType());
   if(in_array($file->getType(),array(&#39;application/vnd.ms-excel&#39;,&#39;application/excel&#39;,&#39;application/msexcel&#39;,&#39;application/kset&#39;)) )
   {
    $excelFile = $file->getTempName();
    //$phpexcel = new PHPExcel;
    $excelReader = PHPExcel_IOFactory::createReader(&#39;Excel5&#39;);
    $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);

Salin selepas log masuk

以上就是本篇文章的全部内容了，感谢大家阅读。