Question

java导出excel问题。

做个java导出excel，在服务器上面能生成*.xls文件，但是下到本地的为啥就xxx.action文件呢？？求解答求解答。在线等
public String createExcelFile(){
PrintWriter out = null;
String forWord="createExcelFile";
scriptId = getRequest().getParameter("scriptId");
maintenanceId = getRequest().getParameter("maintenanceId");
resultOutParam = getRequest().getParameter("resultOutParam");
this.getResponse().setContentType("application/ms-excel;charset=GBK");
this.getResponse().setHeader("content-disposition", "no-cache");
try {
String xlsFilePath = spmServiceCatalogCreateJobManager.getQueryServiceInfoExcel(scriptId, maintenanceId,
resultOutParam, getEmployeeNo(), this.getProjectPath()) ;
out = this.getResponse().getWriter();
out.println("<SCRIPT language=JAVASCRIPT>");
out.println("window.location.href(\"" + this.getProjectPath() + xlsFilePath + "\");");
out.println("</SCRIPT>");
out.flush() ;
//** *写入操作日志** *//*
createLog(Constants.FMP_Excel_out, "导出查询-Excel");
return forWord ;
} catch (Exception e) {
e.printStackTrace();
log.error(e.getMessage());
return ERROR ;
}finally {
out.close();
}
}

Answer 1

java导出Excel java 代码 /* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.axon.fable.sams.view.action; import java.io.IOException; import java.io.OutputStream; import java.util.List; import javax.serv ... java导出Excel例举方式 方法一：导出Excel数据的插件jexcelapi 程序实例如下： public void exportClassroom(OutputStream os) throws PaikeException { try { WritableWorkbook wbook = Workbook.createWorkbook(os); //建立excel文件 WritableSheet wsheet = wbook.createSheet("教室信息表", 0); //工作表名称 //设置Excel字体 WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16, WritableFont.BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); WritableCellFormat titleFormat = new WritableCellFormat(wfont); String[] title = { "教室名", "容 量", "类 型", "其他说明" }; //设置Excel表头 for (int i = 0; i < title.length; i++) { Label excelTitle = new Label(i, 0, title[i], titleFormat); wsheet.addCell(excelTitle); } int c = 1; //用于循环时Excel的行号 ClassroomService cs = new ClassroomService(); List list = cs.findAllClassroom(); //这个是从数据库中取得要导出的数据 Iterator it = list.iterator(); while (it.hasNext()) { ClassroomDTO crdto = (ClassroomDTO) it.next(); Label content1 = new Label(0, c, crdto.getRoomname()); Label content2 = new Label(1, c, crdto.getCapicity().toString()); Label content3 = new Label(2, c, crdto.getRoomTypeId() .toString()); Label content4 = new Label(3, c, crdto.getRemark()); wsheet.addCell(content1); wsheet.addCell(content2); wsheet.addCell(content3); wsheet.addCell(content4); c++; } wbook.write(); //写入文件 wbook.close(); os.close(); } catch (Exception e) { throw new PaikeException("导出文件出错"); } } 方法二：直接用Java代码实现导出Excel报表 /* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */
这样可以么？

Answer 2

你没声明导出的文件格式，网上有很多源码，你自己好好研究研究

追问

恩，设置格式了但是怎么下下来的是xls文件是空白呢。没有内容