PHP ExcelExport::setCellValue Examples

Example #1

File: excel_export_ser.php Project: huzhiming12/itil

        case 120:
            $res[$i][9] = "E级 120小时内完成";
            break;
        case 240:
            $res[$i][9] = "F级 240小时内完成";
            break;
        case 480:
            $res[$i][9] = "G级 480小时内完成";
            break;
        case 720:
            $res[$i][9] = "H级 720小时内完成";
            break;
    }
    switch ($res[$i][19]) {
        case 1:
            $res[$i][19] = "未处理";
            break;
        case 2:
            $res[$i][19] = "已指派";
            break;
        case 3:
            $res[$i][19] = "已取消";
            break;
        case 4:
            $res[$i][19] = "已解决";
            break;
    }
}
$excel->setCellTitle($cell, $title);
$excel->setCellValue($res);
$excel->export();

Example #2

File: test.php Project: huzhiming12/itil

<?php

/**
 * Created by PhpStorm.
 * User: huzhiming
 * Date: 2015/10/8
 * Time: 22:14
 */
require_once "ExcelExport.php";
$excel = new ExcelExport();
$cell = array("姓名", "电话", "手机号");
$value = array(array("张三", "122334<a></a>", NULL), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"), array("李四", "23908u0", "3345354343345"));
$excel->setCellTitle($cell, "学生通信录");
$excel->setCellValue($value);
$excel->export();