function index() { $field = array('class' => array('heading' => array('data' => '班级', 'width' => '90px'), 'cell' => '{class_name}'), 'name' => array('heading' => array('data' => '学生', 'cell' => '{name}', 'width' => '50px')), 'course_1' => array('heading' => '语文', 'cell' => '{course_1}<br /><span class="rank">{rank_1}</span>'), 'course_2' => array('heading' => '数学', 'cell' => '{course_2}<br /><span class="rank">{rank_2}</span>'), 'course_3' => array('heading' => '英语', 'cell' => '{course_3}<br /><span class="rank">{rank_3}</span>'), 'course_4' => array('heading' => '物理', 'cell' => '{course_4}<br /><span class="rank">{rank_4}</span>'), 'course_5' => array('heading' => '化学', 'cell' => '{course_5}<br /><span class="rank">{rank_5}</span>'), 'course_6' => array('heading' => '生物', 'cell' => '{course_6}<br /><span class="rank">{rank_6}</span>'), 'course_8' => array('heading' => '历史', 'cell' => '{course_8}<br /><span class="rank">{rank_8}</span>'), 'course_7' => array('heading' => '地理', 'cell' => '{course_7}<br /><span class="rank">{rank_7}</span>'), 'course_9' => array('heading' => '政治', 'cell' => '{course_9}<br /><span class="rank">{rank_9}</span>'), 'course_10' => array('heading' => '信息', 'cell' => '{course_10}<br /><span class="rank">{rank_10}</span>'), 'course_sum_3' => array('heading' => '3总', 'cell' => '{course_sum_3}<br /><span class="rank">{rank_sum_3}</span>'), 'course_sum_5' => array('heading' => '5总', 'cell' => '{course_sum_5}<br /><span class="rank">{rank_sum_5}</span>')); $list = $this->table->setFields($field)->trimColumns()->generate($this->score->getList()); $this->load->addViewData('list', $list); $field_avg = array('id' => array('heading' => array('data' => '', 'width' => '154px'), 'cell' => '平均分'), 'course_1' => array('heading' => ''), 'course_2' => array('heading' => ''), 'course_3' => array('heading' => ''), 'course_4' => array('heading' => ''), 'course_5' => array('heading' => ''), 'course_6' => array('heading' => ''), 'course_8' => array('heading' => ''), 'course_7' => array('heading' => ''), 'course_9' => array('heading' => ''), 'course_10' => array('heading' => ''), 'course_sum_3' => array('heading' => ''), 'course_sum_5' => array('heading' => '')); $avg = $this->table->setFields($field_avg)->trimColumns()->generate($this->score->getAvg()); $this->load->addViewData('avg', $avg); if ($this->input->post('export_to_excel')) { model('document'); document_exportHead('成绩.xls'); arrayExportExcel($table); exit; } }
<?php require APPPATH . 'third_party/PHPWord/PHPWord.php'; $PHPWord = new PHPWord(); $section = $PHPWord->createSection(); $PHPWord->addTableStyle('schedule_billdoc', array('borderSize' => 1, 'borderColor' => '333', 'cellMargin' => 100)); $table = $section->addTable('schedule_billdoc'); foreach ($document_catalog as $doctype) { $table->addRow(); $table->addCell(1500)->addText($doctype); $table->addCell(8000); } // Save File $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $_SESSION['username'] . $this->date->now . '.docx'; $path = iconv('utf-8', 'gbk', 'temp/' . $filename); $objWriter->save($path); document_exportHead($filename); readfile($path); unlink($path); exit;