Beispiel #1
0
 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;