//将你要导出的数据放入listList> list = new ArrayList>();try {HttpServletResponse response = ServletActionContext.getResponse();// 创建HSSFWorkbook对象(excel的文档对象)HSSFWorkbook wb = new HSSFWorkbook();// 建立新的sheet对象(excel的表单)HSSFSheet sheet = wb.createSheet("表名");// 在sheet里创建第一行,参数为行索引(excel的行),可以是0~65535之间的任何一个String[] colNameArray = colNames.split(",");HSSFRow rowHeader = sheet.createRow(0);for (int i = 0; i < colNameArray.length; i++) { rowHeader.createCell(i).setCellValue(colNameArray[i]); }// 取出所有有列表数据。String[] colModels = colModel.split(",");for (int i = 0; i < list.size(); i++) {HSSFRow row = sheet.createRow(i + 1);//从第二行开始创建Map map = list.get(i);int k = 0;// 只导出选中的数据。for (String s : colModels) {row.createCell(k++).setCellValue(String.valueOf(map.get(s)));}}// 输出Excel文件OutputStream output;output = response.getOutputStream();response.reset();String exportName="execlExport"+new SimpleDateFormat("yyyyMMdd").format(new Date());String str = new String(exportName.getBytes("gbk"),"ISO-8859-1");response.setContentType("application/vnd.ms-excel;charset=UTF-8"); // 下载文版类型//response.setContentType("application/x-download");response.setHeader("Content-disposition", "attachment; filename=" + str + ".xls");response.setCharacterEncoding("UTF-8");wb.write(output);output.close();} catch(Exception e) {}导出时浏览器会提示下载,可以自己指定保存位置
取消
评论