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,