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();
<?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();
