poi导出excel清晰 步骤详解

一、本次生成excel应用场景描述如下：
用户需要下载某个业务大量数据
友情链接（poi解析excel）：http://patronli.iteye.com/blog/2330524

二、示例代码如下所示：

<pre name="code" class="java">
package com.patronli.action;

import java.util.ArrayList;
import java.util.List;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

import org.apache.struts2.ServletActionContext;

import com.sssoft.framework.web.report.xls.ExcelSupport;

public class testAction {
public void doDownLoad() {
// 根据用户条件找到数据源，例如下所示
List&lt;patronli&gt; list = new ArrayList&lt;patronli&gt;();
// 定义excel的名字
WritableWorkbook workbook = ExcelSupport.getWorkbook("excel模板",
ServletActionContext.getResponse());
// 定义当前sheet的名字及位置(在当前workbook创建sheet)
WritableSheet sheet = workbook.createSheet("sheet1", 0);
// 定义数据的字体
WritableFont font1 = new WritableFont(WritableFont.createFont("微软雅黑"),
10, WritableFont.BOLD);
WritableCellFormat wcf = new WritableCellFormat(font1);
// 定义excel的表头
String[] pjTitles1 = { "序号", "时间", "订单编号" };
try {
for (int i = 0; i &lt; pjTitles1.length; i++) {
// 第几列，第几行，字段值，字体属性等
sheet.addCell(new Label(i, 0, pjTitles1[i], wcf));
}
for (int i = 0; i &lt; list.size(); i++) {
patronli temp = list.get(i);
String num = String.valueOf(i + 1);
sheet.addCell(new Label(0, i + 1, num, wcf));
sheet.addCell(new Label(2, i + 1, temp.getts(), wcf));
sheet.addCell(new Label(3, i + 1, temp.getOrder(), wcf));
}
ExcelSupport.writeWorkbook(workbook);
} catch (RowsExceededException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

</pre>