Codeigniter利用PHPExcel导出Excel文件

 
  class Table_export extends CI_Controller {
  
      function __construct()
      {
          parent::__construct();
  
          // Here you should add some sort of user validation
          // to prevent strangers from pulling your table data
      }
  
      function index($table_name)
      {
          $query = $this->db->get($table_name);
  
          if(!$query)
              return false;
  
          // Starting the PHPExcel library
          $this->load->library('PHPExcel');
          $this->load->library('PHPExcel/IOFactory');
  
          $objPHPExcel = new PHPExcel();
          $objPHPExcel->getProperties()->setTitle("export")->setDescription("none");
  
          $objPHPExcel->setActiveSheetIndex(0);
  
          // Field names in the first row
          $fields = $query->list_fields();
          $col = 0;
          foreach ($fields as $field)
          {
              $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field);
              $col++;
          }
  
          // Fetching the table data
          $row = 2;
          foreach($query->result() as $data)
          {
              $col = 0;
              foreach ($fields as $field)
              {
                  $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->$field);
                  $col++;
              }
  
              $row++;
          }
  
          $objPHPExcel->setActiveSheetIndex(0);
  
          $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');
  
          // Sending headers to force the user to download the file
          header('Content-Type: application/vnd.ms-excel');
          header('Content-Disposition: attachment;filename="Products_'.date('dMy').'.xls"');
          header('Cache-Control: max-age=0');
  
          $objWriter->save('php://output');
      }
  
  }

Excel Plugin
The following plugin will generate a tab-delimited file, and feed it to the client as an Excel file.

$this->load->plugin('to_excel');
$this->db->use_table('tablename');
$this->db->select('field1', 'field2');
// run joins, order by, where, or anything else here
$query = $this->db->get();
to_excel($query, ['filename']); // filename is optional, without it, the plugin will default to 'exceloutput'

So you could run:

to_excel($query, 'myfile'); // outputs myfile.xls
to_excel($query); // outputs exceloutput.xls
// you could also use a model here
to_excel($this->model_name->functioncall());

/system/plugins/to_excel_pi.php

/*
* Excel library for Code Igniter applications
* Author: Derek Allard, Dark Horse Consulting, www.darkhorse.to, April 2006
*/

function to_excel($query, $filename='exceloutput')
{
     $headers = ''; // just creating the var for field headers to append to below
     $data = ''; // just creating the var for field data to append to below
    
     $obj =& get_instance();
    
     $fields = $query->field_data();
     if ($query->num_rows() == 0) {
          echo '

The table appears to have no data.