excel导出java代码

* 璇曞嵎鏁翠綋鎯呭喌缁熻 excel瀵煎嚭
* @param request
* @throws IOException
* @throws WriteException
*/
public void sjztqktjExcel(HttpServletRequest request) throws IOException, WriteException {
sjfxEntity entity=new sjfxEntity();
HttpSession session = request.getSession(true);
String ksq=String.valueOf(request.getParameter("ksq"));//鑰冭瘯鏈?
String zydm=String.valueOf(request.getParameter("zydm"));//涓撲笟
String kcdm=String.valueOf(request.getParameter("kcdm"));//璇剧▼
String qxdm=String.valueOf(request.getParameter("qxdm"));//鍖哄幙
String zxzzdm=String.valueOf(request.getParameter("zxzzdm"));//鍔╁鍗曚綅
String jtdwdm=String.valueOf(request.getParameter("jtdwdm"));//闆嗕綋鍗曚綅
String kslbdm = (String)request.getSession().getAttribute("kslbdm");

String cd = String.valueOf(request.getParameter("cd"));//鑿滃崟鍚?
boolean ifpage=false;
List list = entity.selectSjztqktj(ksq, zydm, kcdm, qxdm,zxzzdm, jtdwdm, kslbdm,request,ifpage);

String title = "楂樼瓑鏁欒偛鑷鑰冭瘯璇曞嵎鏁翠綋鎯呭喌缁熻琛?;
String filename = "楂樼瓑鏁欒偛鑷鑰冭瘯璇曞嵎鏁翠綋鎯呭喌缁熻琛?;

title += "("+ksq+")";
filename += "_"+ksq+".xls";

//鏂囦欢璺緞
String filepath = request.getRealPath("/") + "download\\excel\\jsxkhzb\\";

File file = new File(filepath);
filepath = filepath + filename;
if (!file.exists()) {
file.mkdirs();
}

WritableWorkbook workbook = Workbook.createWorkbook(new File(filepath));

try {
WritableSheet sheet = workbook.createSheet(cd, 0);
sheet.setPageSetup(PageOrientation.PORTRAIT,PaperSize.A4,0,0);
sheet.getSettings().setLeftMargin(0.5);
sheet.getSettings().setRightMargin(0.5);

WritableCellFormat style = null;
style = new WritableCellFormat();
style.setAlignment(Alignment.CENTRE);
style.setVerticalAlignment(VerticalAlignment.CENTRE);
style.setBorder(Border.ALL, BorderLineStyle.THIN);
style.setBackground(Colour.WHITE);
style.setWrap(true);

WritableCellFormat style_t = null;
W

ritableFont font_t = null;
font_t = new WritableFont(WritableFont.ARIAL, 14, WritableFont.BOLD,
false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
style_t = new WritableCellFormat(font_t);
style_t.setAlignment(Alignment.CENTRE);
style_t.setVerticalAlignment(VerticalAlignment.CENTRE);
style_t.setBorder(Border.ALL, BorderLineStyle.NONE);
style_t.setBackground(Colour.VERY_LIGHT_YELLOW);
style_t.setWrap(true);

//鍚堝苟14鍒?鏍囬
sheet.mergeCells(0, 0, 14, 0);
sheet.addCell(new Label(0, 0, title, style_t));

Label label_1 = new Label(0, 1, "璇剧▼浠ｇ爜", style);
sheet.addCell(label_1);

Label label_2 = new Label(1, 1, "璇剧▼鍚嶇О", style);
sheet.addCell(label_2);

Label label_3 = new Label(2, 1, "鎶ヨ€冧汉鏁?, style);
sheet.addCell(label_3);

Label label_4 = new Label(3, 1, "瀹炶€冧汉鏁?, style);
sheet.addCell(label_4);

Label label_5 = new Label(4, 1, "鍚堟牸浜烘暟", style);
sheet.addCell(label_5);

Label label_6 = new Label(5, 1, "鍚堟牸鐜?, style);
sheet.addCell(label_6);

Label label_7 = new Label(6, 1, "骞冲潎鍒?, style);
sheet.addCell(label_7);

Label label_8 = new Label(7, 1, "涓昏棰樺钩鍧囧垎", style);
sheet.addCell(label_8);

Label label_9 = new Label(8, 1, "瀹㈣棰樺钩鍧囧垎", style);
sheet.addCell(label_9);

Label label_10 = new Label(9, 1, "鏈€楂樺垎", style);
sheet.addCell(label_10);

Label label_11 = new Label(10, 1, "鏈€浣庡垎", style);
sheet.addCell(label_11);

Label label_12 = new Label(11, 1, "鍏ㄨ窛", style);
sheet.addCell(label_12);

Label label_13 = new Label(12, 1, "鏍囧噯宸?, style);
sheet.addCell(label_13);

if(list!=null && list.size()!=0)
{
for(int i=0;iMap map = (Map)list.get(i);
int count = i+1;

String classno = String.valueOf(map.get("")==null?"":map.get(""));
String classname = String.valueOf(map.get("")==null?"":map.get(""));
String examperon = String.valueOf(map.get("")==null?"":map.get(""));
String realityperson = String.valueOf(map.get("")==null?"":map.get(""));
String qualifiedpersion = String.valueOf(map.get("")==null?"":map.get(""));
String standardscore = String.valueOf(map.get("")==null?"":map.get(""));
String avgscore = String.valueOf(map.get("")==null?"":map.get(""));
String zgtscore = String.valueOf(map.get("")==null?"":map.get(""));
String kgtscore = String.valueOf(map.get("")==null?"":map.get(""));
String maxscore = String.valueOf(map.get("")==null?"":map.get(""));
String minscore = String.valueOf(map.get("")==null?"":map.get(""));
String allli = String.valueOf(map.get("")==null?"":map.get(""));
String qualifie = String.valueOf(map.get(""));
String biaozhun=String.valueOf(map.get("")==null?"":map.get(""));
if(qualifie==null||qualifie.equals("")||qualifie.equals("null")){
qualifie = "";
}else{
qualifie += "%";
}
sheet.addCell(new Label(0, i + 2, classno, style));
sheet.addCell(new Label(1, i + 2, classname, style));
sheet.addCell(new Label(2, i + 2, examperon, style));
sheet.addCell(new Label(3, i + 2, realityperson, style));
sheet.addCell(new Label(4, i + 2, qualifiedpersion, style));
sheet.addCell(new Label(5, i + 2, qualifie, style));
sheet.addCell(new Label(6, i + 2, avgscore, style));
sheet.addCell(new Label(7, i + 2, zgtscore, style));
sheet.addCell(new Label(

8, i + 2, kgtscore, style));
sheet.addCell(new Label(9, i + 2, maxscore, style));
sheet.addCell(new Label(10, i + 2, minscore, style));
sheet.addCell(new Label(11, i + 2, allli, style));
sheet.addCell(new Label(12, i + 2, biaozhun, style));
}
}
//琛ㄦ牸瀹藉害璁剧疆
sheet.setRowView(0,500);

sheet.setColumnView(0,10);
sheet.setColumnView(1,10);
sheet.setColumnView(2,10);
sheet.setColumnView(3,10);
sheet.setColumnView(4,10);
sheet.setColumnView(5,10);
sheet.setColumnView(6,10);
sheet.setColumnView(7,10);
sheet.setColumnView(8,10);
sheet.setColumnView(9,10);
sheet.setColumnView(10,10);
sheet.setColumnView(11,10);
sheet.setColumnView(12,10);

//璁剧疆鎵撳嵃澶?
sheet.getSettings().setPrintTitlesRow(0, 1);
//sheet.setPageSetup(https://www.doczj.com/doc/7a1753584.html,NDSCAPE,PaperSize.A4,0,0);//妯悜鎵撳嵃
sheet.getSettings().setLeftMargin(0.5);
sheet.getSettings().setRightMargin(0.5);
sheet.getSettings().setTopMargin(0.5);
sheet.getSettings().setBottomMargin(0.5);
sheet.getSettings().setFooterMargin(0.2);
sheet.getSettings().setHorizontalCentre(true);

HeaderFooter hf = new HeaderFooter();
Contents ct = hf.getRight();
ct.append("鍏?");
ct.appendTotalPages();
ct.append(" 椤?绗?");
ct.appendPageNumber();
ct.append(" 椤?);
sheet.getSettings().setFooter(hf);
//Iprecord.InsertIprecord(request, "鏂囦欢瀵煎嚭","鏂囦欢::"+filename+"::瀵煎嚭鎴愬姛");
}
catch (Exception e) {
//Iprecord.InsertIprecord(request, "鏂囦欢瀵煎嚭","鏂囦欢::"+filename+"::瀵煎嚭澶辫触");
e.printStackTrace();
}finally{

workbook.write();
workbook.close();
}
request.setAttribute("FILENAME",filename);
request.setAttribute("FILEPATH",request.getRealPath("/") + "

download\\excel\\sjztqktj\\");

}