Question

java生成excel到指定路径不弹出选择路径的哪个对话框直接存到指定的路径？？谢谢 谁会啊

public ActionForward exportEntrypersonList(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception{
FileOutputStream os = null;
String fileName = "入职人员审批.xls";
response.setContentType("application/msexcel;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment;filename="+java.net.URLEncoder.encode(fileName,"UTF-8"));
response.addHeader("Pargam", "no-cache");
response.addHeader("Cache-Control", "no-cache");
os = new FileOutputStream("D:/入职人员审批.xls");
this.createEntrypersonListExcel(os,request);
os.flush();
if(os!=null){
os.close();
}
return null;
}

private void createEntrypersonListExcel(OutputStream os,HttpServletRequest request) throws Exception{

Map<String,Object> params=new HashMap<String, Object>();
String recruitType=request.getParameter("recruitType");
Date currentDate=new Date();
SimpleDateFormat sdfc=new SimpleDateFormat("yyyy-MM");
params.put("currentDateforExcel", sdfc.format(currentDate));

List<EmpcEntrypersonApprovalInfo> retiredList = new ArrayList<EmpcEntrypersonApprovalInfo>();
PaginationHelper pageInfo = new PaginationHelper(request);
pageInfo = service.queryEntrypersonApproval(params,pageInfo);
retiredList=pageInfo.getResultList();
HSSFWorkbook workBook = new HSSFWorkbook();
HSSFSheet sheet = workBook.createSheet("入职人员单表");
//设置表头style
样式省略了！！
String[] titleArr = new String[]{"组织","姓名","身份证号","入职日期","毕业院校","学历","专业","状态","不符合用工条件"};
//Header
HSSFRow row = sheet.createRow(0);
for (int i = 0; i < titleArr.length; i++) {
HSSFCell headerCell = row.createCell(i);
headerCell.setCellStyle(headerCellStyle);
headerCell.setCellValue(titleArr[i]);
}
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-mm-dd");
//Body
if(retiredList != null){
for (int j = 0; j < retiredList.size(); j++) {
HSSFRow contentRow = sheet.createRow(j+1);
EmpcEntrypersonApprovalInfo info = retiredList.get(j);
String[] bodyArr = new String[]{info.getBatchNum(),info.getEmpName(),info.getNationalIdentifier(),sdf.format(info.getJoinCucDate()),info.getUniversity(),info.getEducation(),info.getSpecialty(),info.getAppStatus(),info.getRemark()};
for (int i = 0; i < bodyArr.length; i++) {
HSSFCell cell = contentRow.createCell(i);
cell.setCellStyle(bodyCellStyle);
cell.setCellValue(bodyArr[i]);
}
}
for(int m=0;m< titleArr.length;m++){
sheet.autoSizeColumn(m,true);
}
}
workBook.write(os);
}
已经解决，谢谢各位！！！

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏15（财富值+成长值）

Answer 1

下载文件，是否弹出由浏览器决定。。。。。。现在的BS结构中，想浏览器不弹出就能保存到指定的电脑路径，就是黑客了。。。。。。。要做到得写自己的客户端。

追问

直接导出excel到指定目录这样可以吗？

追答

凡是通过浏览器，都不能———除非使用APPLET、并且权限非常大（系统非常不安全，现在的浏览器一般不允许的）

Answer 2

怎么解决的，可以说下吗？