Java 导出excel（二）

import java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.Map;
 
import javax.servlet.http.HttpServletRequest;
 
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
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 com.hbkjsf.susheguanli.fygl.FyglEntity;
import com.hbkjsf.susheguanli.log.Log;
import com.hbkjsf.susheguanli.wjjlgl.WjjlglEntity;
import com.hbkjsf.susheguanli.xsjbxxgl.XsjbxxglEntity;
 
/**
* 模块描述：宿舍卫生管理
*
* @author wuyu
*
*/
public class SswsglDeal {
 
 
 
/**
* 功能描述：生成EXCEL
* @param request
* @param ssid
* @param wsrq
*/
public static void createExcel(HttpServletRequest request, String ssid,
String wsrq) {
SswsglEntity entity = new SswsglEntity();
List list = entity.findAll(ssid, wsrq);
 
String fileName = "";
 
String filePath = "/excel/";
 
File file = new File(String.valueOf(request.getRealPath("/"))
+ filePath);
 
if (!file.exists()) {
file.mkdirs();
}
 
fileName = "宿舍卫生信息一览表" + ".xls";
 
// getRealPath()方法取得根目录路径
filePath = String.valueOf(request.getRealPath("/")) + filePath
+ fileName;
 
// 开始创建EXCEL文件
try {
// 定制字体样式 20:代表字体大小 arial:字体 bold:是否加粗
WritableFont font = new WritableFont(WritableFont.ARIAL, 10,
WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,