jxl导不出来_java jxl导出excle但是弹不出对话框，指定路径可以生成excel

OutputStreamfile=response.getOutputStream();Stringfilename="管理员操作日志信息.xls";response.reset();response.setCharacterEncoding("UTF-8");response.setHeader("Content-di...

OutputStream file = response.getOutputStream();

String filename = "管理员操作日志信息.xls";

response.reset();

response.setCharacterEncoding("UTF-8");

response.setHeader("Content-disposition", "attachment; filename="+filename);

response.setContentType("application/msexcel");

//FileOutputStream file = new FileOutputStream("D:/管理员操作日志信息.xls");

//创建一个excel文件

WritableWorkbook wbook = Workbook.createWorkbook(file);

WritableSheet ws = wbook.createSheet("ofbiz admin log", 10);

WritableFont wf = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false,

UnderlineStyle.NO_UNDERLINE,Colour.BLUE);

WritableCellFormat wcf = new WritableCellFormat(wf);

wcf.setVerticalAlignment(VerticalAlignment.CENTRE);

wcf.setAlignment(Alignment.CENTRE);

ws.setRowView(0, 500);

ws.addCell(new Label(0,0,"操作人",wcf));

ws.addCell(new Label(1,0,"行为",wcf));

ws.addCell(new Label(2,0,"时间",wcf));

ws.addCell(new Label(3,0,"IP",wcf));

ws.addCell(new Label(0,1,"管理员",wcf));

ws.addCell(new Label(1,1,"AAAA",wcf));

ws.addCell(new Label(2,1,"2014-07-13",wcf));

ws.addCell(new Label(3,1,"192.169.1.102",wcf));

ws.addCell(new Label(0,2,"管理员",wcf));

ws.addCell(new Label(1,2,"BBBB",wcf));

ws.addCell(new Label(2,2,"2014-07-13",wcf));

ws.addCell(new Label(3,2,"192.169.1.102",wcf));

wbook.write();

wbook.close();

展开