Java中导入、导出Excel

矫情吗；* 2022-05-30 00:42 269阅读 0赞

## [Java中导入、导出Excel][Java_Excel] ##

当前B/S模式已成为应用开发的主流，而在企业办公系统中，常常有客户这样子要求：你要把我们的报表直接用Excel打开(电信系统、银行系统)。或者是：我们已经习惯用Excel打印。这样在我们实际的开发中，很多时候需要实现导入、导出Excel的应用。

目前，比较常用的实现Java导入、导出Excel的技术有两种Jakarta POI和Java Excel

下面我就分别讲解一下如何使用这两个技术实现导入、导出Excel

<table style="border:1px solid #C0C0C0;"> 
 <tbody> 
  <tr> 
   <td style="border-color:#C0C0C0;border-collapse:collapse;padding:3px;">二、使用Jakarta POI导入、导出Excel</td> 
  </tr> 
 </tbody> 
</table>

Jakarta POI 是一套用于访问微软格式文档的Java API。Jakarta POI有很多组件组成，其中有用于操作Excel格式文件的HSSF和用于操作Word的HWPF，在各种组件中目前只有用于操作Excel的HSSF相对成熟。官方主页[http://poi.apache.org/index.html][http_poi.apache.org_index.html]，API文档[http://poi.apache.org/apidocs/index.html][http_poi.apache.org_apidocs_index.html]

### 2.1 环境配置 ###

### 2.1.1下载jar ###

官方下载：[http://poi.apache.org/download.html][http_poi.apache.org_download.html]这里可以下载到它的最新版本和文档，目前最新版本是3.7，这里使用比较稳定的3.6版。

### 2.1.2加入jar包 ###

将根目录下的poi-3.6-20091214.jar和Lib目录下三个通用包 commons-logging-1.1.jar junit-3.8.1.jar log4j-1.2.13.jar拷贝到项目的Lib下

### 2.2 Jakarta POI HSSF API组件 ###

HSSF（用于操作Excel的组件）提供给用户使用的对象在rg.apache.poi.hssf.usermodel包中,主要部分包括Excel对象，样式和格式，还有辅助操作。有以下几种对象：

> 常用组件：
> 
> HSSFWorkbook                      excel的文档对象
> 
> HSSFSheet                         excel的表单
> 
> HSSFRow                           excel的行
> 
> HSSFCell                          excel的格子单元
> 
> HSSFFont                          excel字体
> 
> HSSFDataFormat                    日期格式
> 
> HSSFHeader                        sheet头
> 
> HSSFFooter                        sheet尾（只有打印的时候才能看到效果）
> 
> 样式：
> 
> HSSFCellStyle                       cell样式
> 
> 辅助操作包括：
> 
> HSSFDateUtil                        日期
> 
> HSSFPrintSetup                      打印
> 
> HSSFErrorConstants                  错误信息表

### 2.3 基本操作步骤 ###

首先，理解一下一个Excel的文件的组织形式，一个Excel文件对应于一个workbook(HSSFWorkbook)，一个workbook可以有多个sheet（HSSFSheet）组成，一个sheet是由多个row（HSSFRow）组成，一个row是由多个cell（HSSFCell）组成。

基本操作步骤：

> 1、用HSSFWorkbook打开或者创建“Excel文件对象”
> 
> 2、用HSSFWorkbook对象返回或者创建Sheet对象
> 
> 3、用Sheet对象返回行对象，用行对象得到Cell对象
> 
> 4、对Cell对象读写。

下面来看一个动态生成Excel文件的例子：

HSSF读取文件同样还是使用这几个对象，只是把相应的createXXX方法变成了getXXX方法即可。可见只要理解了其中原理，不管是读还是写亦或是特定格式都可以轻松实现，正所谓知其然更要知其所以然。

### 2.4 导出Excel应用实例 ###

在2.3中我们寥寥几行代码实际上就已经就是实现了导出Excel一个简单示例，下面我们在看如何实现导出如图所示的Excel表格？

![170838550954408.png][]

代码如下：（实际开发中应封装到业务层组件中，然后在控制层中调用。这里直接写在控制层组件，如Servlet的doGet/doPost方法或Struts框架的execute方法中）

加下划线这部分代码是B/S模式中采用的输出方式，而不是输出到本地指定的磁盘目录。该代码表示将details.xls的Excel文件通过应答实体（response）输出给请求的客户端浏览器，客户端可保存或直接打开。

### 2.5 样式设置 ###

在实际应用中导出的Excel文件往往需要阅读和打印的，这就需要对输出的Excel文档进行排版和样式的设置，主要操作有合并单元格、设置单元格样式、设置字体样式等。

### 2.5.1单元格合并 ###

使用HSSFSheet的addMergedRegion()方法

参数CellRangeAddress 表示合并的区域，构造方法如下：

构造参数依次表示起始行，截至行，起始列， 截至列。示例代码参照2.4部分

### 2.5.2设置单元格的行高、列宽 ###

### 2.5.2单元格样式 ###

1、创建HSSFCellStyle

2、设置样式

3、将样式应用于单元格

### 2.5.2设置字体样式 ###

1、创建HSSFFont对象（调用HSSFWorkbook 的createFont方法）

2、设置字体各种样式

3、将字体设置到单元格样式

### 2.6 导入Excel应用实例 ###

实现将已存在的Excel文件中的数据导入到系统中的基本步骤同导出十分的类似，关键在于要了解要导入Excel文件的结构，比如数据有哪些列、读取数据起始位置（有效数据从第几行几列开始）等。在实际项目中由于这些数据（Excel文件）往往来自于日常办公人员或其他系统平台产生的业务数据，因此这些Excel文件的数据格式要有统一的要求，并提供访问接口（指访问途径），这样在所需数据的系统中就可通过提供这个访问接口调用方法，从而获得数据。解决方案采用Web Service是不错的选择。这里，我们就以导入2..4所产生的excel表为例，重点掌握如何编写导入Excel代码

<table style="border:1px solid #C0C0C0;"> 
 <tbody> 
  <tr> 
   <td style="border-color:#C0C0C0;border-collapse:collapse;padding:3px;">三、使用java Excel操作Excel文件</td> 
  </tr> 
 </tbody> 
</table>

Java Excel是一开放源码项目，通过它Java开发人员可以读取Excel文件的内容、创建新的Excel文件、更新已经存在的Excel文件。jxl 由于其小巧 易用的特点, 逐渐已经取代了 POI-excel的地位, 成为了越来越多的java开发人员生成excel文件的首选。Java  Excel的特征：

> ● 支持Excel 95-2000的所有版本   
>          ● 生成Excel 2000标准格式   
>          ● 支持字体、数字、日期格式化操作   
>          ● 支持对单元格加阴影和加色彩；
> 
> ● 修改存在的工作表；  
>          ● 支持图像和图表
> 
> ● 日志记录可以定制
> 
> ● 更小更快更省内存

应该说以上功能已经能够大致满足我们的需要。最关键的是这套API是纯Java的，并不依赖Windows系统，即使运行在Linux下，它同样能够正确的处理Excel文件。另外需要说明的是，这套API对图形和图表的支持很有限，而且仅仅识别PNG格式。在线帮助文档[http://jexcelapi.sourceforge.net/resources/javadocs/2\_6\_10/docs/index.html][http_jexcelapi.sourceforge.net_resources_javadocs_2_6_10_docs_index.html]

在这里我们将通过一些实例，学习掌握读取、新建、更新，其中也包括常见格式的设置:字体、颜色、背景、合并单元格等操作，有这些其实已经基本足够应付大部分问题了。

### 3.1环境配置 ###

### 3.1.1下载 ###

下载地址    [http://www.andykhan.com/jexcelapi/][http_www.andykhan.com_jexcelapi]

### 3.1.2 加入jar包 ###

将jxl.jar拷贝到项目的Lib下

### 3.2 使用Java Excel Api 导出 Excel文件 ###

下面我们在看如何使用Java Excel实现导出Excel表格？

<table style="border:1px solid #C0C0C0;width:782px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:12px;min-height:auto;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
   <td style="border-color:#C0C0C0;padding:3px;border-collapse:collapse;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:35px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:12px;min-height:auto;color:rgb(175,175,175);"> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      1 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      2 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      3 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      4 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      5 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      6 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      7 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      8 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      9 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      10 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      11 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      12 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      13 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      14 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      15 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      16 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      17 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      18 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      19 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      20 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      21 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      22 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      23 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      24 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      25 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      26 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      27 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      28 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      29 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      30 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      31 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      32 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      33 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      34 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      35 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      36 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      37 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      38 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      39 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      40 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      41 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      42 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      43 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      44 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      45 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      46 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      47 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      48 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      49 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      50 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      51 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      52 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      53 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      54 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      55 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      56 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      57 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      58 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      59 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      60 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      61 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      62 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      63 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      64 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      65 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      66 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      67 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      68 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      69 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      70 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      71 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      72 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      73 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      74 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      75 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      76 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      77 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      78 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      79 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      80 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      81 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      82 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      83 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      84 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      85 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      86 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      87 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      88 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      89 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      90 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      91 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      92 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      93 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      94 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      95 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      96 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      97 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      98 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      99 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      100 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      101 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      102 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      103 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      104 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      105 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      106 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      107 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      108 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      109 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      110 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      111 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      112 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      113 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      114 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      115 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      116 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      117 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      118 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      119 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      120 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      121 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      122 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      123 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      124 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      125 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      126 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      127 
    </div> 
    <div style="background-image:none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      128 
    </div> 
    <div style="background:rgb(244,244,244) none;border-width:0px 2px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;line-height:1.8em;margin:0px;padding:0px .5em;text-align:right;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
      129 
    </div></td> 
   <td style="border-color:#C0C0C0;padding:3px;border-collapse:collapse;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:12px;min-height:auto;"> 
    <div style="background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//获得输出流，该输出流的输出介质是客户端浏览器</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">OutputStream output=response.getOutputStream();</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">response.reset();</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">response.setHeader(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"Content-disposition"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"attachment;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filename=temp.xls"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">response.setContentType(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"application/msexcel"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//创建可写入的Excel工作薄，且内容将写入到输出流，并通过输出流输出给客户端浏览</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableWorkbook wk=Workbook.createWorkbook(output);</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">///创建可写入的Excel工作表</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableSheet sheet=wk.createSheet(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"成绩表"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">, </code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//把单元格（column, row）到单元格（column1, row1）进行合并。</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//mergeCells(column, row, column1, row1);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.mergeCells(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">, </code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">4</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//单元格合并方法</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//创建WritableFont 字体对象，参数依次表示黑体、字号12、粗体、非斜体、不带下划线、亮蓝色</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableFont titleFont=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableFont(WritableFont.createFont(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"黑体"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">),</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">12</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,WritableFont.BOLD,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">false</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,UnderlineStyle.NO_UNDERLINE,Colour.LIGHT_BLUE);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//创建WritableCellFormat对象，将该对象应用于单元格从而设置单元格的样式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat titleFormat=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat();</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//设置字体格式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">titleFormat.setFont(titleFont);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//设置文本水平居中对齐</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">titleFormat.setAlignment(Alignment.CENTRE);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//设置文本垂直居中对齐</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">titleFormat.setVerticalAlignment(VerticalAlignment.CENTRE);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//设置背景颜色</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">titleFormat.setBackground(Colour.GRAY_25);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//设置自动换行</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">titleFormat.setWrap(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">true</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//添加Label对象，参数依次表示在第一列，第一行，内容，使用的格式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_00=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"学员考试成绩一览表"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,titleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//将定义好的Label对象添加到工作表上，这样工作表的第一列第一行的内容为‘学员考试成绩一览表’并应用了titleFormat定义的样式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_00);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat cloumnTitleFormat=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat();</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">cloumnTitleFormat.setFont(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableFont(WritableFont.createFont(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"宋体"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">),</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">10</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,WritableFont.BOLD,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">false</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">));</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">cloumnTitleFormat.setAlignment(Alignment.CENTRE);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_01=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"姓名"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,cloumnTitleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_11=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"班级"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,cloumnTitleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_21=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"笔试成绩"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,cloumnTitleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_31=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">3</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"上机成绩"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,cloumnTitleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label lab_41=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">4</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"考试日期"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,cloumnTitleFormat);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_01);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_11);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_21);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_31);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(lab_41);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">0</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"李明"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">));</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;">&nbsp;&nbsp;</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Label(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">1</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"As178"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">));</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//定义数字格式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">NumberFormat nf=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">NumberFormat(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"0.00"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat wcf=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat(nf);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//类似于Label对象，区别Label表示文本数据，Number表示数值型数据</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Number numlab_22=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Number(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">78</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,wcf);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(numlab_22);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(newNumber(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">3</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">87</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">NumberFormat(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"#.##"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">) )));</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//定义日期格式</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">DateFormat df=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">DateFormat(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"yyyy-MM-dd hh:mm:ss"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//创建WritableCellFormat对象</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat datewcf=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableCellFormat(df);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//类似于Label对象，区别Label表示文本数据，DateTime表示日期型数据</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">DateTime dtLab_42=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">DateTime(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">4</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,153,0);">2</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">,</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">Date(),datewcf);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">sheet.addCell(dtLab_42);&nbsp;&nbsp; </code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//将定义的工作表输出到之前指定的介质中（这里是客户端浏览器）</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">wk.write();</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,130,0);">//操作完成时，关闭对象，释放占用的内存空间&nbsp;&nbsp; </code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">wk.close();</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">　　加下划线这部分代码是B/S模式中采用的输出方式，而不是输出到本地指定的磁盘目录。该代码表示将temp.xls的Excel文件通过应答实体（response）输出给请求的客户端浏览器，下载到客户端本地（保存或直接打开）。若要直接输出到磁盘文件可采用下列代码替换加下划线这部分代码</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">File file=</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,255);">new</code>&nbsp; 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">File(</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">"D://temp.xls"</code> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">);</code> 
     </div> 
     <div style="background:rgb(244,244,244) none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:12px;min-height:auto;"> 
      <code style="white-space:pre-wrap;background:none;border:0px;float:none;height:auto;line-height:1.8em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:rgb(0,0,0);">WritableWorkbook wwb = Workbook.createWorkbook(file);</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

### 3.3高级操作 ###

### 3.3.1数据格式化 ###

在Excel中不涉及复杂的数据类型，能够比较好的处理字串、数字和日期已经能够满足一般的应用即可。

数据的格式化涉及到的是字体、粗细、字号等元素，这些功能主要由 WritableFont和WritableCellFormat类来负责。例如：

> ① WritableFont font=new WritableFont(WritableFont.createFont("宋体"),12,WritableFont.NO\_BOLD );
> 
> ② WritableCellFormat format1=new WritableCellFormat(font);
> 
> ③ Label label=new Label(0,0,”data 4 test”,format1);

其中

> I.指定了字串格式：字体为宋体，字号16，加粗显示。WritableFont有非常丰富的构造子，供不同情况下使用，jExcelAPI的java-doc中有详细列表，这里不再列出。
> 
> II. 处代码使用了WritableCellFormat类，这个类非常重要，通过它可以指定单元格的各种属性，如上例代码所示。
> 
> III. 处使用了Label类的构造子，指定了显示的位置，文本内容，字串被赋予的格式。
> 
> 与Label类似的Number、DateTime，区别Label表示文本数据；Number表示数值数据，可使NumberFormat格式化数据；用DateTime表示日期型数据，可应用DateFormat格式化数据。

### 3.3.2单元格操作 ###

Excel中很重要的一部分是对单元格的操作，比如行高、列宽、单元格合并等，所幸jExcelAPI提供了这些支持。这些操作相对比较简单，下面只介绍一下相关的API。

1、 合并单元格

2、 行高和列宽

### 3.4 　从Excel文件读取数据表 ###

我们就以导入3.2所产生的excel表为例，掌握如何编写导入Excel代码(该代码封装在业务层方法)

### 3.4 　更新已存在的Excel文件 ###

将3.2所产生的excel表（temp.xls）的第一条记录（excel文件的指第三行）的班级名称改为As179，代码如下：

对于更新已存在的Excel文件实际上就是获取已有工作薄对象（但是只读的），然后将获取的只读的工作薄对象转化为可写入的Excel工作薄对象（WritableWorkbook ），其他部分就是通过可写入WritableSheet 对象和可写入WritableCell 对象进行编辑。  
  
来自：http://blog.csdn.net/jerehedu/article/details/45195359

[Java_Excel]: http://www.cnblogs.com/hanfeihanfei/p/7079210.html
[http_poi.apache.org_index.html]: http://poi.apache.org/index.html
[http_poi.apache.org_apidocs_index.html]: http://poi.apache.org/apidocs/index.html
[http_poi.apache.org_download.html]: http://poi.apache.org/download.html
[170838550954408.png]: /images/20220530/6bfb9874ab6a4eb0871a64d96ab483c2.png
[http_jexcelapi.sourceforge.net_resources_javadocs_2_6_10_docs_index.html]: http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/index.html
[http_www.andykhan.com_jexcelapi]: http://www.andykhan.com/jexcelapi/